db2 sequence object

sgogula · #1 (**permalink**) 07-09-09, 11:22

how do i access db2 sequence object to generate a unique sequence number?

sathyaram_s · #2 (**permalink**) 07-09-09, 11:39

Nextval For Seqname

sgogula · #3 (**permalink**) 07-09-09, 15:16

Quote:

Originally Posted by sathyaram_s

Nextval For Seqname

I dont know why this doesn't work for me in data studio. can i retrieve this using sql query like ' select Nextval for seq_name; ?

n_i · #4 (**permalink**) 07-09-09, 16:04

Quote:

Originally Posted by sgogula

can i retrieve this using sql query like ' select Nextval for seq_name; ?

No, because this is an incomplete SQL query; it must have at least a FROM clause. Try "values nextval for seq_name" instead.

sathyaram_s · #5 (**permalink**) 07-09-09, 17:14

or if you want to use SELECT, you can do

SELECT NEXTVAL FOR SEQNAME FROM SYSIBM.SYSDUMMY1

Cheers
Sathyaram

sgogula · #6 (**permalink**) 07-09-09, 22:18

Quote:

Originally Posted by sathyaram_s

or if you want to use SELECT, you can do

SELECT NEXTVAL FOR SEQNAME FROM SYSIBM.SYSDUMMY1

Cheers
Sathyaram

Thanks Sathyaram for the solution. This works perfectly.