Re: exec into question

[Charles Wilt <charles.wilt@xxxxxxxxx>]

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