I need to store the result from oracle enterprise stage which always returns single value into a parameter. I have to use this parameter in other jobs.
Any help.
how to store a value into a parameter from sql query.
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Run in a separate job, store the result in a file or in the job's user status area. Pick that up in the job sequence and feed its value to your job parameter in the Job activity.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
ray.wurlod wrote:Run in a separate job, store the result in a file or in the job's user status area. Pick that up in the job sequence and feed its value to your job parameter in the Job activity.
How to pick up the result from the file and pass it to next job in the sequence?. Do we need to use any special activity stage to store result from file created?.
-
- Charter Member
- Posts: 822
- Joined: Sat Sep 17, 2005 5:25 pm
- Location: USA
Ray,ray.wurlod wrote:Run in a separate job, store the result in a file or in the job's user status area. Pick that up in the job sequence and feed its value to your job parameter in the Job activity.
Can you tell me how to store the value in user status area?. What stage to use for that?. We are using parallel edition.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Use a BASIC Transformer stage (the overhead for one row can be ignored) and use the DSSetUserStatus() function in a constraint or derivation expression. Search the forum for examples.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
We do not have BASIC Transformer stage . We have regular Transformer stage and it is not accepting any DSSetUserStatus() function. Is there anyway to do this with regular Transformer stage ?.ray.wurlod wrote:Use a BASIC Transformer stage (the overhead for one row can be ignored) and use the DSSetUserStatus() function in a constraint or derivation expression. Search the forum for examples.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: