SAP ABAP Class CL_DB6_DBH_STORED_PROCEDURE (DB6-DBH: Stored Procedure Helper)
Hierarchy
☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-DB-DB6 (Application Component) DB2 Universal Database for UNIX / NT
     ⤷ STU6 (Package) DB6: Performance-Monitor (UNIX/Windows)
Meta Relationship - Using
# Relationship type Using Short Description Created on
1 Inheritance (c INHERITING FROM c_ref)  CL_DB6_STORED_PROCEDURE DB6-DBH: Stored Procedure Helper 20081218
Properties
Class CL_DB6_DBH_STORED_PROCEDURE  
Short Description DB6-DBH: Stored Procedure Helper    
Super Class CL_DB6_STORED_PROCEDURE DB6-DBH: Stored Procedure Helper 
Instantiability of a Class 2  Public 
Final    
General Data
Message Class    
Program status     
Category 0   
Package STU6   DB6: Performance-Monitor (UNIX/Windows) 
Created 20070827   SAP 
Last change 20130531   SAP 
Shared Memory-enabled    
Fixed point arithmetic    
Unicode checks active    
Forward declarations
# Type group / Object type Type Type Description
1 ABAP Type group use (TYPE-POOLS tp)  Type group use (TYPE-POOLS tp)
Interfaces
Class CL_DB6_DBH_STORED_PROCEDURE has no interface implemented.
Friends
Class CL_DB6_DBH_STORED_PROCEDURE has no friend class.
Attributes
# Attribute Level Visibility Read only Typing Associated Type Initial Value Description Created on
1 CO_TIME_UNIT_DAY Instance attribute Public Type reference (TYPE) STRING 'DAY' 20100412
2 CO_TIME_UNIT_HOUR Instance attribute Public Type reference (TYPE) STRING 'HOUR' 20100412
3 HAS_CLEANUP_PHASE Instance attribute Public Type reference (TYPE) ABAP_BOOL 20091118
4 HAS_SNAPSHOT_PHASE Instance attribute Public Type reference (TYPE) ABAP_BOOL 20090325
5 HAS_STAGING_PHASE Instance attribute Public Type reference (TYPE) ABAP_BOOL 20090325
6 HAS_TOP_PHASE Instance attribute Public Type reference (TYPE) ABAP_BOOL ABAP_FALSE 20100208
7 INC_MODE_THRSD_KEY Instance attribute Private Type reference (TYPE) DBA_DBH_VALUE DBA-DBH: Key/Value for Configuration Table 20100412
8 INC_MODE_TSTAMP_KEY Instance attribute Private Type reference (TYPE) DBA_DBH_VALUE DBA-DBH: Key/Value for Configuration Table 20100412
9 KEEP_DATA_KEY Instance attribute Private Type reference (TYPE) DBA_DBH_VALUE DBA-DBH: Key/Value for Configuration Table 20090126
10 KEEP_NONTOP_KEY Instance attribute Private Type reference (TYPE) DBA_DBH_VALUE DBA-DBH: Key/Value for Configuration Table 20100208
11 MEASURE_TIME_IN_S Instance attribute Public Type reference (TYPE) ABAP_BOOL ABAP_FALSE 20100215
12 MV_CLEANUP_HEADER_ADDED Instance attribute Private Type reference (TYPE) ABAP_BOOL ABAP_FALSE 20120518
13 MV_NO_NEWLINE_MARKER Instance attribute Private Type reference (TYPE) I 20130621
14 PREFIX Instance attribute Public Type reference (TYPE) DB6_DBH_ROUTINE_NAME DB6-DBH: Routine Name (UDF/SP) 20070831
15 RECORDS_PARAMETER Constant Public Type reference (TYPE) ABAP_BOOL ABAP_FALSE DB6-DBH: Set Parameter for Records (V9.1 only!) 20071008
16 SNAPSHOT_TABLE Instance attribute Public Type reference (TYPE) DB6_DBH_TABLE_NAME DB6-DBH: Table Name 20070905
17 STAGING_TABLE Instance attribute Public Type reference (TYPE) DB6_DBH_TABLE_NAME DB6-DBH: Table Name 20070905
Methods
# Method Level Visibility Method type Description Created on
1 ADD_CLEANUP_PROTECT_SQL_STMT Instance method Public Method 20110331
2 ADD_CLEANUP_SNAP_TABLE Instance method Public Method DB6-DBH: Adds Cleaup Phase 20120518
3 ADD_PHASE_CLEANUP Instance method Public Method DB6-DBH: Adds Cleaup Phase 20070828
4 ADD_PHASE_CLEANUP_HEADER Instance method Public Method DB6-DBH: Adds Cleaup Phase 20090422
5 ADD_PHASE_INC_MODE_FINAL Instance method Public Method 20100412
6 ADD_PHASE_INC_MODE_INIT Instance method Public Method 20100412
7 ADD_PHASE_STATISTICS Instance method Public Method DB6-DBH: Adds Statistics Dump Phase 20070828
8 CONSTRUCTOR Instance method Public Constructor CONSTRUCTOR 20070827
9 FINALIZE_NO_NEWLINE_MARKER Instance method Public Method 20130621
10 SET_NO_NEWLINE_MARKER Instance method Public Method 20130621
11 SET_SNAPSHOT_TABLE Instance method Public Method 20120703
12 SET_STAGING_TABLE Instance method Public Method 20120703
Events
Class CL_DB6_DBH_STORED_PROCEDURE has no event.
Types
Class CL_DB6_DBH_STORED_PROCEDURE has no local type.
Method Signatures

Method ADD_CLEANUP_PROTECT_SQL_STMT Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Importing INDENT Call by reference Type reference (TYPE) STRING 20110331
2 Importing PROTECTED_SQL_STMT_TAB Call by reference Type reference (TYPE) DBA_DBH_CLEANUP_PROTECTED_TAB DBA-DBH: Cleanup Protected 20110331

Method ADD_CLEANUP_PROTECT_SQL_STMT on class CL_DB6_DBH_STORED_PROCEDURE has no exception.

Method ADD_CLEANUP_SNAP_TABLE Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Importing SKIP_HEADER Call by reference Type reference (TYPE) ABAP_BOOL ABAP_TRUE 20120518
2 Importing TABNAME Call by reference Type reference (TYPE) STRING 20120518

Method ADD_CLEANUP_SNAP_TABLE on class CL_DB6_DBH_STORED_PROCEDURE has no exception.

Method ADD_PHASE_CLEANUP Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Importing HAS_TOP_PHASE Call by reference Type reference (TYPE) ABAP_BOOL ABAP_FALSE 20100208
2 Importing SKIP_HEADER Call by reference Type reference (TYPE) ABAP_BOOL ABAP_FALSE 20090422
3 Importing STAGING_TABLES Value transfer Type reference (TYPE) DB6_DBH_MANAGED_TABLE_LIST DB6-DBH: Table Names 20100217

Method ADD_PHASE_CLEANUP on class CL_DB6_DBH_STORED_PROCEDURE has no exception.

Method ADD_PHASE_CLEANUP_HEADER Signature

Method ADD_PHASE_CLEANUP_HEADER on class CL_DB6_DBH_STORED_PROCEDURE has no parameter.
Method ADD_PHASE_CLEANUP_HEADER on class CL_DB6_DBH_STORED_PROCEDURE has no exception.

Method ADD_PHASE_INC_MODE_FINAL Signature

Method ADD_PHASE_INC_MODE_FINAL on class CL_DB6_DBH_STORED_PROCEDURE has no parameter.
Method ADD_PHASE_INC_MODE_FINAL on class CL_DB6_DBH_STORED_PROCEDURE has no exception.

Method ADD_PHASE_INC_MODE_INIT Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Importing INC_MODE_DOW_KEY Call by reference Type reference (TYPE) DBA_DBH_VALUE DBA-DBH: Key/Value for Configuration Table 20100705
2 Importing INC_MODE_THRSD_KEY Call by reference Type reference (TYPE) DBA_DBH_VALUE DBA-DBH: Key/Value for Configuration Table 20100705
3 Importing TIME_UNIT Call by reference Type reference (TYPE) STRING 20100412

Method ADD_PHASE_INC_MODE_INIT on class CL_DB6_DBH_STORED_PROCEDURE has no exception.

Method ADD_PHASE_STATISTICS Signature

Method ADD_PHASE_STATISTICS on class CL_DB6_DBH_STORED_PROCEDURE has no parameter.
Method ADD_PHASE_STATISTICS on class CL_DB6_DBH_STORED_PROCEDURE has no exception.

Method CONSTRUCTOR Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Importing HAS_CLEANUP_PHASE Call by reference Type reference (TYPE) ABAP_BOOL ABAP_TRUE 20091118
2 Importing HAS_SNAP_PHASE Call by reference Type reference (TYPE) ABAP_BOOL ABAP_TRUE 20090325
3 Importing HAS_STG_PHASE Call by reference Type reference (TYPE) ABAP_BOOL ABAP_TRUE 20090325
4 Importing HAS_TOP_PHASE Call by reference Type reference (TYPE) ABAP_BOOL ABAP_FALSE 20100208
5 Importing INC_MODE_THRSD_KEY Call by reference Type reference (TYPE) DBA_DBH_VALUE DBA-DBH: Key/Value for Configuration Table 20100412
6 Importing INC_MODE_TSTAMP_KEY Call by reference Type reference (TYPE) DBA_DBH_VALUE DBA-DBH: Key/Value for Configuration Table 20120704
7 Importing KEEP_DATA_KEY Call by reference Type reference (TYPE) DBA_DBH_VALUE DBA-DBH: Key/Value for Configuration Table 20090126
8 Importing KEEP_NONTOP_KEY Call by reference Type reference (TYPE) DBA_DBH_VALUE DBA-DBH: Key/Value for Configuration Table 20100208
9 Importing NO_PARALLEL_EXECUTION Call by reference Type reference (TYPE) ABAP_BOOL ABAP_TRUE 20110127
10 Importing PREFIX Call by reference Type reference (TYPE) DB6_DBH_ROUTINE_NAME DB6-DBH: Routine Name (UDF/SP) 20070831
11 Importing SPECIFICNAME Call by reference Type reference (TYPE) DB6_DBH_ROUTINE_NAME DB6-DBH: Routine Name (UDF/SP) 20101014
12 Importing SP_ID Call by reference Type reference (TYPE) DB6_DBH_ROUTINE_NAME DB6-DBH: Routine Name (UDF/SP) 20070827
13 Importing SYS_REF Call by reference Object reference (TYPE REF TO) CL_DB6_SYS DB6: Remote System Administration 20090318
# Exception Resumable Description Created on
1 CX_DBA_DBH_SETUP DBA-DBH: Setup Corrupted 20100221

Method FINALIZE_NO_NEWLINE_MARKER Signature

Method FINALIZE_NO_NEWLINE_MARKER on class CL_DB6_DBH_STORED_PROCEDURE has no parameter.
Method FINALIZE_NO_NEWLINE_MARKER on class CL_DB6_DBH_STORED_PROCEDURE has no exception.

Method SET_NO_NEWLINE_MARKER Signature

Method SET_NO_NEWLINE_MARKER on class CL_DB6_DBH_STORED_PROCEDURE has no parameter.
Method SET_NO_NEWLINE_MARKER on class CL_DB6_DBH_STORED_PROCEDURE has no exception.

Method SET_SNAPSHOT_TABLE Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Importing TABNAME Call by reference Type reference (TYPE) DB6_DBH_TABLE_NAME DB6-DBH: Table Name 20120703

Method SET_SNAPSHOT_TABLE on class CL_DB6_DBH_STORED_PROCEDURE has no exception.

Method SET_STAGING_TABLE Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Importing TABNAME Call by reference Type reference (TYPE) DB6_DBH_TABLE_NAME DB6-DBH: Table Name 20120703

Method SET_STAGING_TABLE on class CL_DB6_DBH_STORED_PROCEDURE has no exception.
History
Last changed by/on SAP  20130531 
SAP Release Created in 711