how to handle the auto incremental column in DB2Table

raj1984 · New User Joined: 28 Oct 2010 Posts: 16 Location: India

Hi,

I have table defined with column "A" defined with auto sequence nbr .
Once i insert a record through program , next sequence number is automatically inserted in that column "A" .

Now my requirement is i need to store this auto sequence nbr in the working storage for further processing .

Now the program is done such a way that i insert a record first and fetch same record again into the host variables and using it for further processing.
So IO operations are doubled for every single insert.

I wanted to avoid this . How can i ?

How can i handle this ?

Thanks
Raj

GuyC · Posted: Thu Nov 18, 2010 9:09 pm

Select from insert :

suppose EMPNO is identity column in table EMPLOYEE:

raj1984 · New User Joined: 28 Oct 2010 Posts: 16 Location: India

Thanks GuyC.