SAP Reports / Programs | Basis Components | Database Interface, Database Platforms | DB2 for z/OS(BC-DB-DB2) SAP BC
RSDB2DAL SAP ABAP Report - DB2/390: Deletion of old alert table entries
RSDB2DAL 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 RSDB2DAL 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 RSDB2DAL. "Basic submit
SUBMIT RSDB2DAL AND RETURN. "Return to original report after report execution complete
SUBMIT RSDB2DAL VIA SELECTION-SCREEN. "Display selection screen of submitted report to user
See more syntax options for the ABAP SUBMIT statement
Text pool values
Title: DB2 for OS/390: Deletion of Old Alert Table Entries
INCLUDES used within this REPORT RSDB2DAL
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:
GET_JCL_PROFILE_PARAMETER call function 'GET_JCL_PROFILE_PARAMETER' exporting variable = '$KEEP_DAYS' importing value = days_to_keep exceptions profile_not_available = 1 others = 2.
STU3_ADMIN_DELETE_SQL_REMOTE CALL FUNCTION 'STU3_ADMIN_DELETE_SQL_REMOTE' EXPORTING con_name = space del_stmt = stmt commit = 'X' report_error_to_syslog = abap_false EXCEPTIONS adbc_sql_error = 1 OTHERS = 2.
CCDSNU_DROP_MULTICONNECTION CALL FUNCTION 'CCDSNU_DROP_MULTICONNECTION' EXPORTING REMOTE_DBCON = wa_dbcon-con_name.
STU3_EXPLAIN_CLEANUP CALL FUNCTION 'STU3_EXPLAIN_CLEANUP' EXPORTING connection = wa_system-dbcname date = explain_delete_date check_tables = abap_true EXCEPTIONS OTHERS = 1.
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 RSDB2DAL or its description.