Re: where is SQLDATA?

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