Dear All,

I have a script which calls another file which contains a list of insert statements to be loaded into the database.

dbaccess test /export/home/user1/emp 2> emp.log;
dbaccess test /export/home/user1/dept 2> dept.log;
dbaccess test /export/home/user1/leave 2> leave.log;
dbaccess test /export/home/user1/sal 2> sal.log;

The output is written to respective log files, which tells me 1 row inserted for each sql statement. If there is an error in a file and if there are 100 records it becomes difficult to track where the error occured. Is there a way i can log the actual insert clause into a file & if there is an error in that statement i can find out. Thanks in advance.

Regards,

lloyd

dbaccess -e dbname input.sql 1> output.log 2>&1

Will list the sql and any errors in proper order.

Hi Fred,

Thanks a lot for the syntax.

Regards,

Lloyd