Read a Parameter file from UNIX Directory & pass value

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

ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

The code could alternately be invoked through a Routine activity in the sequence. Return all values in a delimited string - ideally a dynamic array because this can manage nulls - and, in the User Variables activity (or anywhere else) use the Field() function to retrieve a particular value.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
DSFreddie
Participant
Posts: 130
Joined: Wed Nov 25, 2009 2:16 pm

Post by DSFreddie »

Thanks Kim & Craig for your valuable suggestions.

I am using an Execute command activity that will read the Parameter file ( The file is somethin like this,
filename1=/home/abc/file1.txt
filename2=/home/xyz/file2.txt)

I can grep the file & get the 2 values. I am struggling to capture these 2 values through a USer Variable activity.

Can you pls let me know how we can do it through this activity.

Thanks
Freddie.
rameshrr3
Premium Member
Premium Member
Posts: 609
Joined: Mon May 10, 2004 3:32 am
Location: BRENTWOOD, TN

Post by rameshrr3 »

you need to replace the @FM character from the command output using Convert Function

convert(@FM,"",<Your Cmd Output Activity Variable>)
Post Reply