[Info-Ingres] commit question

[David Greenberg]

Hi

This is my code ....

modify medat0002 to truncated;\g\t
insert into medat0002 select * from hafakot.medat02_for_hafakot;
commit;\g\t


Our default on entering "sql" is "\continue".

The situation we had was that the "modify to truncate" command succeeded 
but the insert failed. Because of the "\continue" default the run 
continued to other sql commands.

My questions are:
1. The medat0002 table was truncated even though the insert failed. Is 
that because of the \continue which ran the "commit" and saved the 
result of the truncate ?

2. Had we have set "\nocontinue", would the truncate command have been 
rolled back ?

Thanks

David Greenberg