where is SQLDATA

[jayvaughn]

lets say i have built an sql statement...

'select * from SRVACHI where ACI010 = '12' and ACI015 = '123
and ACI085 = '123' order by ACI010, ACI015, ACI085'

i then want to pull the very first row information out and examine it...

I'm doing it as such, below... but I am getting a -822 sqlcode on the fetch...


exec sql include sqlda;

exec sql
prepare s1_select from :g_sqlstmt

exec sql
exec sql describe s1_select into :sqlda using system names;

exec sql
declare c1 cursor for s1_select;

exec sql
open c1;

exec sql
fetch next from c1 using descriptor :sqlda;

what am I missing?



I intend to examine it as...

for i = 1 to sql_num;

sqlvar = sql_var(i);
if sqlname = ' ';
leave;
endif;

endfor;

[Rocky]

SQLDATA is included by the pre-compiler - you don't include it. I'm not familiar with the describe step you have in your code nor with how you're trying to use SQLDA - I typically specify the variable name(s) that I'm fetching data into or a data structure with those fields.

[jayvaughn]

thanks - this is dynamic sql where that sql select statement was built without know the file or columns... so yes, you approach works when you know the file and columns you are working with at the time of programming.

[Rocky]

Interesting - at any rate to answer your question SQLDATA and what not are inserted as part of the spool file from the compile you will see them.

[B.Hauser]

Did you set SQL_NUM to the maximum values that could be received befofe including the SQLDA?
Something like this:

  Dcl-C SQL_NUM   Const(100);
  Exec SQL Include SQLDA;

Birgitta

[jayvaughn]

Birgitta... to clarify my dilemma and clarify what I have, i just created a new post called dynamic sql - receive fetched row values into host variables - if you can take a look at that one, it will probably make more sense.

[tomliotta]

I'm doing it as such, below... but I am getting a -822 sqlcode on the fetch...

Hard to tell. Is this all default SQLDA stuff? Or did you create it all? Is this the same program in the other posts? If you created it, we need to see all of the definitions.

The title says "Where is SQLDATA". Does that mean 'where is the field named SQLDATA', or is it 'where is the data pointed to by SQLDATA'?

[jayvaughn]

Tom. Yes. All of these post with similar topics regarding sqlda and descriptors are resolved. As you can tell there has been much confusion on my end in which I have finally got a grasp on.