SAP ABAP Class CL_RSDA_DB6_CONNECTION (DB6 NLS Connection Class)

Hierarchy

☛ SAP_BW (Software Component) SAP Business Warehouse
   ⤷ BW-SYS-DB-DB6 (Application Component) BW DB2 Universal Database
     ⤷ RSDB6_NLS (Package) RSDB6_NLS

Meta Relationship - Using

#	Relationship type	Using	Short Description	Created on
1	Interface implementation (CLASS c. INTERFACES i_ref)	IF_RSDAI_NEARLINE_CONNECTION	Connection to Nearline Storage	20081210
2	Interface implementation (CLASS c. INTERFACES i_ref)	IF_RSDAI_NEARLINE_CONNECTION_1	Test	20090513
3	Interface implementation (CLASS c. INTERFACES i_ref)	IF_RSDA_DB6_CONSTANTS	DB6 Constants for Near-Line Storage Archiving	20090513
4	Interface implementation (CLASS c. INTERFACES i_ref)	IF_RSDA_DB6_SYNC_CHECKER	DB6 constants for synchronization checks	20091105

Properties

Class	CL_RSDA_DB6_CONNECTION
Short Description	DB6 NLS Connection Class
Super Class
Instantiability of a Class	0	Private
Final	☑

General Data

Message Class	RS_DB_DB6
Program status
Category	0
Package	RSDB6_NLS	RSDB6_NLS
Created	20081210	SAP
Last change	20130531	SAP
Shared Memory-enabled	☐
Fixed point arithmetic	☑
Unicode checks active	☑

Forward declarations

#	Type group / Object type	Type	Type Description
1	IF_RSDAI_NEARLINE_CONNECTION	Forward declaration interface (INTERFACE i DEFINITION DEF...	Forward declaration interface (INTERFACE i DEFINITION DEF...
2	RCDB6	Type group use (TYPE-POOLS tp)	Type group use (TYPE-POOLS tp)
3	RS	Type group use (TYPE-POOLS tp)	Type group use (TYPE-POOLS tp)

Interfaces

#	Interface	Abstract	Final	Description	Created on
1	IF_RSDAI_NEARLINE_CONNECTION	☐	☐	Connection to Nearline Storage	20081210
2	IF_RSDAI_NEARLINE_CONNECTION_1	☐	☐	Test	20090513
3	IF_RSDA_DB6_CONSTANTS	☐	☐	DB6 Constants for Near-Line Storage Archiving	20090513
4	IF_RSDA_DB6_SYNC_CHECKER	☐	☐	DB6 constants for synchronization checks	20091105

Friends

Class CL_RSDA_DB6_CONNECTION has no friend class.

Attributes

#	Attribute	Level	Visibility	Read only	Typing	Associated Type	Initial Value	Description	Created on
1	P_BW_HOST	Instance attribute	Private	☐	Type reference (TYPE)	SYHOST		Name of Current Application Server	20100629
2	P_BW_SAPSID	Instance attribute	Private	☐	Type reference (TYPE)	SYSYSID		Name of the SAP System	20100629
3	P_COMPRESSED	Instance attribute	Private	☐	Type reference (TYPE)	RS_BOOL	RS_C_FALSE	Boolean	20100504
4	P_CONNECTION_NAME	Instance attribute	Private	☐	Type reference (TYPE)	IF_RSDAI_NEARLINE_CONNECTION=>CONNECTION_NAME		BW Archiving: Name of Near-Line Connection	20081210
5	P_DBCON_NAME	Instance attribute	Private	☐	Type reference (TYPE)	DBCON_NAME		Logical Name for a Database Connection	20081210
6	P_R_SQL_CONNECTION	Instance attribute	Private	☐	Object reference (TYPE REF TO)	CL_SQL_CONNECTION		Database Connection	20081210
7	P_TR_INSTANCES	Static Attribute	Private	☐	Type reference (TYPE)	TY_TR_INSTANCES			20081210

Methods

#	Method	Level	Visibility	Method type	Description	Created on
1	ARCHIVE_LOG	Instance method	Public	Method	Archives and closes the active log file on the NLS database	20120301
2	CLOSE_CONNECTION	Instance method	Private	Method	Closes a connection	20081210
3	CLOSE_PREPARED_STATEMENT	Instance method	Public	Method	Closes a prepared command	20090624
4	CLOSE_RESULT_SET	Instance method	Public	Method	Closes a ResultSet	20090624
5	CONSTRUCTOR	Instance method	Private	Constructor	Constructor	20081210
6	EVALUATE_FEATURES	Instance method	Private	Method	Analyzes licensed functions	20100504
7	EXECUTE_DDL	Instance method	Public	Method	Executes a DDL command	20081210
8	EXECUTE_PREPARED_QUERY	Instance method	Public	Method	Executes a prepared SELECT command	20090729
9	EXECUTE_PREPARED_UPDATE	Instance method	Public	Method	Executes a prepared command	20090624
10	EXECUTE_QUERY	Instance method	Public	Method	Performs a request	20081210
11	EXECUTE_UPDATE	Instance method	Public	Method	Executes an update command	20081210
12	GET_DB_NAME	Instance method	Public	Method	Returns database name	20081210
13	GET_DB_RELEASE	Instance method	Public	Method	Returns database release	20130411
14	GET_INSTANCE	Static method	Public	Method	Creates an instance of a class	20100629
15	IS_FEATURE_SUPPORTED	Instance method	Public	Method	Returns whether the feature is supported by database	20130411
16	PREPARE_UPDATE	Instance method	Public	Method	Prepares a command	20090624
17	RECONNECT	Instance method	Private	Method	Restore connection to database	20081210
18	USE_COMPRESSION	Instance method	Public	Method	Returns whether COMPRESS YES can be applied	20100504

Events

Class CL_RSDA_DB6_CONNECTION has no event.

Types

#	Type	Visibility	Typing	Associated Type	Description	Created on	Type Source
1	TY_R_INSTANCE	Private	Object reference (TYPE REF TO)	CL_RSDA_DB6_CONNECTION	DB6 NLS Connection Class	20081210
2	TY_TR_INSTANCES	Private	See coding			20081210	TY_TR_INSTANCES TYPE STANDARD TABLE OF ty_r_instance WITH KEY table_line

Method Signatures

Method ARCHIVE_LOG Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_R_LOG	Call by reference	☑	Object reference (TYPE REF TO)	IF_RSDAI_NEARLINE_LOG		Log	20120301

#	Exception	Resumable	Description	Created on
1	CX_SQL_EXCEPTION	☐	Exception Class for SQL Error	20120301

Method CLOSE_CONNECTION Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_R_LOG	Call by reference	☑	Object reference (TYPE REF TO)	IF_RSDAI_NEARLINE_LOG			20081211

#	Exception	Resumable	Description	Created on
1	CX_SQL_EXCEPTION	☐		20081211

Method CLOSE_PREPARED_STATEMENT Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_R_LOG	Call by reference	☑	Object reference (TYPE REF TO)	IF_RSDAI_NEARLINE_LOG		Log	20090624
2	Importing	I_R_PREP_STMT	Call by reference	☐	Object reference (TYPE REF TO)	CL_SQL_PREPARED_STATEMENT		Ein präpariertes SQL Statement	20090624

#	Exception	Resumable	Description	Created on
1	CX_SQL_EXCEPTION	☐	Ausnahmeklasse für SQL Fehler	20090624

Method CLOSE_RESULT_SET Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_R_LOG	Call by reference	☑	Object reference (TYPE REF TO)	IF_RSDAI_NEARLINE_LOG		Log	20090624
2	Importing	I_R_RESULT_SET	Call by reference	☐	Object reference (TYPE REF TO)	CL_SQL_RESULT_SET		Ergebnismenge einer SQL Query	20090624

#	Exception	Resumable	Description	Created on
1	CX_SQL_EXCEPTION	☐	Ausnahmeklasse für SQL Fehler	20090624

Method CONSTRUCTOR Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_CONNECTION_NAME	Call by reference	☐	Type reference (TYPE)	RSDA_CONNAME			20081211
2	Importing	I_CONNECTION_PARAMETERS	Call by reference	☑	Type reference (TYPE)	CLIKE			20081211

#	Exception	Resumable	Description	Created on
1	CX_RSDAI_COMMUNICATION_ERROR	☐		20081211

Method EVALUATE_FEATURES Signature

Method EVALUATE_FEATURES on class CL_RSDA_DB6_CONNECTION has no parameter.

#	Exception	Resumable	Description	Created on
1	CX_RSDAI_COMMUNICATION_ERROR	☐	Kommunikationsfehler (z.B. Netzwerkfehler)	20100504

Method EXECUTE_DDL Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_R_LOG	Call by reference	☑	Object reference (TYPE REF TO)	IF_RSDAI_NEARLINE_LOG			20081211
2	Importing	I_STATEMENT	Call by reference	☐	Type reference (TYPE)	CLIKE			20081211

#	Exception	Resumable	Description	Created on
1	CX_SQL_EXCEPTION	☐		20081211

Method EXECUTE_PREPARED_QUERY Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_R_LOG	Call by reference	☐	Object reference (TYPE REF TO)	IF_RSDAI_NEARLINE_LOG		Log	20090729
2	Importing	I_R_PREP_STMT	Call by reference	☐	Object reference (TYPE REF TO)	CL_SQL_PREPARED_STATEMENT		Ein präpariertes SQL Statement	20090729
3	Importing	I_T_PARAMS	Call by reference	☐	Type reference (TYPE)	STANDARD TABLE			20090729
4	Importing	I_WITH_HOLD	Call by reference	☐	Type reference (TYPE)	RS_BOOL	RS_C_FALSE	Boolean	20090729
5	Returning	R_R_RESULT	Value transfer	☐	Object reference (TYPE REF TO)	CL_SQL_RESULT_SET		Ergebnismenge einer SQL Query	20090729

#	Exception	Resumable	Description	Created on
1	CX_SQL_EXCEPTION	☐	Ausnahmeklasse für SQL Fehler	20090729

Method EXECUTE_PREPARED_UPDATE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_R_LOG	Call by reference	☑	Object reference (TYPE REF TO)	IF_RSDAI_NEARLINE_LOG		Log	20090624
2	Importing	I_R_PREP_STMT	Call by reference	☐	Object reference (TYPE REF TO)	CL_SQL_PREPARED_STATEMENT		Ein präpariertes SQL Statement	20090624
3	Importing	I_T_PARAMS	Call by reference	☐	Type reference (TYPE)	STANDARD TABLE			20090624
4	Returning	ROWS_PROCESSED	Value transfer	☐	Type reference (TYPE)	I			20090624

#	Exception	Resumable	Description	Created on
1	CX_SQL_EXCEPTION	☐	Ausnahmeklasse für SQL Fehler	20090624

Method EXECUTE_QUERY Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_R_LOG	Call by reference	☑	Object reference (TYPE REF TO)	IF_RSDAI_NEARLINE_LOG			20081211
2	Importing	I_STATEMENT	Call by reference	☐	Type reference (TYPE)	CLIKE			20081211
3	Importing	I_WITH_HOLD	Call by reference	☐	Type reference (TYPE)	RS_BOOL	RS_C_FALSE	Boolean	20090624
4	Returning	R_R_RESULT	Value transfer	☐	Object reference (TYPE REF TO)	CL_SQL_RESULT_SET			20081211

#	Exception	Resumable	Description	Created on
1	CX_PARAMETER_INVALID	☐		20081211
2	CX_SQL_EXCEPTION	☐		20081211

Method EXECUTE_UPDATE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_R_LOG	Call by reference	☑	Object reference (TYPE REF TO)	IF_RSDAI_NEARLINE_LOG			20081211
2	Importing	I_STATEMENT	Call by reference	☐	Type reference (TYPE)	CLIKE			20081211
3	Returning	ROWS_PROCESSED	Value transfer	☐	Type reference (TYPE)	I			20081211

#	Exception	Resumable	Description	Created on
1	CX_SQL_EXCEPTION	☐		20081211

Method GET_DB_NAME Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Returning	R_DB_NAME	Value transfer	☐	Type reference (TYPE)	DBCON_NAME			20081211

Method GET_DB_NAME on class CL_RSDA_DB6_CONNECTION has no exception.

Method GET_DB_RELEASE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Returning	R_DB_RELEASE	Value transfer	☐	Type reference (TYPE)	DB6DBREL		DB6: Datenbank-Release	20130411

Method GET_DB_RELEASE on class CL_RSDA_DB6_CONNECTION has no exception.

Method GET_INSTANCE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_CONNECTION_NAME	Call by reference	☐	Type reference (TYPE)	IF_RSDAI_NEARLINE_CONNECTION=>CONNECTION_NAME		BW-Archivierung: Name der Nearline-Connection	20100629
2	Importing	I_CONNECTION_PARAMETERS	Call by reference	☑	Type reference (TYPE)	IF_RSDAI_NEARLINE_CONNECTION=>CONNECTION_PARAMETERS		String für Verbindungsparameter	20100629
3	Importing	I_DESTINATION	Call by reference	☑	Type reference (TYPE)	IF_RSDAI_NEARLINE_CONNECTION=>DESTINATION		Destination-Tabelle fuer Remote Function Call	20100629
4	Importing	I_R_LOG	Call by reference	☑	Object reference (TYPE REF TO)	IF_RSDAI_NEARLINE_LOG		Log	20100629
5	Returning	R_R_CONNECTION	Value transfer	☐	Object reference (TYPE REF TO)	CL_RSDA_DB6_CONNECTION		DB6 NLS Verbindungsklasse	20100629

#	Exception	Resumable	Description	Created on
1	CX_RSDAI_COMMUNICATION_ERROR	☐	Kommunikationsfehler (z.B. Netzwerkfehler)	20100629

Method IS_FEATURE_SUPPORTED Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_FEATURE	Call by reference	☐	Type reference (TYPE)	RCDB6_FEATURE			20130411
2	Returning	R_SUPPORTED	Value transfer	☐	Type reference (TYPE)	RS_BOOL		Boolean	20130411

Method IS_FEATURE_SUPPORTED on class CL_RSDA_DB6_CONNECTION has no exception.

Method PREPARE_UPDATE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_R_LOG	Call by reference	☑	Object reference (TYPE REF TO)	IF_RSDAI_NEARLINE_LOG		Log	20090624
2	Importing	I_STATEMENT	Call by reference	☐	Type reference (TYPE)	CLIKE			20090624
3	Returning	R_R_PREP_STMT	Value transfer	☐	Object reference (TYPE REF TO)	CL_SQL_PREPARED_STATEMENT		Ein präpariertes SQL Statement	20090624

#	Exception	Resumable	Description	Created on
1	CX_SQL_EXCEPTION	☐	Ausnahmeklasse für SQL Fehler	20090624

Method RECONNECT Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_CONNECTION_PARAMETERS	Call by reference	☑	Type reference (TYPE)	IF_RSDAI_NEARLINE_CONNECTION=>CONNECTION_PARAMETERS			20081211
2	Importing	I_R_LOG	Call by reference	☑	Object reference (TYPE REF TO)	IF_RSDAI_NEARLINE_LOG			20081211

#	Exception	Resumable	Description	Created on
1	CX_SQL_EXCEPTION	☐		20081211

Method USE_COMPRESSION Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Returning	R_COMPRESSED	Value transfer	☐	Type reference (TYPE)	RS_BOOL		Boolean	20100504

Method USE_COMPRESSION on class CL_RSDA_DB6_CONNECTION has no exception.

History

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