Pathmaker Programming Guide

Modifying a Server Skeleton or Service Skeleton
Advanced Pathmaker Programming Topics
9–48 067868 Tandem Computers Incorporated
Changing the Text of the Error Messages
The following excerpt lists the portion of the sql_advisory function that contains the
messages used to report SQL errors. You can change the text of the error messages,
but you should not change the associated error codes:
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",
251, 251, "memory allocation error %s",
214, 230, "process error on %s",
8025, 8025, "SQL region was not SQL compiled",
8026, 8027, "program compiled with NORECOMPILE
option",
8202, 8202, "%s redefined",
8222, 8222, "multiple rows returned by SELECT or
subquery",
8227, 8227, "duplicate key on %s",
8228, 8228, "constraint violated on %s",
8230, 8230, "no rows were returned by the
subquery",
8233, 8233, "constraint %s violated",
8237, 8237, "SQL statement was recompiled",
8402, 8402, "overflow occurred during numeric
computation",
8403, 8403, "character data value was
truncated",
8405, 8405, "decimal data has some nonnumeric
digits",
8406, 8406, "assigned negative value to unsigned
buffer",
8407, 8407, "underflow occurred during numeric
operation",
8408, 8408, "division by zero occurred",
8410, 8410, "invalid value encountered for a
data type",
8411, 8411, "unsigned numeric buffer has a
negative value",
8423, 8423, "no indicator variable supplied for
NULL value",
8424, 8424, "NULL moved to field that does not
allow NULL",