Passing a List of Values Into SQL as Parameter

[dtatem]

This is how I implemented the solution,based on the feedback I received from gateleys's responses:

1.In my DataStage job, I created a parameter defined as"pListValues"
2. In the SQL I make a reference to this parameter and test it in the job to make sure it works.
3. I created a Sequencer, the first stage in the sequencer is the "UserVariables_Activity" -----> JobActivity

4. In the UserVariables_Activity stage, I added a row and named it "ListValues", in the second column,I added the values ie " 'C','D' ". You have to start with double quotes and end with double quotes.

5. In the JobActivity stage assign the parameter for the "pListValues". Click the "Insert parameter value" button. You should see the "UserVariables_Activity" variable followed by the "+". Click the "+" to assign the parameter... ie UserVariables_Activity.ListValues

I hope this helps

Gateleys:

The SQL is fine...thinks are running fine now...

--dtatem

dtatem, since your problem has been addressed, can you please mark the post as 'Resolved'?


And, may be help our friend loe_ram13 with his query? I have already provided the solution, which he doesn't seem to get it. May be you could help him with your words.

[loe_ram13]

I got the solution.
Instead of using $ReturnValue,
I used $CommandOutput
Thanks for your help.

Gateleys:

The SQL is fine...thinks are running fine now...

--dtatem

dtatem, since your problem has been addressed, can you please mark the post as 'Resolved'?


And, may be help our friend loe_ram13 with his query? I have already provided the solution, which he doesn't seem to get it. May be you could help him with your words.

[ray.wurlod]

Then you might mark the thread as Resolved.

[dtatem]

can you please explain the use of $CommandOutput you use and how you implemented it?

Thanks

I got the solution.
Instead of using $ReturnValue,
I used $CommandOutput
Thanks for your help.

Gateleys:

The SQL is fine...thinks are running fine now...

--dtatem

dtatem, since your problem has been addressed, can you please mark the post as 'Resolved'?


And, may be help our friend loe_ram13 with his query? I have already provided the solution, which he doesn't seem to get it. May be you could help him with your words.

[ray.wurlod]

$CommandOutput is an activity variable associated with an Execute Command activity in a job sequence. It may be used to supply a value to any downstream activity, for example to a job parameter in a Job activity or to a routine argument in a Routine activity or to any trigger expression.