HP 3000 Manuals HP 3000 Manuals
Obtaining ALLBASE/SQL Messages
As shown at 10 in Figure 3-1 , you use the SQLEXPLAIN command to
obtain a message from the ALLBASE/SQL message catalog that describes the
condition related to certain SQLCA values:
EXEC SQL SQLEXPLAIN :SQLMESSAGE END-EXEC.
ALLBASE/SQL puts a message from the ALLBASE/SQL message catalog into the
host variable named SQLMESSAGE, and the program displays the message.
Sometimes more than one message may be needed to completely describe how
an SQL command executed. To retrieve all messages, the program in Figure
3-1 executes paragraph S200-SQL-EXPLAIN until SQLCODE is equal to
zero. ALLBASE/SQL sets SQLCODE to zero when no more messages are
available.
You can use SQLEXPLAIN in conjunction with either implicit or explicit
status checking. In the program in Figure 3-1 , the paragraph
containing SQLEXPLAIN is executed in conjunction with the WHENEVER
SQLERROR command.