AW: SQL Next Sequence

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