Re: SQL Next Sequence

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

I created a sequence using CREATE SEQUENCE.  I want to retrieve the next
value.   The problem is that my sequence name is in a variable.

On Fri, Jun 1, 2018 at 1:09 PM, Justin Taylor <JUSTIN@xxxxxxxxxxxxx> wrote:

> Are you talking about the value for an auto-generated identity column?  I
> know you can get the value you just generated like this:
> EXEC SQL  values identity_val_local() into :hostVariable;
>
> If you want the next value that hasn't been generated, then I don't know
> about that.
>
>
>
> -----Original Message-----
> From: Art Tostaine, Jr. [mailto:atostaine@xxxxxxxxx]
> Sent: Friday, June 01, 2018 11:46 AM
> To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
> Subject: 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