I am getting this working and aborted the job. I created a Book Mark table as part of IBM Infosphere CDC . I capture the Book Mark data in to dataset, in my next job read the dataset and write in to Book_Table using DB2 Connector stage ( write method is Update then Insert ).
I saw some one use the Environment variable APT_OSL_PARAM_ESC_SQUOTE set as 1. But when i check in my project variable i am not found any variable related to APT_OSL_PARAM_ESC_SQUOTE. I check with my datastage admin , he said you can add. as per my knowledge any variable start with APT is related to product .
help me how to resolve my issue.
The double quote character is not allowed in the Table name property. If you want identifiers such as the table name to be quoted when the connector generates statements, verify that the Enable quoted identifiers property is set to Yes. (CC_DB2Properties::CC_DB2Properties, file CC_DB2Properties.cpp, line 179)