Hi,
Can we call UniX Scripts in Jobs? i.e Transformer Stage
if IsNull(A) then SetNull()
Instead of the above condition can we use
NullToValue(A,NULL).
Please suggest me.
Can we call UniX Scripts in Jobs(Not in Sequence)
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
NullToValue is not a UNIX script.
Can you be more precise about your requirement? In particular do you wish to invoke the UNIX command once per run or once per row?
Can you be more precise about your requirement? In particular do you wish to invoke the UNIX command once per run or once per row?
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.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
You ought to ask the question - a specific question please - about NULL handling in a different thread. We stick to "one thread, one question" to make it easier on future searchers.
Executing a UNIX script one time is done from a before-job or after-job subroutine, typically ExecSH or one of its derivatives (or you can write your own). The Input Arguments field takes the entire script command line; it can use job parameters, which will be resolved before the call is made.
Executing a UNIX script once for each line is not to be recommended because of the overhead of establishing and relinquishing a shell in which that script would run. It would be very, very slow.
However, if you insist, this is what the Wrapped stage is for. For more information find the relevant chapter in the DataStage Parallel Job Advanced Developer's Guide manual.
Executing a UNIX script one time is done from a before-job or after-job subroutine, typically ExecSH or one of its derivatives (or you can write your own). The Input Arguments field takes the entire script command line; it can use job parameters, which will be resolved before the call is made.
Executing a UNIX script once for each line is not to be recommended because of the overhead of establishing and relinquishing a shell in which that script would run. It would be very, very slow.
However, if you insist, this is what the Wrapped stage is for. For more information find the relevant chapter in the DataStage Parallel Job Advanced Developer's Guide manual.
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.