Hi All,
I have a job that does a full extract by a complex join of 15 Plus tables and returns around 2 million rows.
Only 1000 of these 2 million rows are actually usable/required. Hence I
was looking at sending the 1000 record Id's into the complex query and limit the time it takes.
To select the records required, I have modified the query to have a parameter that would specify the records required.
The point of interest line in the query looks like
Where a.cust_num in ('#CustParms#')
Now this query works fine if I have a single value for the parameter. eg. 'ABC1000'
However, when I pass a parameter with the values 'ABC1000','mch2000'
there are no records returned.
What would be the fix so that 2 rows are returned(The Same query works fine otherwise).
Thanks in Anticipation.
Unable to use comma delimited parameters in Oracle Etpr Stag
Moderators: chulett, rschirm, roy
Your single quotes are being stripped, which is an unfortunate but standard DataStage behaviour. In the past we would have told you to "escape the quotes" but now there is an environment variable you can set to turn off that behaviour.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers