Re: How can I do the following using execute immediate?

Daniel has the correct syntax with the parameter marker...

Didn't mean to mislead you, I shouldn't try to answer questions quickly at
the end of the day. :)

Charles

On Mon, Feb 28, 2022 at 3:43 PM Daniel Gross <daniel@xxxxxxxx> wrote:

You can use something similar to „into“ with dynamic SQL:

sqlStr = ‘values (select count(*) …) into ?‘;
exec sql prepare stmt from :sqlStr;
exec sql execute stmt using :wCount;

I use this technique all the time.

HTH
Daniel

Von meinem iPhone gesendet

Am 28.02.2022 um 22:52 schrieb dfreinkel@xxxxxxxxxxxxxxxxx:

I need to scan a source member and so I have to process the members. The
member name is random so it cannot be performed as a standard SQL

statement.

The SQL command would be:



Select count(*) into :wCount

From qtemp.alias

Where srcdta like '%some_value%';



I am using EXECUTE IMMEDIATE :wcommand.



How does one code the command to get the execute immediate to return the
value of count into :wCount?



TIA,

Darryl Freinkel

A4G

Telephone: 770.321.8562 Mobile: 678.355.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.

Help support midrange.com by shopping at amazon.com with our affiliate

link: https://amazon.midrange.com

--
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.

Help support midrange.com by shopping at amazon.com with our affiliate
link: https://amazon.midrange.com