Deleting Records - When Not found - Datastage Job - help pls
Posted: Mon Oct 03, 2005 7:41 am
Here is my scenario.
ODBC1 --> recordset having 2 columns (reg_id, reg_number)
ODBC2 --> recordset having 1 column (reg_number)
I want to delete all the records in ODBC1 whose reg_number is not found in ODBC2.
ODBC1 and ODBC2 are both Sql Server but different databases.
I wrote a delete Stored procedure which takes reg_id as input.
Now all I have to do is pass the "reg_id" whose reg_number is not found to the other side of transform.
ODBC1 ---- IN ---- Transform ---OUT --- ODBC1(Delete Stored procedure)
ODBC2 -------IN1-------(same transform)
Now if I use constraint IN1.NOTFOUND its not working.
Please help!!!!!!!!!!
ODBC1 --> recordset having 2 columns (reg_id, reg_number)
ODBC2 --> recordset having 1 column (reg_number)
I want to delete all the records in ODBC1 whose reg_number is not found in ODBC2.
ODBC1 and ODBC2 are both Sql Server but different databases.
I wrote a delete Stored procedure which takes reg_id as input.
Now all I have to do is pass the "reg_id" whose reg_number is not found to the other side of transform.
ODBC1 ---- IN ---- Transform ---OUT --- ODBC1(Delete Stored procedure)
ODBC2 -------IN1-------(same transform)
Now if I use constraint IN1.NOTFOUND its not working.
Please help!!!!!!!!!!