Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
Art S. Kagel — — 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
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.