SAP Reports / Programs | Basis Components | Database Interface, Database Platforms | MaxDB(BC-DB-SDB) SAP BC

comments icon Comments

RSSDBUPDSTATONE SAP ABAP Report - Update Optimizer Statistics for a Table







RSSDBUPDSTATONE 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 RSSDBUPDSTATONE 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 RSSDBUPDSTATONE. "Basic submit
SUBMIT RSSDBUPDSTATONE AND RETURN. "Return to original report after report execution complete
SUBMIT RSSDBUPDSTATONE 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: GV_TNAME = Table Name
Selection Text: GV_ROWS = Number of Rows (Sample)
Selection Text: GV_PERC = Percentage (Sample)
Selection Text: GV_OWNER = Table Owner/Schema
Selection Text: GV_CON = Name of Database Connection
Selection Text: GV_COLS = Column Selection (Separator:@)
Title: Update Optimizer Statistics for a Table
Text Symbol: 148 = Database Connection
Text Symbol: 147 = liveCache Name
Text Symbol: 144 = liveCache Connection
Text Symbol: 143 = liveCache Server
Text Symbol: 139 = Edited Tables
Text Symbol: 137 = Database Name
Text Symbol: 134 = System
Text Symbol: 133 = Database Server
Text Symbol: 132 = Date, Time
Text Symbol: 015 = : Table Has Neither Key nor Index
Text Symbol: 014 = Cannot execute action - No SQL connection
Text Symbol: 011 = SQL connect failed
Text Symbol: 010 = Database Connection:
Text Symbol: 009 = Error during execution
Text Symbol: 007 = Determining SQL Optimization Statistics
Text Symbol: 004 = Command
Text Symbol: 003 = RC
Text Symbol: 002 = Time
Text Symbol: 001 = Date
Text Symbol: 000 = : Table Does Not Exist


INCLUDES used within this REPORT RSSDBUPDSTATONE

INCLUDE SDB_CLIENT_SEPARATION.
INCLUDE UPDSTATG01.
INCLUDE UPDSTATF00.


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:

GET_DBMCONNECT_INFO_SDB
    CALL FUNCTION 'GET_DBMCONNECT_INFO_SDB'
      EXPORTING
        con_name = gv_con
      IMPORTING
        dbname   = gv_dbname
        dbserver = gv_dbserver
      EXCEPTIONS
        OTHERS   = 0.

SEL_EXTENDED_VERSION_SDB
  CALL FUNCTION 'SEL_EXTENDED_VERSION_SDB'
    EXPORTING
      con_name     = gv_con
    IMPORTING
      long_version = lv_long_version
    EXCEPTIONS
      OTHERS       = 0.


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 RSSDBUPDSTATONE or its description.


   
 

RSSDBUPDSTATONE - Update Optimizer Statistics for a Table
RSSDBUPDSTATONE - Update Optimizer Statistics for a Table
RSSDBUPDSTAT - RSSDBUPDSTAT - Create Optimizer Statistics
RSSDBUPDSTAT - RSSDBUPDSTAT - Create Optimizer Statistics
RSSDBTICMCLEANUP - Clean Up MaxDB CCMS Data After System Copy
RSSDBTICMCLEANUP - Clean Up MaxDB CCMS Data After System Copy