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
austin_316
Participant
Posts: 80 Joined: Fri Aug 21, 2009 7:49 am
Location: India
Post
by austin_316 » Wed Dec 22, 2010 1:50 am
Hi,
Can anyone tell me if it is possible to assign a value from parameter set to the column created in using MODIFY stage.
i tried doing like this
Code: Select all
col1:String = #PARAMSET12.CRITICALITY1000#
CRITICALITY1000 in paramaterset has value
HIGH
but i am gettng the warning
Modify_115: When checking operator: The modify operator has a binding for the non-existent output field "HIGH".
Copy_118: When checking operator: The modify operator keeps field "col1" which is not present in the output interface.
please help me on this.
thanks,
ravi.
ray.wurlod
Participant
Posts: 54607 Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:
Post
by ray.wurlod » Wed Dec 22, 2010 2:26 am
Assignment of value is not possible in a Modify stage. You can do it in a Column Generator stage.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Abhi700
Participant
Posts: 20 Joined: Thu Nov 25, 2010 3:52 am
Location: Pune
Post
by Abhi700 » Wed Dec 22, 2010 2:32 am
We Cannot Assign values in the Modify Stage.
ABHILASH
austin_316
Participant
Posts: 80 Joined: Fri Aug 21, 2009 7:49 am
Location: India
Post
by austin_316 » Thu Dec 23, 2010 11:03 pm
but is it possible to set value from Parameterse to this column? because my requirement is to set it from parameterset. please let me know if there are any stages other than transformer.
thanks,
ravi.
ray.wurlod
Participant
Posts: 54607 Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:
Post
by ray.wurlod » Fri Dec 24, 2010 3:56 pm
Column Generator.
Build.
To name two.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.