Unable to pass Apostrophe to Oracle Stage as parameter

satkolli · Post by **satkolli** » Wed Oct 22, 2014 12:49 pm

I have a DS8.1 Parallel job which uses the Oracle Enterprise stage to Select data with the SQL below:
select custnum, custname, type from Customer where #FilterVal#

The String parameter "FilterVal" value is defined in the job as type = 'A'

When running the job I get the errors:
Message: ORA-00936: missing expression
Error occurred during initializeFromArgs().
The provided query statement did not prepare correctly;
please verify that your statement is correct;
select custnum, custname, type from Customer where type = A

It looks like when the job is passing the FilterVal parameter value, the apostrophe surrounding the A is missing in the Select SQL statement. When I view the data on the Oracle stage then it shows me data. Only when running the job manually or a sequence do I get the errors due to the missing apostrophes. Any idea how I can pass the proper statement "type = 'A'" into the Oracle Enterprise stage?

[Note - spelling corrected - Andy]

chulett · Post by **chulett** » Wed Oct 22, 2014 12:58 pm

A search here should have turned your answer up pretty easily:

http://www-304.ibm.com/support/docview. ... wg21386517

satkolli · Post by **satkolli** » Wed Oct 22, 2014 1:18 pm

Thank you very much Craig. I guess I was not putting the proper search parameters to find the article you attached. The word apostrophe was throwing it off! I was doing a Google search... will try the IBM site next time too.

As the article mentioned I added the UserDefined Parameter APT_OSL_PARAM_ESC_SQUOTE (with a Value = 1) in the DS Administrator. After adding it to the job there were no errors on the run. Got the required output.

ray.wurlod · Post by **ray.wurlod** » Wed Oct 22, 2014 3:41 pm

Note also that the correct spelling is "apostrophe".