query as parameter

dubuku_01 · Post by **dubuku_01** » Tue Feb 21, 2012 12:49 pm

Hi guys,

I tried to pass a sql query as parameter to the job through job activity in sequence job. My query contains where ('ABC') and this goes like ABC and throwing the error

Provided sql statement did not complete correctly. I tried consecutive single quotes on both sides, But still its not working. Any other workarounds. Please share.

Version : 8.0.1

ray.wurlod · Post by **ray.wurlod** » Tue Feb 21, 2012 3:21 pm

Is the SQL actually passed syntactically valid?

chulett · Post by **chulett** » Tue Feb 21, 2012 7:02 pm

Try something else to escape the quotes, like a back-slash.

dubuku_01 · Post by **dubuku_01** » Wed Feb 22, 2012 1:00 am

ray.wurlod wrote:Is the SQL actually passed syntactically valid? ...

I just gave part of the query,which gives error ray. Please suggest

kandyshandy · Post by **kandyshandy** » Wed Feb 22, 2012 1:33 am

dubuku, did you try concatenation? ("'": "ABC" : "'") where "'" is a single quote within double quotes

thanush9sep · Post by **thanush9sep** » Wed Feb 22, 2012 3:28 am

If you are passing any parameter and you need to retain your single quotes please use escape character as Chulett said...

For example:
SELECT * FROM EMPLOYEE WHERE ENAME LIKE 'ABC'
should be passed as a parameter like
SELECT * FROM EMPLOYEE WHERE ENAME LIKE \'ABC\'
so that DataStage does not parse your single quotes or else you will end up passing on without Single Quotes
SELECT * FROM EMPLOYEE WHERE ENAME LIKE ABC