Re: SQL DESCRIBE was( SQLRPGLE - Dynamic selection)

[Frank.Kolmann@xxxxxxxxxx]

Thanks Carel,
Yet again my mind boggles as I try to grasp the implications.
Perhaps it is possible to not even know the file structure
that the SQL operates on, then from the info in SQLDA get the
file layout information.
Once the file layout is known what does the FETCH fetch into?
I usually use a set of fields or a DS.  Can I FETCH into an
unformatted space then parse the data according to the SQLDA.

DESCRIBE  would have to be some sort of generic SQL that can read
any file. I have once done something similiar in RPG before
vary and float field types.

I dont see many applications for DESCRIBE, or am I completely off
the scent.
(mind unwarping from the 4th dimension, what a relief)
(gee the last Star Trek movie was such a dissapointment)

Frank Kolmann

*********** REPLY SEPARATOR  ***********
from: "Carel Teijgeler" <coteijgeler@xxxxxxxxx>
subject: Re: SQL DESCRIBE was( SQLRPGLE - Dynamic selection)

Frank,

DESCRIBE returns information on the result set of the query statement:
number of columns in the result set, the data types and length of each
column in the result set.

This is based on the QSQPRCED API; info can be retrieved with the SQLDA
data structure.

Regards,
Carel Teijgeler

*********** REPLY SEPARATOR  ***********

On 26-2-03 at 8:20 Frank.Kolmann@xxxxxxxxxx wrote:

>I am fairly familiar with SQL, but one thing eludes me.
>I read the manuals, thats where I get my information
>but I just cannot comprehend what the SQL DESCRIBE is
>for.