By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,589 Members | 2,255 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,589 IT Pros & Developers. It's quick & easy.

Using sequences from external programms

P: n/a
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
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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'
Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.