SAP ABAP Class CL_SYB_DBH_STORED_PROCEDURE (SYB-DBH: Stored Procedure Helper)

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-DB-SYB (Application Component) Sybase ASE Database Platform
     ⤷ SMSYB (Package) SYBASE Database Monitor

Meta Relationship - Using

#	Relationship type	Using	Short Description	Created on
1	Inheritance (c INHERITING FROM c_ref)	CL_SYB_STORED_PROCEDURE	SYB-DBH: Stored Procedure Helper	20100810

Properties

Class	CL_SYB_DBH_STORED_PROCEDURE
Short Description	SYB-DBH: Stored Procedure Helper
Super Class	CL_SYB_STORED_PROCEDURE	SYB-DBH: Stored Procedure Helper
Instantiability of a Class	2	Public
Final	☑

General Data

Message Class
Program status
Category	0
Package	SMSYB	SYBASE Database Monitor
Created	20100809	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_SYB_DBH_STORED_PROCEDURE has no interface implemented.

Friends

Class CL_SYB_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'		20100809
2	CO_TIME_UNIT_HOUR	Instance attribute	Public	☐	Type reference (TYPE)	STRING	'HOUR'		20100809
3	HAS_CLEANUP_PHASE	Instance attribute	Public	☐	Type reference (TYPE)	ABAP_BOOL			20100809
4	HAS_INC_MODE	Instance attribute	Public	☐	Type reference (TYPE)	ABAP_BOOL	ABAP_FALSE		20120904
5	HAS_SNAPSHOT_PHASE	Instance attribute	Public	☐	Type reference (TYPE)	ABAP_BOOL			20100809
6	HAS_STAGING_PHASE	Instance attribute	Public	☐	Type reference (TYPE)	ABAP_BOOL			20100809
7	HAS_TOP_PHASE	Instance attribute	Public	☐	Type reference (TYPE)	ABAP_BOOL	ABAP_FALSE		20100809
8	IMMEDIATE_STAGING	Instance attribute	Public	☐	Type reference (TYPE)	ABAP_BOOL	ABAP_FALSE		20120906
9	INC_MODE_PREDICATES	Instance attribute	Public	☐	Type reference (TYPE)	DBAKEYVAL_TAB			20120904
10	INC_MODE_THRSD_KEY	Instance attribute	Private	☐	Type reference (TYPE)	DBA_DBH_VALUE			20100809
11	INC_MODE_TSTAMP_KEY	Instance attribute	Private	☐	Type reference (TYPE)	DBA_DBH_VALUE			20100809
12	KEEP_DATA_KEY	Instance attribute	Private	☐	Type reference (TYPE)	DBA_DBH_VALUE			20100809
13	KEEP_NONTOP_KEY	Instance attribute	Private	☐	Type reference (TYPE)	DBA_DBH_VALUE			20100809
14	PREFIX	Instance attribute	Public	☑	Type reference (TYPE)	STRING			20100809
15	SNAPSHOT_TABLE	Instance attribute	Public	☑	Type reference (TYPE)	STRING			20100809
16	STAGING_COMPARE_TIME	Instance attribute	Public	☐	Type reference (TYPE)	STRING	'@@boottime'		20120906
17	STAGING_TABLE	Instance attribute	Public	☑	Type reference (TYPE)	STRING			20100809

Methods

#	Method	Level	Visibility	Method type	Description	Created on
1	ADD_CLEANUP_PROTECT_SQL_STMT	Instance method	Public	Method		20120123
2	ADD_PHASE_CLEANUP	Instance method	Public	Method	DB6-DBH: Adds Cleaup Phase	20100809
3	ADD_PHASE_CLEANUP_HEADER	Instance method	Public	Method	DB6-DBH: Adds Cleaup Phase	20100809
4	ADD_PHASE_INC_MODE_FINAL	Instance method	Public	Method		20100809
5	ADD_PHASE_INC_MODE_INIT	Instance method	Public	Method		20100809
6	ADD_PHASE_STATISTICS	Instance method	Public	Method	DB6-DBH: Adds Statistics Dump Phase	20100809
7	ADD_TRUNCLOGCHKPT	Instance method	Public	Method		20111019
8	CONSTRUCTOR	Instance method	Public	Constructor	CONSTRUCTOR	20100809

Events

Class CL_SYB_DBH_STORED_PROCEDURE has no event.

Types

Class CL_SYB_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			20120123
2	Importing	PROTECTED_SQL_STMT_TAB	Call by reference	☐	Type reference (TYPE)	DBA_DBH_CLEANUP_PROTECTED_TAB		DBA-DBH: Cleanup Protected	20120123

Method ADD_CLEANUP_PROTECT_SQL_STMT on class CL_SYB_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		20100809
2	Importing	SKIP_HEADER	Call by reference	☐	Type reference (TYPE)	ABAP_BOOL	ABAP_FALSE		20100809
3	Importing	STAGING_TABLES	Value transfer	☑	Type reference (TYPE)	DB6_DBH_MANAGED_TABLE_LIST			20100809

Method ADD_PHASE_CLEANUP on class CL_SYB_DBH_STORED_PROCEDURE has no exception.

Method ADD_PHASE_CLEANUP_HEADER Signature

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

Method ADD_PHASE_INC_MODE_FINAL Signature

Method ADD_PHASE_INC_MODE_FINAL on class CL_SYB_DBH_STORED_PROCEDURE has no parameter.
Method ADD_PHASE_INC_MODE_FINAL on class CL_SYB_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	20100809
2	Importing	INC_MODE_THRSD_KEY	Call by reference	☐	Type reference (TYPE)	DBA_DBH_VALUE		DBA-DBH: Key/Value for Configuration Table	20100809
3	Importing	TIME_UNIT	Call by reference	☐	Type reference (TYPE)	STRING			20100809

Method ADD_PHASE_INC_MODE_INIT on class CL_SYB_DBH_STORED_PROCEDURE has no exception.

Method ADD_PHASE_STATISTICS Signature

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

Method ADD_TRUNCLOGCHKPT 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	''		20121004

Method ADD_TRUNCLOGCHKPT on class CL_SYB_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		20100809
2	Importing	HAS_INC_MODE	Call by reference	☐	Type reference (TYPE)	ABAP_BOOL	ABAP_FALSE		20120904
3	Importing	HAS_SNAP_PHASE	Call by reference	☐	Type reference (TYPE)	ABAP_BOOL	ABAP_TRUE		20100809
4	Importing	HAS_STG_PHASE	Call by reference	☐	Type reference (TYPE)	ABAP_BOOL	ABAP_TRUE		20100809
5	Importing	HAS_TOP_PHASE	Call by reference	☐	Type reference (TYPE)	ABAP_BOOL	ABAP_FALSE		20100809
6	Importing	INC_MODE_THRSD_KEY	Call by reference	☑	Type reference (TYPE)	DBA_DBH_VALUE		DBA-DBH: Key/Value for Configuration Table	20100809
7	Importing	KEEP_DATA_KEY	Call by reference	☑	Type reference (TYPE)	DBA_DBH_VALUE		DBA-DBH: Key/Value for Configuration Table	20100809
8	Importing	KEEP_NONTOP_KEY	Call by reference	☑	Type reference (TYPE)	DBA_DBH_VALUE		DBA-DBH: Key/Value for Configuration Table	20100809
9	Importing	PREFIX	Call by reference	☑	Type reference (TYPE)	DB6_DBH_ROUTINE_NAME		DB6-DBH: Routine Name (UDF/SP)	20100809
10	Importing	SP_ID	Call by reference	☐	Type reference (TYPE)	DB6_DBH_ROUTINE_NAME		DB6-DBH: Routine Name (UDF/SP)	20100809
11	Importing	SYS_REF	Call by reference	☐	Object reference (TYPE REF TO)	CL_DB6_SYS		DB6: Remote System Administration	20100809

#	Exception	Resumable	Description	Created on
1	CX_DBA_DBH_SETUP	☐	DBA-DBH: Setup Corrupted	20100809

History

Last changed by/on	SAP	20130531
SAP Release Created in	703