Re: exec into question

[tim <iseriesstuff@xxxxxxxxx>]

thank you sir. worked great!!!


On 7/20/2018 12:55 PM, Charles Wilt wrote:
> 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