Re: where is SQLDATA?

[Sam_L <lennon_s_j@xxxxxxxxxxx>]

I'm not totally sure that I understand what you are trying to do...  For 
example, SQLDATA is defined where?

However, you probably need something like
exec sql fetch first from c1 into :SQLDATA
so SQL knows where to put the data.

It you are just beginning with embedded SQL, you might want to take a 
look at this article:
https://www.itjungle.com/2005/08/10/fhg081005-story01/

Here's another about handling the return codes:
https://www.mcpressonline.com/programming/sql/techtip-sqlcod-endoffile-gotcha

Sam

On 10/13/2017 12:56 PM, Jay Vaughn wrote:
> given the following scenario, how do I extract the values from SQLDATA?
>
> exec sql
> prepare s1_select from :g_sqlstmt;
>
> exec sql
> declare c1 scroll cursor for s1_select;
>
> exec sql open c1;
>
> exec sql fetch first from c1;
>
>
> My attempt is...
>
>
> exec sql include sqlda;
> exec sql describe s1_select into :sqlda;
>
> for i = 1 to sql_num;
>
> sqlvar = sql_var(i);
> if sqlname = ' ';
> leave;
> endif;
>
> SQLDATA???? contains null when the fetch did indeed fetch a record.

---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus