DSXchange

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.

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.