UNIX for Dummies Questions & Answers

Can some one help me related to .sql file issue.

I have a .sqlfile and tried to read the file thru unix. In the .sqlfile I have error rows as well and when error comes I dont want to proceed further and need to roll back all the transactions.

sample .sql file below

Code:

insert into
test values (9);
update test set id=9 where id=10;
updte test set id=3;
insert into
test values (1);
insert into test values (1);

I tried with "WHENEVER SQLERROR EXIT SQL.SQLCODE ROLLBACK" option also. Can some one help

Perhaps, if you start your own thread instead of hijacking another's. It's basic netiquette not to do that.

Regards,
Alister

New thread opened.
Thanks!