As shown at 10 in Figure 3-1 “Sample Program COBEX2 ”, 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 “Sample Program COBEX2 ”
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 “Sample Program COBEX2 ”, the
paragraph containing SQLEXPLAIN is executed in conjunction with
the WHENEVER SQLERROR command.