calling Job parameters

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
apkselvam
Participant
Posts: 31
Joined: Mon Sep 04, 2006 2:37 am

calling Job parameters

Post by apkselvam »

Hi folks,
Is it possible to call job parameters in any other stages except transformer.
Thanks in advance
DSguru2B
Charter Member
Charter Member
Posts: 6854
Joined: Wed Feb 09, 2005 3:44 pm
Location: Houston, TX

Post by DSguru2B »

Call :? , You mean use. Yes, by surrounding them with hashes (#).
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
kris007
Charter Member
Charter Member
Posts: 1102
Joined: Tue Jan 24, 2006 5:38 pm
Location: Riverside, RI

Post by kris007 »

What are the stages in question?
Kris

Where's the "Any" key?-Homer Simpson
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Just about any stage in a parallel job has an "Insert Job Parameter" tool or a "Job Parameter" selection from an expression editor menu.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
apkselvam
Participant
Posts: 31
Joined: Mon Sep 04, 2006 2:37 am

Thanks a lot DSguru

Post by apkselvam »

[quote="DSguru2B"]Call :? , You mean use. Yes, by surrounding them with hashes (#). ...[/quote]

Hi DsGuru,
Thanks a lot Guru, it works fine,my problem was solved.
vijayrc
Participant
Posts: 197
Joined: Sun Apr 02, 2006 10:31 am
Location: NJ

Post by vijayrc »

DSguru2B wrote:Call :? , You mean use. Yes, by surrounding them with hashes (#). ...
So if CNY is a Job Parameter defined, then should I use #CNY# to refer to this job parameter value in the Transformer ???
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

No. The 'surround the parameter name with hashes / pound signs' is the rule, but as with all rules there are exceptions. Transformer derivations are one place where you don't enclose them.

If you are unsure, always best to use the 'helper' tool under the ellipses (...) whenever it is available. When you pick the appropriate Job Parameter from there, it will know if it needs to use hashes or not. :wink:
-craig

"You can never have too many knives" -- Logan Nine Fingers
us1aslam1us
Charter Member
Charter Member
Posts: 822
Joined: Sat Sep 17, 2005 5:25 pm
Location: USA

Post by us1aslam1us »

No. There is an exception for it when using in Transformer definitions.
I haven't failed, I've found 10,000 ways that don't work.
Thomas Alva Edison(1847-1931)
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

The rule actually says that the exception is "in expressions".

Anywhere you need a parameter reference in a property, such as a File property, then the surrounding "#" characters are required.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply