All,
I have a windows batch script which sftp a file. Now manually I am able to send the file but when used the script in After Job Subroutine, the job hangs. Basically it is not working while executing it from Datastage after job sub routine. Is that an issue Admin should handle? Any other option to run the script in datastage.
Thanks.
Sam.
Batch script running trouble from Datastage
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Stick some echo commands into the script to see how far it actually gets.
For example, some variants of FTP do not allow the entry of the password to be subjected to redirection.
For example, some variants of FTP do not allow the entry of the password to be subjected to redirection.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
To Ray's point, some processes know when they are running in "interactive mode" - manually from the command line - and when they are running under automation and can behave differently from one mode to the other. Put in some breadcrumbs so you can see how far you get and then hopefully know exactly where it is when it hangs.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Premium Member
- Posts: 1735
- Joined: Thu Mar 01, 2007 5:44 am
- Location: Troy, MI
Also, try to put absolute paths in the script as scheduled ones may not utilize the environment variables you may have defined for your user when running from DataStage. Did you put "echo"s in you script to find out which statement its getting stuck at?
Priyadarshi Kunal
Genius may have its limitations, but stupidity is not thus handicapped.
Genius may have its limitations, but stupidity is not thus handicapped.