can we pass Fieldname as parameter within a DRS Stage?

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
sunshine
Participant
Posts: 61
Joined: Wed Jan 04, 2006 10:24 am

can we pass Fieldname as parameter within a DRS Stage?

Post by sunshine »

Can we pass Fieldname as Parameter at runtime, within DRS Stage?

when i tried to use #$FIELD_NAME# for a field,in DRS Stage, its saying fieldname must start with character..


Thanks
DSguru2B
Charter Member
Charter Member
Posts: 6854
Joined: Wed Feb 09, 2005 3:44 pm
Location: Houston, TX

Post by DSguru2B »

Thats true. YOu need to put that in the derivation as

Code: Select all

(#$FIELD_NAME#) AS Field_Name
and in the columns provide the name as Field_Name.
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
Post Reply