Methods, systems, and media are disclosed for handling errors resulting in
error messages while executing a script file such as a Sequential Query
Language (SQL) script. Embodiments may include one or more databases such
as databases interconnected via a network, which include or have the
ability to create and/or execute script files with on-error statements.
Script files with on-error statements may include an error identifier and
a resolution identifier. Each error identifier may identify one or more
errors associated with the resolution identifier and the resolution
identifier may identify a way to handle the error. Resolution identifiers
may provide one or more error-recovery statements, calls for execution of
a stored procedure, or other functions to correct, log, or ignore errors
and continue or terminate execution of script files. Many embodiments
include a command line processor that can recognize and implement the
on-error statements.