Multiple values in Local parameter...

[mallireddibalaji]

Hi Gurus,

In my new reuirement, we need to add the extra local parameter value while running the sequence.

Example:

we have common job, in that job source query we have the logic as COLUMN='#LOCAL_PARAMETER#'.(LOCAL_PARAMETER is string type)

while runtime we are passing #LOCAL_PARAMETER#="XXXX"
Its working fine.

As per the new requirement i have changed the query logic to COLUMN IN (#LOCAL_PARAMETER#) and while runtime we are passing #LOCAL_PARAMETER#="'XXXX','YYYY'"

But job is aborting with ORA-00904: "YYYY": invalid identifier.


Could you please help on this issue.

[chulett]

That's because your quotes are being stripped, something DataStage is notorious for doing. A search here for escape should turn up all of the advice that's been posted.