i have to import data(in a csv file) into database.The data is converted to a XML file .Then transformed to another XML file , the resolution of keys takes place and then loaded into databse.
In my case resolution of keys(constrains-PK,FK) is not proper.
I need to create a xsl file where all contsriants will be specified.
This xsl file helps in idresolution.If its not proper then error occurs in data load.
.MassLoader.Wri ter.JDBCWriter$ WriteWorker::ru n, S1
A SQL Exception was received [IBM][CLI Driver][DB2/NT] SQL0530N The insert or update value of the FOREIGN KEY "ADMINISTRATOR. CATENTRY.F_204" is not equal to any value of the parent key of the parent table. SQLSTATE=23503
on record [catentry: [CATENTRY_ID=136 51][MEMBER_ID=-700][CATENTTYPE_ID=A P01][PARTNUMBER=MFCS 01-CD][MARKFORDELETE=0]]. [sqlcode: -530, sqlstate: 23503]
Suggest me something.
Thanks
In my case resolution of keys(constrains-PK,FK) is not proper.
I need to create a xsl file where all contsriants will be specified.
This xsl file helps in idresolution.If its not proper then error occurs in data load.
.MassLoader.Wri ter.JDBCWriter$ WriteWorker::ru n, S1
A SQL Exception was received [IBM][CLI Driver][DB2/NT] SQL0530N The insert or update value of the FOREIGN KEY "ADMINISTRATOR. CATENTRY.F_204" is not equal to any value of the parent key of the parent table. SQLSTATE=23503
on record [catentry: [CATENTRY_ID=136 51][MEMBER_ID=-700][CATENTTYPE_ID=A P01][PARTNUMBER=MFCS 01-CD][MARKFORDELETE=0]]. [sqlcode: -530, sqlstate: 23503]
Suggest me something.
Thanks