NDB Response Codes › About Response Codes

About Response Codes

The response codes fall into three categories:

• All OK (response 0)
• Warning conditions (1 to 29)
• Error conditions (30 to 255)

An NCL procedure terminates if an error response is returned, unless &NDBCTL ERROR=CONTINUE is in effect, except as follows:

• &NDBOPEN is always processed as if &NDBCTL ERROR=CONTINUE is in effect, except for response 34 (already open), which honors the actual setting of &NDBCTL ERROR.
• &NDBCLOSE is always processed as if &NDBCTL ERROR=CONTINUE is in effect, except for response 35 (not open), which honors the actual setting of &NDBCTL ERROR.

These exceptions allow a procedure to recover from any error conditions encountered when opening or closing an NDB, except for the obvious programming error (already open or closed). This should encourage you to develop exception handling logic when first writing a procedure.

If an error response from an &NDBOPEN is ignored, the next &NDB statement referring to that NDB will cause the procedure to abnormally terminate (as a result of trying to access an NDB that has not been opened).