Hello All,
I'm giving an input file to execute some insert statements to isql. After some specified number of inserts I'm also using commit, just to be on safer side.
But suppose, for any reason, if any of the insert statement fails, I want the sql file terminate its execution with data safe till the last commit.
The behaviour I'm facing is that though the data is consistent till last commit, the file keeps on executing till it gets the last statement in the file, though most of the statements give some or other error becoz of the previous error in insert statement.
Can I somehow stop executing the sql file since last error?

Thanks in Advance.
Mahesh.


---------------------------------
BT Yahoo! Broadband - Save £80 when you order online today. Hurry! Offer ends 21st December 2003. The way the internet was meant to be.

[Non-text portions of this message have been removed]