As it is identity column, so it will always generate new value for each new record. If your table don't have any previous data and you haven't reset the value of identity column then there is no chance of error while loading the data.
I guess the load statements works fine.
But i used a regular load statement with out identity ignore .
some thing like this.
"load from tst.ixf of ixf insert into tablename"
It just worked fine with identity column table also . No complaints.
I have been doing this for some time .
Is this a some thing new feature in V8.
And other thing i have observed is , even if i re run the same load statement with same syntax , it is just working fine with out complaints.
It is deleting the existing rows and inserting the new rows , even if i don't use the replace option.
since i am moving the stuff to production ,i want to stick to right syntax.