RE: Dnamic SQL question

["Carel Teijgeler" <coteijgeler@xxxxxxxxx>]

Ali,

Again from memory, and unlucky for you, it is weekend.

SQLDA contains an array, each element reference a field in the  result set.

With the API I use I have to use a pointer to a variable where the value of the 
field will be stored. Hence, I created an array,  apptly called ResultSet and 
have a subfield for each data type available defined, like

Resultset                DS                              DIM(xx)
    CharValue                                  32
    PackValue                                 30 P  9
    ZonedValue                                30 P  9
 etc..

In the SQLDA I put a %adr(Charvalue(SQLIx)), based on the data type of the 
column in the resultset which I have described with the Describe function.

I do not think SQLDA for the API is different for embedded SQL.

I hope this will help (a little).

Regards,
Carel Teijgeler.

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

On 8-8-03 at 16:32 Ali Ekinci wrote:

>Thanks for all the information. 
>I now understand how Dynamic SQL is handled using SQLDA. One remaining
>thing I need to know is How to get the numeric data from SQLDATA. To get
>the character data I can use  charData=%str(SQLADATA:SQLLEN)
>What is it I need to do extract numeric value into a numeric variable?
>something like numericData=%num(SQLDATA:Precision:Scale) numericData is (30,9)