Dear All,

I am testing on migration from one database to other. I have a file which contains all the database changes (insert/update/delete) that need to be run.
Is there anyway i can log all these statements in to a file. When i run this file and if any of these statement fails i can come to know where the error occured. Thanks in advance.

Regards,

lloyd

dbaccess "dbname" filename.sql 2>/yourdir/filename

will record the errors

2 means error output

Hi,

Thanks for your feedback.

dbaccess -e <database name> <file.sql> 1>> < log file> 2>> < log file>

-Abraham

Hi Abraham,

Thanks for the query...