RE: generate next sequence number while inserting data

Ashish,

I believe what you want is an identity column.  It would be defined when the 
table is created on the AS/400.

If the table already exists and you can't create it with an identity column try 
putting the sequence number logic into a user define function.

HTH,

Rick

-----Original Message-----
From: java400-l-bounces@xxxxxxxxxxxx
[mailto:java400-l-bounces@xxxxxxxxxxxx]On Behalf Of Ashish Kulkarni
Sent: Tuesday, April 13, 2004 1:26 PM
To: java400-l@xxxxxxxxxxxx
Subject: generate next sequence number while inserting data


Hi
I have to write a program which inserts data in AS400
DB2 using SQL insert statement,
One of the column is sequence number,
When ever i insert a record i want to get the last
sequence number add one to it and generate a next
number and insert that number
Do i have to do it programmatically or is there a way
i can define the table so it will automatically
generate the next sequence number and insert it
automatically

Ashish