Requirement:
1) Run unix shell script via Execute Command to get text file's data for downstream processing.
2) The directory of the unix script will be based on the value in parameter set due to UAT & PRD environment.
3) Value retrieve will be used to read another file or to use it as a where clause to extract record from DB and load directly to another DB.
Execute Command Stage:
Command --> /app/scripts/#env#/#mart_id#_get_param.sh #other_param1# hardcoded_param2
dynamic directory in actual execute command via parameter
Moderators: chulett, rschirm, roy
dynamic directory in actual execute command via parameter
Last edited by haisen on Fri May 30, 2008 4:45 am, edited 1 time in total.
Unfortunately you can't use Job Parameters in the Command field of an Execute Command Sequence stage.
Instead, put your command line in the Parameters field, where you can use params. You could use exec as your command e.g. in your case:
Command: exec
Parameters: /app/scripts/#env#/#mart_id#_get_param.sh #other_param1# hardcoded_param2
Instead of exec you should be able to use sh or ksh etc, but on my system I get a permissions problem so settled on exec to get it working.
Instead, put your command line in the Parameters field, where you can use params. You could use exec as your command e.g. in your case:
Command: exec
Parameters: /app/scripts/#env#/#mart_id#_get_param.sh #other_param1# hardcoded_param2
Instead of exec you should be able to use sh or ksh etc, but on my system I get a permissions problem so settled on exec to get it working.