RE: Determining the Datatype of a Column

Posted in 2012

Art S. Kagel — Thu, 16 Aug 2012 09:05:39 -0400 — source: Usenet: comp.databases.informix

Check out describe. You would prepare a select statement then DESCRIBE it either into a descriptor or an sqlda structure which will contain the type for each column lIsted in the projection clause of the select. There are examples in the demo directory under INFORMIXDIR. Or download my utils2_ak package from the IIUG software repository and look at the code for sqlstruct.ec. There is another method in the destruct.ec utility as well. More brute force. Art Sent from my Galaxy S®IIIFrancesco Alfano <edacedpa@yahoo.it> wrote:Hi, How can I determine, in ESQL, the datatype of the columns in a table without first usign a SELECT statement ? I'm looking for a sample code that implements a statement like "INFO COLUMNS FOR ..." Thanks for your response. _______________________________________________ Informix-list mailing list Informix-list@iiug.org http://www.iiug.org/mailman/listinfo/informix-list