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

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);

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!