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.