Posted: Tue Nov 13, 2007 10:32 am
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
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 wrote:dtatem, since your problem has been addressed, can you please mark the post as 'Resolved'?dtatem wrote:Gateleys:
The SQL is fine...thinks are running fine now...
--dtatem
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.