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

In article <380E138A.E9E44E43_at_bloomberg.net>,   kagel_at_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. Received on Sun Oct 24 1999 - 07:06:42 CDT