Re: SQL Next Sequence

["Art Tostaine, Jr." <atostaine@xxxxxxxxx>]

Not sure yet how to do that with my sequence name in variable.

thanks, Art

On Fri, Jun 1, 2018 at 12:54 PM, Hauser <Hauser@xxxxxxxxxxxxxxx> wrote:

> Select. .. Intoleranz cannot be used in composition with dynamic SQL. You
> either need a Cursor or values ... into.Birgitta
>
>
> Von meinem Samsung Gerät gesendet.
>
> -------- Ursprüngliche Nachricht --------
> Von: "Art Tostaine, Jr." <atostaine@xxxxxxxxx>
> Datum: 01.06.18  18:45  (GMT+01:00)
> An: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
> Betreff: SQL Next Sequence
>
> How can I retrieve the next sequence into an RPG variable?
>
> Tried this but it's not right :-)
>
> wSqlSelect = 'select next value for  ' + USER +
>                     'from SYSIBM.SYSDUMMY into :counter';
> exec sql execute immediate :wSqlSelect;
>
>
> Thanks
> --
> Art Tostaine
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: https://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at https://archive.midrange.com/midrange-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
>
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: https://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at https://archive.midrange.com/midrange-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