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:
please help me what could be the reason.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
thanx in advance.