Job aborting in loading the data from seq file to db2

[ravij]

Hi,

I am loading the data from Seq file to db2 database. I am using the stages in this job is like:

seqfile----->Transformer----->db2api

when I run the job, job got aborted and the error message is like:

SFI00PDetailTot02..trns_HostData: [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 constraint or unique index identified by "1" constrains table "CTRLSTG.STG_HOST_TOT" from having duplicate rows for those columns. SQLSTATE=23505

please help me what could be the reason.
thanx in advance.

[ds_is_fun]

On the DB2 end you have a primary key o n the column.

[baglasumit21]

Hi,

I am loading the data from Seq file to db2 database. I am using the stages in this job is like:

seqfile----->Transformer----->db2api

when I run the job, job got aborted and the error message is like:

SFI00PDetailTot02..trns_HostData: [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 constraint or unique index identified by "1" constrains table "CTRLSTG.STG_HOST_TOT" from having duplicate rows for those columns. SQLSTATE=23505

please help me what could be the reason.
thanx in advance.

Thats because the sequential file have some duplicate rows for the key combination you have specified in the table. Please check the constraint in the table or change the Update action to "Insert New rows and Update Existing".

[Sreedhar]

Hi,

SQL0803N Primary Key constraint voilation.

Regards,