Sequences in db2 8.1.0.36.

[Ayusman]

Hi All,
I am using IBM db2 version: 8.1.0.36.

The following code:

insert into t values (next value for s)
[
WHERE t is a table with single column of integer type.
s is a sequence I creates, which shows in the sysibm.syssequences.
]
gives me error saying "for" is an unidentified token.

When I run the same query in db2 8.1.7 it runs well.

Can any one please say what is the problem?
How can I use Sequence in db2???

Thanks and regards.
Ayusman
--
Ayusman
------------------------------------------------------------------------
Ayusman's Profile: http://www.dbtalk.net/m98
View this thread: http://www.dbtalk.net/t296807

[Peri]

Ayusman ,
Seems like u have encountered minor syntactical error
Ayusman wrote:

insert into t values (next value for s)
[
WHERE t is a table with single column of integer type.
s is a sequence I creates, which shows in the sysibm.syssequences.
] It should have been
insert into t values (NEXTVAL for s)
Much of the information can be found at
http://publib.boulder.ibm.com/infoce...d/c0007007.htm
gives me error saying "for" is an unidentified token.

When I run the same query in db2 8.1.7 it runs well.

Can any one please say what is the problem?
How can I use Sequence in db2???

Thanks and regards.
Ayusman
--
Ayusman
------------------------------------------------------------------------
Ayusman's Profile: http://www.dbtalk.net/m98
View this thread: http://www.dbtalk.net/t296807

[Serge Rielau]

Peri wrote:

Ayusman ,
Seems like u have encountered minor syntactical error
Ayusman wrote:

insert into t values (next value for s)
[
WHERE t is a table with single column of integer type.
s is a sequence I creates, which shows in the sysibm.syssequences.
]

It should have been
insert into t values (NEXTVAL for s)
Much of the information can be found at
http://publib.boulder.ibm.com/infoce...d/c0007007.htm

Note that NEXT VALUE FOR <seqname> is the SQL Standard syntax.
NEXTVAL was the syntax chosen by DB2 prior to sequences being added to
the SQL Standard.
So, moving forward please use NEXT VALUE FOR and PREVIOUS VALUE FOR for
compliance. NETXVAL and PREVVAL remain of course supported for backward
compatibility.

Cheers
Serge
--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

[Ayusman]

Thanks a lot.
I was facing this proble.
But why does it work in db2 8.1.7??
--
Ayusman
------------------------------------------------------------------------
Ayusman's Profile: http://www.dbtalk.net/m98
View this thread: http://www.dbtalk.net/t296807