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
basu.ds
Participant
Posts: 118 Joined: Tue Feb 06, 2007 12:59 am
Location: Bangalore
Post
by basu.ds » Wed Jul 09, 2008 6:59 am
Hi all
can any one suggest me on this how can i use column name as parameter.i searched on this but i didn't fine any solution for this
ex:assume that i have a set of mail ids in a file i need to pick mailids from file and pass that value to routine as a paramer
Thanks in advance
chulett
Charter Member
Posts: 43085 Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO
Post
by chulett » Wed Jul 09, 2008 7:05 am
Confusing... you've said "column name", "column value" and "column name value" all in the same post. Which is it?
-craig
"You can never have too many knives" -- Logan Nine Fingers
basu.ds
Participant
Posts: 118 Joined: Tue Feb 06, 2007 12:59 am
Location: Bangalore
Post
by basu.ds » Wed Jul 09, 2008 7:39 am
altimately i need to pass column name
chulett
Charter Member
Posts: 43085 Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO
Post
by chulett » Wed Jul 09, 2008 7:58 am
basu.ds wrote: ex:assume that i have a set of mail ids in a file i need to pick mailids from file and pass that value to routine as a paramer
How does that information match up with your example?
-craig
"You can never have too many knives" -- Logan Nine Fingers
basu.ds
Participant
Posts: 118 Joined: Tue Feb 06, 2007 12:59 am
Location: Bangalore
Post
by basu.ds » Wed Jul 09, 2008 8:12 am
please assume that is CSV file
sachin1
Participant
Posts: 325 Joined: Wed May 30, 2007 7:42 am
Location: india
Post
by sachin1 » Wed Jul 09, 2008 8:55 am
please can you let us know how is the format of csv file column_name and its value, so that we can analyze your requirement to pass value for routine.
chulett
Charter Member
Posts: 43085 Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO
Post
by chulett » Wed Jul 09, 2008 9:11 am
basu.ds wrote: please assume that is CSV file
Doesn't help. Your example seems to be normal file reading and the passing of column
values to another process, not column
names. BIG difference, hence the confusion.
-craig
"You can never have too many knives" -- Logan Nine Fingers