Re: [HACKERS] Embedded SQL question

On Tue, Feb 09, 1999 at 10:14:26AM +0100, Zeugswetter Andreas IZ5 wrote:
> 
> free is the opposite to prepare, a statement stays prepared until free is
> called.
> This will release all associated resources. In my Informix manual it sais,
> that 
> it will not affect an already declared cursor on this statement.
> 
> exec sql prepare d_id from :stmt;
> ....
> exec sql free d_id; 

Oh, that's easy. :-) I already have it with the standard syntax 'exec sql
deallocate prepare'.

>     > exec sql alloc
> 
> All I find for this is:
> exec sql allocate descriptor :descname [with max :colmax];
> allocates memory for a system descriptor area  (sqlca) for a maximum of
>     colmax columns (default 100) for use with a describe statement.

Guess this has to wait some more.

Michael
-- 
Michael Meskes                         | Go SF 49ers!
Th.-Heuss-Str. 61, D-41812 Erkelenz    | Go Rhein Fire!
Tel.: (+49) 2431/72651                 | Use Debian GNU/Linux!
Email: Michael.Meskes@gmx.net          | Use PostgreSQL!