IDENTITY COLUMN ISSUE

SUMANTH YEDDULA

IDENTITY COLUMN ISSUE
Hi ,

In our environment DB2 V8 CM z/os,
we have a table having identity column defined as GENERATED BY DEFAULT.
Also, it is the primary key and
Unique index is defined on this identity column alone..whenever i am trying
into insert a row without specifying the value for the identity coulmn..

error:an inserted or updated value is invalid because index in index space
task1 constrains columns of the table so no two rows can contain duplicate
values in those columns. rid of existing row is x'00000c6f10'

I am unable to insert it. Please kindly can someone help me in understanding
why this happens..and help me to over come this..

Is changing it to GENERATED ALWAYS, will keep this away..Please let me know
your thoughts, suggestions and advices.

Thanks,
Sumanth

_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA *
_____________________________________________________________________

http://www.IDUG.org membership is now free.
Do you have people in your office who are not an IDUG member?
Show them how to access the information and help train the next generation of DB2 Users!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's DB2-L