Command Activity

prasad v · Post by **prasad v** » Sat May 21, 2011 3:43 pm

Hi

I am trying to retrieve data from file using commmand Activity stage in datastage

Actually i have created file with 1 value.
And used cat <filename>
Displayed Output: 1 and showing extraline(Eg: 1
)

I tried checking with Len(that commandactivity_output). It is giving 2.

How can we extract only the value 1 using Command Activity stage as i am passing this value to parameter.

And This file is being created in Command Activity stage later this stage.

Thanks
Prasad

ray.wurlod · Post by **ray.wurlod** » Sat May 21, 2011 4:53 pm

Extract the first element from the field-mark-delimited string returned via the Execute Command activity's output activity variable.

Use Field() function or dynamic array notation (ExecCmd.Output$<1>).

prasad v · Post by **prasad v** » Sun May 22, 2011 12:07 am

Thanks Ray.

There is no delimiter in the file. so what can be used in Field() function. length of this value will vary everytime such as 1234 or 1 or 1234565 or 1223333333.

Can you please advise me how to write the Field() function in this situation.

Thanks
Prasad

chulett · Post by **chulett** » Sun May 22, 2011 6:09 am

He already stated the returned value was "field mark delimited". A Field Mark is one of the many System Variables you should be familiar with.

arunkumarmm · Post by **arunkumarmm** » Mon May 23, 2011 12:15 pm

Its @FM

prasad v · Post by **prasad v** » Tue May 24, 2011 6:01 am

Thanks to All.

I have done this using the below code in command activity stage in sequence.

Code: Select all

value=$(cat FileName);printf "$value"