DSXchange

I am using an execute command stage passing some parameters

example: Overtime Reporting/Cubes

but my shell script is recognizing only Overtime instead of Overtime Reporting/Cubes value. Can any one help me on how to pass the parameters which has spaces in it?

Try passing the values within double quotes

The space character in the directory name is your problem. As noted, you can enclose the pathname, or the directory name, in quotes.

Option 2 - create a symbolic link (with no spaces in the name) to the target and use that.

Hi Ray.

The double quotes for the directory or path doesnt work still the same issue can you please help if there are any other options apart from symbolic link.

See if this helps.

Hmm - that option http://www-304.ibm.com/support/docview. ... wg21386517 should only help if he was using single quotes, and earlier karry450 said he tried double quotes.

karry450, can you post the exact string you are passing the parameter?

Hi

I am passing 'Overtime Reporting/Cubes' as a parameter

Ok - then either use Craig's recommended environment variable in your job or switch to double quotes (" not '), that should resolve it.

Hi Andy,

"Overtime Reporting/Cubes" also didn't work.

I created a sequence (no environment variable used) with only execute command activity and passed the following command (under the command option) in it :-

echo "Overtime Reporting/Cubes"

Output --> "Overtime Reporting/Cubes"

Then,
Passed following under command option - echo
Passed following under parameter option - "Overtime Reporting/Cubes"

Output --> "Overtime Reporting/Cubes"

Can you try the above and let us know what you see in the director log?
It could be that the datastage is passing the value correctly, but the shell script is not acknowledging it.

We really need to get past "doesn't work" to what the actual problem is and where it is happening. As noted, let's start with showing us what actually gets logged when the job starts as all parameters in play are logged in one of the first messages.

After that, if it looks ok, would be to show us how you are calling the script (what is where in the EC stage) and then how it is being used in your shell script. And I'd also be curious what you need to do from the command line to make your script work? If that's one value then it absolutely needs to be quoted otherwise the space turns it into two parameters.

crystal_pup wrote:Can you try the above and let us know what you see in the director log?

Hi
I have tried both the options

The output is as follows
Output --> Overtime Reporting/Cubes