Subject Re: how to commit a script
Author Adam
--- In, Pavel Menshchikov
<developer@l...> wrote:
> Hello,
> d> I have a script file which i execute with isql.exe -q -i.
> d> The script file contains EXECUTE PROCEDURE statement. How do i commit
> d> once the procedure is executed?
> d> I tried putting COMMIT in the script file but it does not work...
> COMMIT WORK should work (AFAIR, WORK is optional). What's the error in
> your case? Didn't you forget a statement terminator (";" or whatever
> you set with SET TERM) after EXECUTE PROCEDURE or COMMIT?

Remember to but an enter after the


or it will not work.