Pathmaker Programming Guide

Coding Custom Services
Creating Services and Servers
067868 Tandem Computers Incorporated 4–61
Table 4-6. Common NonStop SQL Messages (Page 3 of 3)
Error Number Severity Meaning Pathmaker Level 88
-8423 Error No indicator variable was
specified.
T9154-SQL-MISSING
INDICATOR
-8424 Error An attempt was made to
assign a null value to a field
that does not allow null
values.
T9154-SQL-NULL-NOT-
ALLOWED
-8425 Error An invalid value for a date-
time expression was
encountered.
T9154-SQL-INVALID-DATE-
TIME
-8426 Error The date, time, or interval
value has incorrect syntax.
T9154-SQL-INCORRECT-
DATE-TIME
Negative
numbers
without a
separate
message
Error T9154-SQL-ERROR
Positive
numbers
without a
separate
message
Warning T9154-SQL-WARNING
Error Handling for C Servers Using SQL Tables and Views
The common service utility library, PMSVCULC, contains functions to handle most
file I/O operations. You can invoke these functions in a Custom Source File for a
C service.
When an I/O function detects an error, NonStop SQL automatically invokes the
sql_advisory function, also found in the PMSVCULC file. The sql_advisory function
places an appropriate message in the reply advisory field.
The following example lists a portion of the sql_advisory function for processing SQL
run-time error messages:
void sql_advisory ( void )
.
.
.
static struct {
short lowcode, highcode;
char *template;
} advisory_phrase [] = {
0, 0, "operation successful",
100, 100, "no rows selected or modified",
200, 200, "no DEFINE found for %s",
206, 206, "segment allocation error %s",