SEO

#1 (**permalink**) 02-27-2008, 01:50 AM

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

#2 (**permalink**) 02-27-2008, 01:50 AM

In article <4161021a@news.uni-ulm.de>, Jan Suchanek
(jan.suchanek@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'

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

Using sequences from external programms