Pass parameter value to routine activity Input Argument
Moderators: chulett, rschirm, roy
Pass parameter value to routine activity Input Argument
Hi all
I have a sequence stage which runs five jobs in parallel and creates some files.These files I have to concatenate and create another output file.
For this concatenation,I have written a UNIX script which will take the File Path as parameter.All these days i have been hardcoding this File Path
Now I have to invoke this script after the sequence as a routine activity.I have to use ExecSh routine to do this
My problem is I am able to invoke the script.
In the value expression I have given the path where the script is present and it works
But the File Path hardcoding should be removed and it also has to be passed as a parameter during the sequence run
What will I write in my Value Expression for the routine activity to invoke the script and then use the FilePath parameter as an input for the concatenation script
I have a sequence stage which runs five jobs in parallel and creates some files.These files I have to concatenate and create another output file.
For this concatenation,I have written a UNIX script which will take the File Path as parameter.All these days i have been hardcoding this File Path
Now I have to invoke this script after the sequence as a routine activity.I have to use ExecSh routine to do this
My problem is I am able to invoke the script.
In the value expression I have given the path where the script is present and it works
But the File Path hardcoding should be removed and it also has to be passed as a parameter during the sequence run
What will I write in my Value Expression for the routine activity to invoke the script and then use the FilePath parameter as an input for the concatenation script
In the value expression i have now
$SHELL_SCRIPT_PATH
This is calling the script
Now I want to pass the file path parameter
What is the syntax for this?
I have defined the parameter in the Job Parameters also as
$SHELL_SCRIPT_PATH=/app/carsdev/scripts/p3.ksh
$CARS_OUTBOUND_EXTRACT_PATH=/app/carsdev/data/output/
I have tried
$SHELL_SCRIPT_PATH.$CARS_OUTBOUND_EXTRACT_PATH
$SHELL_SCRIPT_PATH($CARS_OUTBOUND_EXTRACT_PATH) etc
I know they are wrong but I am playing around :oops:
Can someone suggest?
$SHELL_SCRIPT_PATH
This is calling the script
Now I want to pass the file path parameter
What is the syntax for this?
I have defined the parameter in the Job Parameters also as
$SHELL_SCRIPT_PATH=/app/carsdev/scripts/p3.ksh
$CARS_OUTBOUND_EXTRACT_PATH=/app/carsdev/data/output/
I have tried
$SHELL_SCRIPT_PATH.$CARS_OUTBOUND_EXTRACT_PATH
$SHELL_SCRIPT_PATH($CARS_OUTBOUND_EXTRACT_PATH) etc
I know they are wrong but I am playing around :oops:
Can someone suggest?
Hi all
Instead of doing it thru Routine Activity I am using command stage now
I use this in the Command box
ksh
and in the parameters box I am giving the path for the script like
#$SHELL_SCRIPT_PATH#p3.ksh
Now this script needs 1 input parameter from datastage .The name of the parameter being #$CARS_OUTBOUND_EXTRACT_PATH#
Now how can I give these two paramters.Any suggestions wud be appreciated
Instead of doing it thru Routine Activity I am using command stage now
I use this in the Command box
ksh
and in the parameters box I am giving the path for the script like
#$SHELL_SCRIPT_PATH#p3.ksh
Now this script needs 1 input parameter from datastage .The name of the parameter being #$CARS_OUTBOUND_EXTRACT_PATH#
Now how can I give these two paramters.Any suggestions wud be appreciated
I am sorry.There was a mistake
The job does not abort now but the log stops here
There is no completion for the job.
The output file is created but there is no data in it
The log looks like this
Starting Job CopyOfsqDACOutbnd.
Environment variable settings:
CopyOfsqDACOutbnd..JobControl (@Coordinator): Starting new run of checkpointed Sequence job
There is no more progress from here
Please advise
The job does not abort now but the log stops here
There is no completion for the job.
The output file is created but there is no data in it
The log looks like this
Starting Job CopyOfsqDACOutbnd.
Environment variable settings:
CopyOfsqDACOutbnd..JobControl (@Coordinator): Starting new run of checkpointed Sequence job
There is no more progress from here
Please advise
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: