DB2 Connector stage

sreddy · Post by **sreddy** » Tue Jul 10, 2012 6:11 pm

Hi

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)

chulett · Post by **chulett** » Tue Jul 10, 2012 10:04 pm

Sorry, but what exactly is your issue?

sreddy · Post by **sreddy** » Wed Jul 11, 2012 9:28 am

Hi Craig

My problem is when i read the data from dataset and write into DB2 Book Mark table i am getting this error and abort the datastage job.

I am not getting any single quote or double quote data. Book mark has two columns. one is sequence no ( integer ), keygenerate ( varchar 1024).

Thanks
SReddy

chulett · Post by **chulett** » Wed Jul 11, 2012 10:30 am

So, "this error" is what you have as a quote in your first post? If so, it's not talking about data but rather seems to be saying that you have double quotes in the Table Name property of the stage. Do you?

Kryt0n · Post by **Kryt0n** » Wed Jul 11, 2012 4:25 pm

Ahhh... now I understand what you are getting at... Enable quoted identifiers is not an environment variable you set, it is a property within the Connector stage.

APT_OSL_PARAM_ESC_SQUOTE is for when you pass quotes in to a job via a parameter