Using sequences from external programms

[Jan Suchanek]

Hello,

I just want to get the next value in a sequence in an external
programm/script
Just use

select nextval ('list_seq') ;

(like in PostgreSQL) does not work...
and

select (NEXTVAL FOR SEQ_TOUR_NUMBER)
does not work either.

So how do I get the next sequence number from an existing sequnece object.

Thanks, Jan

[Gert van der Kooij]

In article <41******@news.uni-ulm.de>, Jan Suchanek
(ja**********@gmx.de) says...

Hello,

I just want to get the next value in a sequence in an external
programm/script
Just use

select nextval ('list_seq') ;

(like in PostgreSQL) does not work...
and

select (NEXTVAL FOR SEQ_TOUR_NUMBER)
does not work either.

So how do I get the next sequence number from an existing sequnece object.

Thanks, Jan

'VALUES NEXTVAL FOR id_values' or
'select nextval for org_seq from sysibm.sysdummy1'