dynamic directory in actual execute command via parameter

haisen · Post by **haisen** » Fri May 30, 2008 3:59 am

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

ArndW · Post by **ArndW** » Fri May 30, 2008 4:32 am

Umm, DataStage is pretty good at reading text files in jobs and using parameters for dynamic values.

bkumar103 · Post by **bkumar103** » Fri May 30, 2008 4:50 am

Could you please be more specific. what is this file contains?

OddJob · Post by **OddJob** » Fri May 30, 2008 5:06 am

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.