How to log an sql statement

[mynwo]

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 can i come to know where the error occured. Thanks in advance.

Regards,

lloyd

 

[appi]

you may build up a script which calls dbaccess and pipes the output directly to file

 

[vpshriyan]

Hi lloyd,

I agree with appi. Script all your DML statement in a file say my_commands.sh which may look like:

dbaccess testdb <<EOF
begin;
insert ... ;
update ... ;
delete ... ;
rollback;
EOF

To run the command file & capture the results, execute:
sh my_commands.sh > my_output.txt 2>&1

Regards,
Shriyan

 

[mynwo]

Hi Shriyan / appi,

Thanks for the feedback

Regards,

lloyd