Special Condition

 

Syntax: SET ERROR MESSAGE Error# ON/OFF

 

Default: ON

 

SET ERROR MESSAGE Error# ON/OFF displays or suppresses a particular error message when a system error occurs.

 

You can selectively turn OFF any -ERROR- message(s) in your command file (very handy for debugging) by doing the following:

 

SET ERROR MESSAGE Error# OFF

 

To turn it back ON:

 

SET ERROR MESSAGE Error# ON

 

For example, to not see the:

 

-WARNING- No rows exist or the specified clause.

 

You can do the following:

 

SET ERROR MESSAGE 2059 OFF

 

This new feature has a limit of 50 -ERROR- numbers to set OFF and each one requires a separate command.

 

NOTE: Each turned OFF message must be turned back ON before turning it OFF again. If not, you'll get the error message.