DSXchange: DataStage and IBM Websphere Data Integration Forum
View next topic
View previous topic
Add To Favorites
Author Message
hobocamp



Group memberships:
Premium Members

Joined: 31 Aug 2006
Posts: 98

Points: 1043

Post Posted: Thu May 07, 2015 2:56 pm Reply with quote    Back to top    

DataStage® Release: 8x
Job Type: Parallel
OS: Unix
I have a process where I make a web service call to obtain an ID string value, which I then must use as one of the input tags in subsequent web service calls.

I'm trying to accomplish this by using a Parameter Set, where I write the value to the "Value file" within the set. I can see that the value file is being created in the initial job's output. But so far I've had no luck in getting the Parameter Set to be recognized as a variable when attempting to use it as input in subsequent calls.

I'm able to use other (non-parameter set) variables in the WS client, so I was wondering if anyone knows if there are inherent issues in using parameter sets with WS stages.

Thanks in advance.
Tom
ray.wurlod

Premium Poster
Participant

Group memberships:
Premium Members, Inner Circle, Australia Usergroup, Server to Parallel Transition Group

Joined: 23 Oct 2002
Posts: 54434
Location: Sydney, Australia
Points: 295220

Post Posted: Thu May 07, 2015 5:12 pm Reply with quote    Back to top    

The specified values file is read when the job starts, and is not read again subsequently. You could always introduce something like an Execute Command activity to read the file, followed by a User V ...

_________________
RXP Services Ltd
Melbourne | Canberra | Sydney | Hong Kong | Hobart | Brisbane
currently hiring: Canberra, Sydney and Melbourne (especially seeking good business analysts)
Rate this response:  
Not yet rated
hobocamp



Group memberships:
Premium Members

Joined: 31 Aug 2006
Posts: 98

Points: 1043

Post Posted: Thu May 07, 2015 5:37 pm Reply with quote    Back to top    

It just seems like the Paremeter Set should work though. I only need to read it at the beginning of the job - just to pass it once, at the beginning of the job, to the web service.

Before moving on I'll keep trying to see if I have something wrong. I can see the value in the file, and that it's set up correctly (ID=123456).
Rate this response:  
Not yet rated
ray.wurlod

Premium Poster
Participant

Group memberships:
Premium Members, Inner Circle, Australia Usergroup, Server to Parallel Transition Group

Joined: 23 Oct 2002
Posts: 54434
Location: Sydney, Australia
Points: 295220

Post Posted: Thu May 07, 2015 6:53 pm Reply with quote    Back to top    

Is this within one job, or within a sequence? You're right to say that the value of a parameter (within a Parameter Set or not) should be available throughout - in a sequence you can refer to the Job ...

_________________
RXP Services Ltd
Melbourne | Canberra | Sydney | Hong Kong | Hobart | Brisbane
currently hiring: Canberra, Sydney and Melbourne (especially seeking good business analysts)
Rate this response:  
Not yet rated
hobocamp



Group memberships:
Premium Members

Joined: 31 Aug 2006
Posts: 98

Points: 1043

Post Posted: Fri May 08, 2015 1:47 pm Reply with quote    Back to top    

Ray -

My process was just a single simple job, designed as such:

WS ClientStage ----> Sequential File Stage

That makes me even more curious as to why the contents of the Value File weren't being recognized within the stage. (In Trace mode, the Soap body showed an empty value for the tag that should have contained the value.)
I've opened a pmr with IBM to see if there are any known issues with using a Parameter Set value file within a WS stage.

In the meantime, I followed your suggestion and created a sequence, where the value is passed as a parameter in a routine step down to a job run step, and that works beautifully.

Thanks again.
Tom
Rate this response:  
Not yet rated
Display posts from previous:       

Add To Favorites
View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum



Powered by phpBB © 2001, 2002 phpBB Group
Theme & Graphics by Daz :: Portal by Smartor
All times are GMT - 6 Hours