sub routine failed
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 397
- Joined: Wed Apr 12, 2006 2:28 pm
- Location: Tennesse
sub routine failed
Hi All i am running a parallel job which has two input files master and chg passong through CDC results a new master which shud b moved to input master so i am using after job sub routine ExecDOS initial value = path of a bat file which has move command . when i run the job job is running fine but routine is failed with the warning
Move_IRO_Old_Chg_To_Master_JOB..AfterJob (ExecDOS): Error when executing command: F:\INTERMEDIATE\Move_iro_partial_Old_Chg_To_Master.bat
*** Output from command was: ***
The system cannot find the file specified. (2): F:\CURR_MASTER_FILES\iro_Claim_NEWMSTR.txt
The system cannot find the file specified. (2): F:\CURR_MASTER_FILES\iro_ClaimHold_NEWMSTR.txt
The system cannot find the file specified. (2): F:\CURR_MASTER_FILES\iro_Order_NEWMSTR.txt
The system cannot find the file specified. (2): F:\CURR_MASTER_FILES\iro_subscriber_NEWMSTR.txt
i checked the path its right. can any one help plz
thanks
Move_IRO_Old_Chg_To_Master_JOB..AfterJob (ExecDOS): Error when executing command: F:\INTERMEDIATE\Move_iro_partial_Old_Chg_To_Master.bat
*** Output from command was: ***
The system cannot find the file specified. (2): F:\CURR_MASTER_FILES\iro_Claim_NEWMSTR.txt
The system cannot find the file specified. (2): F:\CURR_MASTER_FILES\iro_ClaimHold_NEWMSTR.txt
The system cannot find the file specified. (2): F:\CURR_MASTER_FILES\iro_Order_NEWMSTR.txt
The system cannot find the file specified. (2): F:\CURR_MASTER_FILES\iro_subscriber_NEWMSTR.txt
i checked the path its right. can any one help plz
thanks
hi sam here
sam, what happens when you run the .bat file from the cmd shell manually? If that works and it doesn't from the job then I would look to make sure your paths are absolute in the .bat file. Perhaps you could post the code here as well.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Premium Member
- Posts: 397
- Joined: Wed Apr 12, 2006 2:28 pm
- Location: Tennesse
when i run it maually its not moving the file but the code looks fine
mv F:\CURR_MASTER_FILES\iro_Claim_NEWMSTR.txt F:\CURR_MASTER_FILES\iro_Claim_MSTR.txt
mv F:\CURR_MASTER_FILES\iro_ClaimHold_NEWMSTR.txt F:\CURR_MASTER_FILES\iro_ClaimHold_MSTR.txt
mv F:\CURR_MASTER_FILES\iro_Order_NEWMSTR.txt F:\CURR_MASTER_FILES\iro_Order_MSTR.txt
mv F:\CURR_MASTER_FILES\iro_subscriber_NEWMSTR.txt F:\CURR_MASTER_FILES\iro_subscriber_MSTR.txt
mv F:\CURR_MASTER_FILES\iro_Claim_NEWMSTR.txt F:\CURR_MASTER_FILES\iro_Claim_MSTR.txt
mv F:\CURR_MASTER_FILES\iro_ClaimHold_NEWMSTR.txt F:\CURR_MASTER_FILES\iro_ClaimHold_MSTR.txt
mv F:\CURR_MASTER_FILES\iro_Order_NEWMSTR.txt F:\CURR_MASTER_FILES\iro_Order_MSTR.txt
mv F:\CURR_MASTER_FILES\iro_subscriber_NEWMSTR.txt F:\CURR_MASTER_FILES\iro_subscriber_MSTR.txt
hi sam here
Try using "move" instead of "mv" in DOS.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Premium Member
- Posts: 397
- Joined: Wed Apr 12, 2006 2:28 pm
- Location: Tennesse
But the error is that the source files aren't being found. Have you tried using the DOS "move" instead of the add-on "mv" {probably MKS tookit or like}? Just to make sure the error isn't being introduced by that program.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Premium Member
- Posts: 397
- Joined: Wed Apr 12, 2006 2:28 pm
- Location: Tennesse
Comment out the after-job subroutine call in your job, run it with the full data and then see if manually running the .bat file from a DOS session works or perhaps has the same problem.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Premium Member
- Posts: 397
- Joined: Wed Apr 12, 2006 2:28 pm
- Location: Tennesse
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
If you are using mv then you are in a UNIX environment, where case sensitivity is imposed. Are the pathnames properly cased as well as properly spelled? Does the user ID under which DataStage jobs are executed have sufficient access to all the directories in the path (including the root directory) to be able to determine the directory contents?
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.