Hi. I got a shell script in AIX which uses mailx. Within the body of the email, i use "\r" and "\n" to create a new line.
When i call the script from AIX - the email generated is correctly formatted.
When the script is run from DataStage - all i get is a bunch of literal "\r" or "\n" strings within the body of the email, and no new lines or carriage returns.
the datastage user on the AIX machine has default ksh as its shell. I've checked this in the /etc/passwd (as suggested in another thread).
The script is also setup to uses ksh93 as the shell - if that's any help.
I'm using the execSH stage (which is supposed to default to ksh) to run the script.
please help if you can. thanks in advance.
script works when called in AIX - but not from DataStage
Moderators: chulett, rschirm, roy
The execute command SH calls up "/bin/sh"
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
Still not sure if the "execSH stage" means the before/after job routine or the "Execute Command" stage. For whatever reason, I was assuming they meant the latter. Shouldn't really matter if the first line of the script calls out the shell needed as asserted.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
I'm not sure that the OP is doing that - calling the preferred shell from whatever shell DataStage opens.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
I just realized that the shell used by DataStage is determined by the uvconfig file setting of SHDISPATCH. Just a fyi.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>