Pathmaker Programming Guide

Coding Custom Services
Creating Services and Servers
067868 Tandem Computers Incorporated 4–57
Error Handling for COBOL Servers Using SQL Tables and Views
The Pathmaker product provides a single format for messages returned by
NonStop SQL or any of its subsystems. A subset of the NonStop SQL messages is
documented in Table 4-6. You can get information about the remaining messages
either by looking in the NonStop SQL Messages Manual or by using the ERROR
command from SQLCI.
The default message that the Pathmaker product provides has the following format:
SQL err: err-num , SQL-subsystem-id - SQL-subsystem-code ,
on: filename , ln# user-line-number
err-num
is the NonStop SQL error number and can be a number from -99999 through
99999.
NonStop SQL messages can be one of two types:
ERRORS If err-num is in the range -99999 through -1, you received an error
message.
NonStop SQL issues an error message when it encounters a
condition that interrupts normal processing of the job.
WARNINGS If err-num is in the range 1 through 99999, you received a warning
message.
NonStop SQL issues a warning message when it encounters a
condition that does not interrupt normal processing of the job.
Table 4-6 lists the NonStop SQL errors for which the Pathmaker product provides
special handling.
SQL-subsystem-id
can contain the following values:
Value Meaning
F File system
D Disk process (DP2)
G Operating system
R SORT
L Loader
I Sequential I/O (SIO)
The most common subsystems to return an error are the file system, the disk
process, and the operating system.