Using the IMS Feature › DBRM - SQL Information › SQL Statement Details

SQL Statement Details

Select an SQL statement by using line command SD from the DBRM SQL Overview panel to display details about the selected statement, as shown following.

APCXPSTX           SQL Statement Information                 Row 1 to 28 of 28
 COMMAND ===>                                                  SCROLL ===> HALF
                                                                                
 Date: 2011.01.15  System: PRODIMSA  DBRM: TEST1234                             
                                                                                
                         Total     Total     Total                              
 Action    Stmt#  Called ACTV%   CPU sec  RESP sec  CPU/Call RESP/Call   BROWSE
 -------- ------ ------- ----- --------- --------- --------- ---------          
 FETCH       333  163959  0.20    3.3796    3.9260  0.000020  0.000023   EDIT  
                                                                                
 *** START OF SQL STATEMENT ***                                                 
                                                                                
 FETCH                                                                          
                                                                                
 *** END OF SQL STATEMENT ***                                                   
                                                                                
 *** START OF SQL DECLARE ***                                                   
                                                                                
 DECLARE  TCDC0970 CURSOR                                                       
 FOR                                                                            
 SELECT   TC_APPLICATION , SEQUENCE , HARDCODES                                 
 FROM     TCDT097                                                               
 WHERE    COD_ENTITY = : H                                                      
 AND      PROGRAM = : H                                                         
 AND      LNG_DATA = : H                                                        
 ORDER    BY SEQUENCE DES_NRESFCC , COD_NATCTRY , DES_NATCTRY ,                 
          FLG_EURCTRY , EXCHANGE , LNG_OFDATA , LASTMODUSER ,                   
          LASTMODTRM , DAT_LASTMOD , DES_ENTABR , FLG_OFCACC ,                  
          FLG_FCCCOEXC , FLG_ALL_MULT                                           
 INTO     : H , : H , : H , : H , : H , : H , : H , : H , : H , : H ,           
          : H , : H , : H , : H , : H , : H , : H , : H , : H , : H ,           
          : H , : H , : H , : H , : H , : H , : H , : H , : H , : H ,           
          : H                                                                   
                                                                                
 *** END OF SQL DECLARE ***                                                     
 ******************************* Bottom of data ********************************

The SQL Statement Information panel shows the performance details of the selected SQL statement followed by the SQL statement text, if available. For cursor statements the SQL Declare statement text will also be shown, if available

You can use the BROWSE and EDIT buttons to display the statement text in Browse or Edit mode for further processing.