Pathmaker Programming Guide

Coding Custom Services
Creating Services and Servers
4–58 067868 Tandem Computers Incorporated
SQL-subsystem-code
is the subsystem error number. You can get more information about the specific
error by looking in the appropriate subsystem’s error messages manual.
filename
is the name of the file on which NonStop SQL attempted to perform an operation.
user-line-number
is the line number in your server source code where SQL encountered the
problem.
The generated application does not always return information for every variable in the
default message. Suppose you receive the following message:
SQL err: 8222,- 0,on: ,ln#: 4427.000
In this case, only err-num and user-line-number are returned in the message.
You can find more information about this error by using Table 4-6.
For COBOL servers, the Pathmaker product creates two Level 88 declarations, T9154-
SQL-ERROR and T9154-SQL-WARNING, that you can use to catch all error and
warning messages not included in the default Level 88 list. The Pathmaker product
also provides you with information when a file system, disk process, or operating
system error occurs by determining the subsystem error and moving the code for the
error to
T9154-GUARDIAN-ERR.
Table 4-6 lists a subset of NonStop SQL messages for which the Pathmaker product
provides special handling. For each of these messages, the Pathmaker product creates
a Level 88 declaration that you can test for in your service code. The examples of
custom service code with embedded NonStop SQL, later in this section, show how you
can use the Level 88 declarations.
If you want, you can add to the list of Level 88 declarations that the Pathmaker
product provides by modifying the server skeleton. See “Modifying a Server Skeleton
or Service Skeleton” in Section 9 for instructions.