Re: SQLDA, Dynamic SQL Method 4 and output host variables

In article <380E138A.E9E44E43@bloomberg.net>, kagel@bloomberg.net wrote: > Alex Vinokur wrote: [snip] > > 1. Do *Dynamic SQL Method 4* and > > *SQLDA (SQL Descriptor Area)* > > enable to gain it? > > Yes. You can use the DESCRIBE statement to describe into either an sqlda > data structure (Informix specific but more flexible) or into a DESCRIPTOR > which is portable. See the ESQL/C Manual for details. > > > 2. If they do enable to do it > > { > > Do we have to use bind variables or another types? > > How to use relevant types? > > } > > You can FETCH the data into any memory you want, predefined host variables > or malloc() memory as you want. You can see the manual. > > > > > Any hints and examples would be appreciated. > > For examples see the samples directory or any of the many ESQL/C utilities > in the IIUG Software Repository. Jonathan Leffler's sqlcmd or any of my > utilities in utils2_ak show good use of sqlda dymamic queries. > > Art S. Kagel > 1. Thank you very much for your helpful information. 2. Example $ORACLE_HUME/precomp/demo/proc/sample12.pc is also helpful. Alex Sent via Deja.com http://www.deja.com/ Before you buy.