Re: How do I do a EXECUTE IMMEDIATE with a declare?

Hi Darryl,

what you want is a cursor declaration for a dynamic statement?

wSql = 'select ... from ...';
exec sql prepare stmSql from :wSql;
exec sql declare csrSql cursor for stmSql;
exec sql open csrSql;

This should work.

AFAIK you cannot declare with execute immediate.

HTH
Daniel



Von meinem iPhone gesendet

Am 23.01.2024 um 20:10 schrieb dfreinkel@xxxxxxxxxxxxxxxxx:

I have not done this in ages and do not remember the details or have a
program as an example.



I need to use a combination of a SQL DECLARE with a EXECUTE IMMEDIATE.



My program will not compile.



Example:

wSql = 'DECLARE FILE scroll cursor for select';

exec sql execute immediate :wSql;



TIA,



Darryl Freinkel

A4G

Telephone: 770.321.8562



--
This is the RPG programming on IBM i (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/rpg400-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related questions.