Re: ESQL/C vs. SQLDA

David Kosenko wrote: > > Mike Segel <mikey@segel.NOSPAM-.KING.OF.MYDOMAIN.-NOSPAM.com> offerred: > +Uhm, > +I just built an sqlda struct based on the info stored in the sys tables. > +That way you can build dynamic query structures on the fly. > > Problem is, that doesn't always work. For example, syscolumns.collength is not > simply the length of the data for all columns, e.g. datetimes have the max and min > qualifiers mapped into the value. > > Dave Ah Dave, Informix has to store that information in their sysmaster tables in order to manage the database no? ;-) My point was, that you can use the sysmaster info to do things dynamically along with a meta database to describe your data that is outside of Informix. Based on the datatype, you will know if you have to query other information in order to correctly build that data structure. I'm sorry but I thought that it was obvious. The point I was trying to make was that you can do dynamic SQL using the SQLDA by using Information already in the sysmaster table structures. --Mikey -- #include <std_disclaimer.h> /* Mike Segel (MS385) */ #include <No_Spam.h> #ifdef OFFENDED_BY_CONTENT The author takes no responsibility for this post. Any resembalence to a coherent rational thought is purely coincidence. -The Management. #endif ***************************** * Attention * -*- Due to AGIS's Refusal to Act Responsibly -*- Due to ACSI's Refusal to Act Responsibly We are blocking all of their domains at the packet level. This block will exist until they modify their policies to conform to existing RFCs and net community standards. We encourage all ISPs and domain holders to do the same. *****************************