DB2 Experts
I am newbie to DB2. I have one table called Phy_data, it has one primary key 'phy_id' as identity column. For this table i have to import the values from a textfile.
Assume the text file has 10 records ok..?
First time identity column value starts automatically with 1 to ends with 10. It works fine.
If i try load another 10 records, identity value starts with (skip to) 21 instead of 11.
I don't know how to solve this.?
Can any one help me on this?
Thanks in advance
venkat
I am newbie to DB2. I have one table called Phy_data, it has one primary key 'phy_id' as identity column. For this table i have to import the values from a textfile.
Assume the text file has 10 records ok..?
First time identity column value starts automatically with 1 to ends with 10. It works fine.
If i try load another 10 records, identity value starts with (skip to) 21 instead of 11.
I don't know how to solve this.?
Can any one help me on this?
Thanks in advance
venkat