DataStage Parameters
-
- Participant
- Posts: 407
- Joined: Mon Jun 27, 2005 8:54 am
- Location: Walker, Michigan
- Contact:
DataStage Parameters
Please extend datastage parameters to allow them to be the result of some function. That is, allow for functions to be used as part of the parameters default value.
-
- Participant
- Posts: 407
- Joined: Mon Jun 27, 2005 8:54 am
- Location: Walker, Michigan
- Contact:
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
You can store your parameters into a dbms table and extract the relevant parameters prior to the run. Some of these may be functions which can be translated by your dbms into appropriate constants during this extraction phase.
This is a method I tried successfully some time ago as this gives ease of maintenance and acts as a central repository.
Also have tried storing as a separate param file from which your your jobs can read their params. This may also contain function which can be translated during read.
This is a method I tried successfully some time ago as this gives ease of maintenance and acts as a central repository.
Also have tried storing as a separate param file from which your your jobs can read their params. This may also contain function which can be translated during read.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 407
- Joined: Mon Jun 27, 2005 8:54 am
- Location: Walker, Michigan
- Contact:
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Ah. I suspect IBM's response will be that you can use stage variables in a Transformer stage early in the job to effect what you describe as "computed parameters" - simply putting these values onto an output link makes them accessible downstream. A stage variable that has an initialization expression but no derivation expression does not generate any per-row processing overhead.
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: 407
- Joined: Mon Jun 27, 2005 8:54 am
- Location: Walker, Michigan
- Contact:
Correct, but I don't believe this gives me access to use this input data as properties within the stages themselves. For instance, for setting Dynamic instances names via a computed lookup, or doing a computed lookup to set or change the transaction size, or for doing computed filenames for both source and target sequential file stages or datasets. Maybe it does though and I am missing something. If it does, and I am missing something, I'd like to know what I am missing, however though, maybe it still makes sense for such a capability to exist as it might streamline this entire process. I guess I think the solution I am proposing is much more straightforward and user friendly. ???
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
OK, I now see the bigger picture. Still don't like your chances of getting this one through (it can be done in a sequence) but, if you don't ask you might die wondering!
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.