RE: generate next sequence number while inserting data

Ashish,

Define the table using SQL DDL as follows:

create table XYZ
(
field1 dec(x) not null generated always as identity (start with x),
field2 char(x),
filed3 char(x)
)


Hope it helps.

Scott


>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




__________________________________
Do you Yahoo!?
Yahoo! Tax Center - File online by April 15th
http://taxes.yahoo.com/filing.html
_______________________________________________
This is the Java Programming on and around the iSeries / AS400 (JAVA400-L)
mailing list
To post a message email: JAVA400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/java400-l
or email: JAVA400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/java400-l.

---
Incoming mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.656 / Virus Database: 421 - Release Date: 4/9/2004

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.656 / Virus Database: 421 - Release Date: 4/9/2004