Hi.
I'm new to parallel jobs, but have som experience with server jobs.
When I use parameters containing quotes, the quotes are removed when the SQL is prepared. I use Source.Read Method=User Defined SQL.
I use the Oracle Enterprise stage.
Example:
I have a job parameter named PARAM1 and it contains 'value1', 'value2'
In the SQL:
Select column1 from table where column2 IN(#PARAM1#)
In the prepared SQL the quotes are removed, with a SQL error as result.
This does not happen in Server jobs ?
If I use the ViewData function on the Oracle Stage, the quotes are not removed, and data is returned.
Chris.
Paralell jobs an parameters
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Welcome aboard.
Server and parallel jobs are different products (parallel jobs formerly known as "Orchestrate" from Torrent Systems before they were acquired).
Little inconsistencies are thus to be expected. If this causes you grief, raise an enhancement request to get it altered. You will be required to present a business case.
Server and parallel jobs are different products (parallel jobs formerly known as "Orchestrate" from Torrent Systems before they were acquired).
Little inconsistencies are thus to be expected. If this causes you grief, raise an enhancement request to get it altered. You will be required to present a business case.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.