468,277 Members | 1,466 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,277 developers. It's quick & easy.

Deleting the data from table having an identity column using DB2 utilities

Hi All,

I am trying to purge the data from a DB2 table having identity column defined usind DB2 utilitties. I am getting the following error

"DSNU269I .............Field is invalid"

"The error says that “Identity columns that were defined as GENERATED always cannot be specified in a LOAD field specification list, nor can these columns be implied in LOAD format UNLOAD or LOAD with no field specification list”"

Please let me know how to delete the data from a table having an identity column
May 10 '07 #1
1 1770
DeMan
1,806 1GB
Hi Pydimarri Srinivas,

Welome to theScripts. I'm sure the experts in the DB2 forum can better address your question, so I hope you don't mind if I move it there
May 10 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

5 posts views Thread by Andrew Lowe | last post: by
2 posts views Thread by William Cleveland | last post: by
6 posts views Thread by Dave | last post: by
6 posts views Thread by davvid | last post: by
5 posts views Thread by Sandeep Singh Sekhon | last post: by
6 posts views Thread by insirawali | last post: by
reply views Thread by NPC403 | last post: by
reply views Thread by zattat | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.