Book Contents

Book Index

Next Topic

Home

ON_ERROR_STOP

By default, if non-interactive scripts encounter an error, such as a malformed SQL command or internal meta-command, processing continues. This has been the traditional behavior of vsql but it is sometimes not desirable. If this variable is set, script processing will immediately terminate. If the script was called from another script it will terminate in the same fashion. If the outermost script was not called from an interactive vsql session but rather using the -f option, vsql will return error code 3, to distinguish this case from fatal error conditions (error code 1).