constraint error

via · Post by **via** » Wed Apr 04, 2007 1:09 pm

Hi all,
We are unable to load records in database, the error message we are getting is
APT_CombinedOperatorController(0),3: [IBM][CLI Driver][DB2/AIX64] SQL0803N One or more values in the INSERT statement, UPDATE statement, or foreign key update caused by a DELETE statement are not valid because the primary key, unique c

We checked for any duplicate records, but there are no duplicates.The target table is empty.
Any advices?

Thanks..

via · Post by **via** » Wed Apr 04, 2007 2:42 pm

We are loading records from a sequential file to database.The database target table is empty.Even though we sent 1 record from sequential file, we are getting the same error.

Thanks..

chulett · Post by **chulett** » Wed Apr 04, 2007 2:43 pm

And you are doing this in an RTI Enabled / SOA job?

via · Post by **via** » Wed Apr 04, 2007 2:47 pm

Craig, did you mean Runtime column propagation? I didnt get what RTI/SOA job means?

Thanks..

chulett · Post by **chulett** » Wed Apr 04, 2007 3:51 pm

No. Just commenting on the forum you posted this in - the one dedicated to questions on 'real time' or RTI Enabled jobs.

Best to abandon this and repost this in the proper forum.

via · Post by **via** » Thu Apr 05, 2007 8:00 am

Oh.Ok..
Thanks