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

[Charles Wilt <charles.wilt@xxxxxxxxx>]

SELECT INTO can only be used for static SQL...

Use VALUES INTO instead

VALUES (SELECT count(*) from From qtemp.alias Where srcdta like
'%some_value%')  into :wCount)

Once you get bit by this a couple (dozen) times, you'll just remember. :)

HTH,
Charles


On Mon, Feb 28, 2022 at 2:52 PM <dfreinkel@xxxxxxxxxxxxxxxxx> wrote:

> 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