Re: SQL cursor defined two different ways?

"RPG400-L" <rpg400-l-bounces@xxxxxxxxxxxx> wrote on 11/30/2016 12:01:27
PM:

"RPG400-L" <rpg400-l-bounces@xxxxxxxxxxxx> wrote on 11/30/2016 11:51:47
AM:

I'm wondering if this is possible ... so far the compiler is saying

no.

I have a two different queries that return the same type of data. I
would like to be able declare a cursor for the two different
queries, conditional on a parameter, and then just spin through the

results.

Not in static SQL, no. Change to dynamic SQL and then, yes.

By the way, here is a mock up (minus error checking) of what it
would look like in dynamic SQL.

if var1 <> *blank;
iField1 = var1;
sqlstmt = 'select FIELD2 +
from FILE1 +
where FIELD1 = ?';
else;
iField1 = var2;
sqlstmt = 'select FIELD2 +
from FILE1 +
inner join FILE2 +
on FILE1.FIELD3 = FILE2.FIELD4 +
where FIELD5 = ?';
endif;

exec sql prepare myStatement
attributes :FOR_READ_ONLY
from :sqlstmt;

exec sql declare myCursor cursor
for myStatement;

exec sql open myCursor
using :iField1;


Sincerely,

Dave Clark