Deleting Data with Datastage
Posted: Wed Dec 03, 2008 4:30 am
Hi,
I am trying to delete data from the table using DB2_UDB_Enterprise stage.I am using the Delete option in this stage. But when I run the job it is giving me the following error.
"Unable to convert the adapter spec ostrstream object with a value of `' to ustring."
I am not using the USTRING type any where in the Job and I am passing a value in the delete statement like "DELETE FROM <TABLE_NAME> WHERE <COLUMN_NAME>=VALUE".
Please help me in finding a solution for this problem.
I am trying to delete data from the table using DB2_UDB_Enterprise stage.I am using the Delete option in this stage. But when I run the job it is giving me the following error.
"Unable to convert the adapter spec ostrstream object with a value of `' to ustring."
I am not using the USTRING type any where in the Job and I am passing a value in the delete statement like "DELETE FROM <TABLE_NAME> WHERE <COLUMN_NAME>=VALUE".
Please help me in finding a solution for this problem.