SQL file failure

ArijitS · Post by **ArijitS** » Mon Sep 17, 2007 8:56 am

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.

sachin1 · Post by **sachin1** » Mon Sep 17, 2007 9:40 am

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

ray.wurlod · Post by **ray.wurlod** » Mon Sep 17, 2007 3:22 pm

Even better:

ExecDos
sqlplus -s oracle/oracle@BIODS.WORLD @#directory#\in\file.sql > #directory#\in\file_log.log
2>&1

DSXchange

SQL file failure

SQL file failure

Re: SQL file failure