Im passing an Sql query as a parameter to the job
e.g select name where state in ('NY','NJ')
The query works fine in Oracle but when I pass it as a parameter to the job, it fails. On going through the log I saw that the query was not getting coverted properly.
The log was as follows :
Oracle_Enterprise_0: The provided query statement did not prepare correctly;
please verify that your statement is correct;
statement: SELECT name where state in (NY,NJ).
The quotes were removed from the in clause,hence the failure.
I tried with an escape character
select name where state in (\'NY\',\'NJ\')
The above code works properly in 7.5, but fails in 8.0.2
can anyone suggest me how do I apply escape character in data stage version 8.0.2
Thanks
Mark
Escape character in v8
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 263
- Joined: Fri Sep 23, 2005 6:49 am
Re: Escape character in v8
Please give me suggestions
Thanks
Mark
Thanks
Mark
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
I havent got a solution but we have hit a simalar problem with quotes in parameters being used as properties in PX stages.
e.g. we had a job that used a parameter to specific the syntax for a generic stage - same as u works on 7.5 not on 8
we have raised a support issue with IBM and will let you know the outcome - but because you suggest the problem (like mine) occurs in V8 only then feel more a bug than a coding error
sorry cant be more help
e.g. we had a job that used a parameter to specific the syntax for a generic stage - same as u works on 7.5 not on 8
we have raised a support issue with IBM and will let you know the outcome - but because you suggest the problem (like mine) occurs in V8 only then feel more a bug than a coding error
sorry cant be more help