Re: exec into question

Not with static SQL...

Dynamic yes...but select into is not supported, you have to use values into.

wSqlStmtm = 'values(select count(*) from claims where '
+ whereStr
+ ' ) into ?';

exec sql
prepare countClaims from :wSqlStmt;

exec sql
execute countClaims using :cnt;

Charles



On Fri, Jul 20, 2018 at 10:17 AM tim <iseriesstuff@xxxxxxxxx> wrote:

i have the following:

exec sql SELECT count(*)
into :cnt
FROM claims;


i would like to do the following (variable where build from field)

wherestr = 'number = 100'

exec sql SELECT count(*)
into :cnt
FROM claims
where :wherestr


can this be done somehow?


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

Please contact support@xxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: http://amzn.to/2dEadiD