467,923 Members | 1,850 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 467,923 developers. It's quick & easy.

Using sequences from external programms

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
  • viewed: 1989
Share:
1 Reply
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.

Similar topics

10 posts views Thread by Vilson farias | last post: by
1 post views Thread by J.Haan | last post: by
7 posts views Thread by pfa | last post: by
5 posts views Thread by nummertolv | last post: by
4 posts views Thread by JJ | last post: by
5 posts views Thread by lancer6238 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.