SQL file failure
Moderators: chulett, rschirm, roy
SQL file failure
If i invoking a SQL file through batch process from after/before job sub routine of DS job how can i trap the error of SQL file if it fails to run with out the help of director.
Re: SQL file failure
hello you can just do the following
ExecDos sqlplus -s oracle/oracle@BIODS.WORLD @#directory#\in\file.sql > #directory#\in\file_log.log
all your error will be caught in file_log.log
ExecDos sqlplus -s oracle/oracle@BIODS.WORLD @#directory#\in\file.sql > #directory#\in\file_log.log
all your error will be caught in file_log.log
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Even better:
ExecDos
sqlplus -s oracle/oracle@BIODS.WORLD @#directory#\in\file.sql > #directory#\in\file_log.log
2>&1
ExecDos
sqlplus -s oracle/oracle@BIODS.WORLD @#directory#\in\file.sql > #directory#\in\file_log.log
2>&1
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.