UNIQUE KEY constraint
Posted: Thu Oct 21, 2010 8:31 am
hi all
my job will update the table my source and target is same table(SQL Server) and i also used the HASH keys
but i am getting the error message
how to bypass the constraint and update the records by using datastage job
my job will update the table my source and target is same table(SQL Server) and i also used the HASH keys
but i am getting the error message
and the job is aborted. if the same query i fired in MS-Access database it is working fine(it will only update the records with will not affect the uniquety constraint)Violation of UNIQUE KEY constraint 'IX_wk_PMGProvXref'. Cannot insert duplicate key in object 'wk_PMGProvXref'
The statement has been terminated.
how to bypass the constraint and update the records by using datastage job