delete records from target DB2 Table
Posted: Thu Jul 22, 2010 7:35 am
Hi
I design two datastage to fetch (not match records ) and delete perticular SRKey records in the table.
First job is Table A is join with Table B using key column SR_KEY using LookuStage. Take two target Sequential files ( Rej_File and Output_File )
Second job Rej_File as source and using transformer stage filter with IND colum transfor only domestic records data to target table . Delete those records in target table ( Delete existing Rows only ).
Problem is First job is working fine, but the second job keep on running.
Any one can given an idea to delete the records in target DB2 table.
Thanks
SReddy
I design two datastage to fetch (not match records ) and delete perticular SRKey records in the table.
First job is Table A is join with Table B using key column SR_KEY using LookuStage. Take two target Sequential files ( Rej_File and Output_File )
Second job Rej_File as source and using transformer stage filter with IND colum transfor only domestic records data to target table . Delete those records in target table ( Delete existing Rows only ).
Problem is First job is working fine, but the second job keep on running.
Any one can given an idea to delete the records in target DB2 table.
Thanks
SReddy