RE: generate next sequence number while inserting data

v5r2 includes support for Identity columns which is exactly what you are
asking for.

http://publib.boulder.ibm.com/iseries/v5r2/ic2924/info/sqlp/rbafymst79.htm

If you're at a prior version of the OS, then you could do it yourself with a
trigger program.

HTH,
Charles


> -----Original Message-----
> From: Ashish Kulkarni [mailto:kulkarni_ash1312@xxxxxxxxx]
> Sent: Tuesday, April 13, 2004 2: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
> 
> 
>       
>               
> __________________________________
> 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.
>