SQL error-display panels

If an error occurs when running an SQL statement, Db2 Admin Tool displays the SQL code and error message on a separate panel called an SQL error-display panel.

To correct the SQL statement, press END, which redisplays the panel where you originally issued the SQL statement. Db2 Admin Tool positions the cursor at the point in the SQL statement where Db2 found the error.

The following figure shows the error panel that Db2 Admin Tool displays when the following SQL statement (containing a spelling error) is issued: SELECT * FRON Q.STAFF.

Figure 1. Error Display panel (part 1 of 2)

DB2 Admin --------------------- DB2 Error Display 1 --------------------- 14:14
 Command ===>
 Rollback done
    SQLCODE : -104                           DSNTIAR CODE :  0  

 DSNT408I SQLCODE = -104, ERROR:  ILLEGAL SYMBOL FRON VALID SYMBOLS ARE FROM
          INTO
 DSNT418I SQLSTATE   = 37501 SQLSTATE RETURN CODE
 DSNT415I SQLERRP    = DSNHPARS SQL PROCEDURE DETECTING ERROR
 DSNT416I SQLERRD    = 0  0  0  -1  10  0 SQL DIAGNOSTIC INFORMATION
 DSNT416I SQLERRD    = X'00000000'  X'00000000'  X'00000000'  X'FFFFFFFF'
          X'0000000A'  X'00000000' SQL DIAGNOSTIC INFORMATION

Press Enter to see error panel two, as shown in the following figure.

Figure 2. Error Display panel (part 2 of 2)

DB2 Admin --------------------- DB2 Error Display 2 --------------------- 14:14	
 Command ===> 																						
																												
    SQLCODE : -104                           DSNTIAR CODE :  0  						
																												
PREPARE  																									
																												
SELECT * FRON Q.STAFF

Press END to redisplay the panel on which you entered the incorrect SQL statement.