Concatination of two command outputs as a filepath
Posted: Mon Jul 27, 2009 5:26 am
Hi,
I am using 2 different execute command activities in a sequence job in DS 8.1.
1) First execute command activity returns me the system date in the format of yyyymmdd (eg: 20090727).
2) Second execute command activity reads a file in unix and returns me a string (eg: LOCATION)
Now the difficulty that i am facing is that I am using a wait for file activity in the sequence job ahead. And this activity waits for the file in a certain folder. The name of the file is the combination of the returned values of execute command 1 and execute command 2.
therefore for the file path in the wait for file activity i need to give something like
FILEPATH : /Data/#Execute_Command_1.$CommandOutput#_#Execute_Command_3.$CommandOutput#.csv
which should ideally be coming out to be in the following format.
FILEPATH: /Data/20090727_LOCATION.csv
but when i run the job it does not concatenate the output from the two execute command activity and it is only taking the value from the first execute_command. Which is something like this
FILEPATH: /Data/20090727
here _LOCATION.csv is not being taken by the datstage engine.
please help me with this issue.
Thanks in advance
Tanmaya
I am using 2 different execute command activities in a sequence job in DS 8.1.
1) First execute command activity returns me the system date in the format of yyyymmdd (eg: 20090727).
2) Second execute command activity reads a file in unix and returns me a string (eg: LOCATION)
Now the difficulty that i am facing is that I am using a wait for file activity in the sequence job ahead. And this activity waits for the file in a certain folder. The name of the file is the combination of the returned values of execute command 1 and execute command 2.
therefore for the file path in the wait for file activity i need to give something like
FILEPATH : /Data/#Execute_Command_1.$CommandOutput#_#Execute_Command_3.$CommandOutput#.csv
which should ideally be coming out to be in the following format.
FILEPATH: /Data/20090727_LOCATION.csv
but when i run the job it does not concatenate the output from the two execute command activity and it is only taking the value from the first execute_command. Which is something like this
FILEPATH: /Data/20090727
here _LOCATION.csv is not being taken by the datstage engine.
please help me with this issue.
Thanks in advance
Tanmaya