SAP Reports / Programs | SAP Business Information Warehouse | Basis System and Installation | BW DB2 for OS/390(BW-SYS-DB-DB2) SAP BW

comments icon Comments

SAP_READ_STATEMENTCACHE_DB2 SAP ABAP Report - Program SAP_READ_STATEMENTCACHE_DB2







SAP_READ_STATEMENTCACHE_DB2 is a standard Executable ABAP Report available within your SAP system (depending on your version and release level). Below is the basic information available for this SAP report including which OBJECTS it interacts with such as TABLES, FUNCTION MODULES, INCLUDES ETC. Also check out the submitted Comments related to this SAP report or see any standard documentation available.

If you would like to execute this report or see the full code listing simply enter SAP_READ_STATEMENTCACHE_DB2 into the relevant SAP transactions such as SE38 or SE80


ABAP code to call this SAP report using the submit statement

This report can be called from another progam/report simply by using the ABAP SUBMIT statement, see below for example ABAP code snipts of how to do this.






SUBMIT SAP_READ_STATEMENTCACHE_DB2. "Basic submit
SUBMIT SAP_READ_STATEMENTCACHE_DB2 AND RETURN. "Return to original report after report execution complete
SUBMIT SAP_READ_STATEMENTCACHE_DB2 VIA SELECTION-SCREEN. "Display selection screen of submitted report to user
    See more syntax options for the ABAP SUBMIT statement


Text pool values


Selection Text: P_TABNAM = First table of the statement
Title: Program SAP_READ_STATEMENTCACHE_DB2


INCLUDES used within this REPORT SAP_READ_STATEMENTCACHE_DB2

No INCLUDES are used within this REPORT code!


TABLES used within REPORT and the associated SELECT statement:





No SAP DATABASE tables are accessed within this REPORT code!


Function Modules used within report and the associated call statement:

STU3_GET_STATEMENT_STATISTICS
  CALL FUNCTION 'STU3_GET_STATEMENT_STATISTICS'
    EXPORTING
      fb_dsctype                          = 2
      fb_dsclist                          = 1
      fb_dscvalue                         = 0
      fb_dscvalue2                        = 0
      fb_retry                            = 0
**    fb_dsctype                          = 1   " display statement with highest
**    fb_dsclist                          = 3   " number of getpages
**    fb_dscvalue                         = 0
**    fb_dscvalue2                        = 0
**    fb_retry                            = 0
*   DS_MEMBER_SPEC                      = DS_MEMBER_SPEC
*    GET_LONG_SQL                        = 'X'
* IMPORTING
*   FB_DSCHDR                           = FB_DSCHDR
*   FB_DSECPROCD                        = FB_DSECPROCD
*   FB_DSECNPROCD                       = FB_DSECNPROCD
*   DS_MEMBER_USED                      = DS_MEMBER_USED
    TABLES
      fb_statement_tab                    = l_t_db2qstc
   EXCEPTIONS
     rs_auth_failure                     = 1
     rs_start_trace                      = 2
     rs_internal_error                   = 3
     rs_dyn_cach_na                      = 4
     rs_no_cach_stmts                    = 5
     rs_dsc_ptf_missing                  = 6
     rs_not_complete                     = 7
     request_to_old                      = 8
     no_buffer_space_in_shm              = 9
     unvalid_request_id                  = 10
     answer_is_not_yet_available         = 11
     communication_error                 = 12
     answer_not_possible                 = 13
     communication_buffer_to_small       = 14
     unknown_error                       = 15
     illegal_parameter                   = 16
     ifi_error                           = 17
     other_exception                     = 18
     OTHERS                              = 19
            .

STU3_GET_LONG_STATEMENT_TEXT
  CALL FUNCTION 'STU3_GET_LONG_STATEMENT_TEXT'
    EXPORTING
      fb_dscname                    = p_rec-qstcstnm
      fb_stmtid                     = p_rec-qstctokn
*     DS_MEMBER_SPEC                = DS_MEMBER_SPEC
*     USE_ALERT_USER                = USE_ALERT_USER
    IMPORTING
*     FB_QW0317LN                   = FB_QW0317LN
      stmt_text                     = l_long_stmt
    TABLES
      fb_statement_text             = l_t_stmt
*     PREPARE_ATTRIB                = PREPARE_ATTRIB
    EXCEPTIONS
      rs_auth_failure               = 1
      rs_start_trace                = 2
      rs_internal_error             = 3
      request_to_old                = 4
      no_buffer_space_in_shm        = 5
      unvalid_request_id            = 6
      answer_is_not_yet_available   = 7
      communication_error           = 8
      answer_not_possible           = 9
      communication_buffer_to_small = 10
      unknown_error                 = 11
      illegal_parameter             = 12
      ifi_error                     = 13
      statement_not_in_cache        = 14
      adbc_sql_error                = 15
      OTHERS                        = 16.


Contribute (Add Comments)

Although this basic information may have limited use it does provide an easy to find location to store any knowledge about this program/report.







The contribute/comments section below therefore offer's an opportunity for anyone to add additional information. This can be anything from useful hints, tips and screen shots to relevant SAP notes or anything else you feel is relevant to this report.

This will then be available for everyone to easily find by simply searching on the report name SAP_READ_STATEMENTCACHE_DB2 or its description.


   
 

SAP_READ_STATEMENTCACHE_DB2 - Program SAP_READ_STATEMENTCACHE_DB2
SAP_READ_STATEMENTCACHE_DB2 - Program SAP_READ_STATEMENTCACHE_DB2
SAP_QUERY_TEST - Generates and executes random queries for an InfoCube
SAP_QUERY_TEST - Generates and executes random queries for an InfoCube
SAP_QUERY_SQ03 - Call maintenance for user groups
SAP_QUERY_SQ03 - Call maintenance for user groups