Version 4.2.6 for Mainframes (Update)
 —  System Commands  —

SQLDIAG

SQLDIAG

Note:
This command is only available with Natural for DB2.

The SQLDIAG command provides diagnostic information about the last SQL statement (other than a GET DIAGNOSTICS statement) that was executed. This diagnostic information is gathered as the previous SQL statement is executed. Some of the information available through the GET DIAGNOSTICS statement is also available in the SQLCA.

For detailed information about the returned diagonstics information see the IBM DB2 documentation of the GET DIAGOSTICS statement.

Fields, which are prefixed with a a plus sign (+), may contain more data than displayed on the screen. You can display the full contents either when you position the cursor on the field (description or data) and press Enter, or when you enter the abreviation of the field (which are the capital letters of the description) prefoxed by the '+' sign in the command line. For example,. +SN shows a window with the full value of the SERVER_NAME.

The SQLDIAG command can be issued either from the Natural NEXT prompt or from within a Natural program (by using the FETCH statement).

Sample SQLDIAG Diagnostic Information Screens:

 11:03:12           *** SQLDIAG Diagnostic Information ***           2006-04-15
                           - Statement Information -                           
                                                                               
                                                                               
                                                                               
 DB2_Last_Row .....................           0                                
 DB2_Number_Parameter_Markers .....           0                                
 DB2_Number_Result_Sets ...........           0                                
 DB2_Return_Status ................           0                                
 DB2_SQL_Attr_Cursor_Hold .........     _Rowset ..     _Scrollable ...         
                                          _Type ..     _Sensitivity ..         
 DB2_Number_Rows ..................           0                                
 Row_Count ........................           0                                
                                                                               
 More .............................                                            
                                                                               
 Number ...........................           1                                
                                                                               
                                                                               
                                                                               
Command ===>                                                                     
Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12---
      Help  Error Exit  Updat                                     Next  Canc
 11:09:49           *** SQLDIAG Diagnostic Information ***           2006-04-15
                          - Condition Information 1 -                          
                                                                               
+Server_Name ................. DAEFDB28                                        
+CUrsor_Name .................                                                 
 DB2_Error_Code1 .............        -500   DB2_Error_Code2 ...           0   
          _Code3 .............           0            _Code4 ...          -1   
 DB2_Internal_Error_Pointer ..        -500  +DB2_Sqlerrd1(-6) ..        -500   
 DB2_Module_Detecting_Error .. DSNXOTL                                         
+DB2_Ordinal_Token_1 ......... HGK.DEMO                                        
 DB2_Row_Number ..............           0                                     
 DB2_Line_Number .............           0                                     
 DB2_Returned_SQLCode ........        -204                                     
 DB2_Reason_Code .............           0                                     
 Returned_SQLState ...........       42704                                     
 DB2_Message_ID .............. DSN00204E                                       
 Message_Octet_Length ........           0                                     
+Message_Text ................ HGK.DEMO IS AN UNDEFINED NAME                   
                                                                               
                                                                               
Command ===>                                                                   
Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12---
      Help  Error Exit  Updat                               Prev  Next  Canc
 11:14:41           *** SQLDIAG Diagnostic Information ***           2006-04-15
                           - Connection Information -                          
                                                                               
                                                                               
                                                                               
 DB2_Authentication_Type ..                                                    
 DB2_Authentication_ID .... GGS                                                
                                                                               
 DB2_Connection_State .....           0                                        
 DB2_Connection_Status ....           0                                        
 DB2_Encryption_Type ......                                                    
 DB2_Product_ID ........... DSN08010                                           
 DB2_Server_Class_Name .... QDB2 for DB2 UDB for z/OS                          
                                                                               
                                                                               
                                                                               
                                                                               
                                                                               
                                                                               
                                                                               
Command ===>                                                                   
Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12---
      Help  Error Exit  Updat                               Prev        Canc

Top of page