SQL/MP Programming Manual for C

SQL/MP System Procedures
HP NonStop SQL/MP Programming Manual for C—429847-008
5-3
SQLCADISPLAY
For the alternate SQL message files available on your node, ask your database
administrator or service provider.
You can add (or modify) the =_SQL_MSG_node DEFINE either interactively from
TACL or SQLCI, or programmatically from a C program:

From TACL or SQLCI, enter an ADD DEFINE (or ALTER DEFINE) command. Do
not include a backslash (\) or a space before the node name. For example, this
command adds a new DEFINE for the $SQL.MSG.FRENCH message file on the
\PARIS node:
ADD DEFINE =_SQL_MSG_PARIS,CLASS MAP,FILE $SQL.MSG.FRENCH
For the _SQL_MSG_node DEFINE to be in effect for an SQLCI session, you must
add or change the DEFINE before you start the SQLCI session. If you add or
change the DEFINE after you start the session, NonStop SQL/MP returns warning
message 10201, which indicates that the DEFINE has been changed but the old
message file is still in effect.

From a C program, call the DEFINEADD (or DEFINESETATTR) system procedure.
Your program must add or alter the DEFINE before it calls a system procedure that
opens and reads the SQL message file. Otherwise, your program uses the default
message file. For more information about system procedures, see the Guardian
Procedure Calls Reference Manual.
SQLCADISPLAY
The SQLCADISPLAY procedure displays error or warning information that NonStop
SQL/MP returns to the SQLCA data structure. SQLCADISPLAY writes this information
to a file or terminal.
The information returned to the SQLCA structure can originate from these subsystems
or system components:

NonStop SQL/MP

NonStop operating system

File system

Disk process (DP2)

FastSort program (SORTPROG process)

Sequential I/O (SIO) procedures
NonStop SQL/MP communicates errors, warnings, and statistics to a program through
the SQLCA structure. However, because the SQLCA contains information in a format
that is not appropriate for display, call the SQLCADISPLAY procedure to convert this
information to an appropriate format.