SAP ABAP Class CL_RSDA_SDB_CONNECTION (Near-Line Connection Using MaxDB (Reference and Demo Impl.))

Hierarchy

☛ SAP_BW (Software Component) SAP Business Warehouse
   ⤷ BW-WHM-DST (Application Component) Data Staging
     ⤷ RSDA_SDB (Package) BW Archiving: Nearline Adapter for MaxDB

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	20040916
2	Interface implementation (CLASS c. INTERFACES i_ref)	IF_RSDAI_NEARLINE_CONNECTION_1	Test	20090313

Properties

Class	CL_RSDA_SDB_CONNECTION
Short Description	Near-Line Connection Using MaxDB (Reference and Demo Impl.)
Super Class
Instantiability of a Class	2	Public
Final	☑

General Data

Message Class	RSDA_SDB
Program status
Category	0
Package	RSDA_SDB	BW Archiving: Nearline Adapter for MaxDB
Created	20040916	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	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	20040916
2	IF_RSDAI_NEARLINE_CONNECTION_1	☐	☐	Test	20090313

Friends

#	Friend	Modeled only	Created on	Description
1	CL_RSDA_SDB_CURSOR	☐	20040916	Nearline Cursor Using Web Service
2	CL_RSDA_SDB_WRITER	☐	20040916	Nearline Writer Using Web Service

Attributes

#	Attribute	Level	Visibility	Read only	Typing	Associated Type	Initial Value	Description	Created on
1	CONNECTION_NAME	Instance attribute	Public	☑	Type reference (TYPE)	IF_RSDAI_NEARLINE_CONNECTION=>CONNECTION_NAME			20060713
2	C_DBMS	Constant	Public	☐	See coding				20100818
3	C_REFTAB_PREFIX	Constant	Public	☐	Type reference (TYPE)	TABNAME	'RSDAREFTABSDB_'	Prefix for Reference Tables/ Views	20040927
4	C_SEGVERS_DEFAULT	Constant	Public	☐	Type reference (TYPE)	RSDA_SEGVERS	IS INITIAL	BW Archiving: Segment Version	20040927
5	P_DBCON_NAME	Instance attribute	Private	☐	Type reference (TYPE)	DBCON_NAME		Logical Name for a Database Connection	20060713
6	P_R_SQL_CONNECTION	Instance attribute	Private	☐	Object reference (TYPE REF TO)	CL_SQL_CONNECTION			20041027
7	P_SX_TABL_ON	Static Attribute	Private	☐	Type reference (TYPE)	PTY_SX_TABL			20041115
8	P_SX_TABL_OR	Static Attribute	Private	☐	Type reference (TYPE)	PTY_SX_TABL			20041115
9	P_TR_INSTANCES	Static Attribute	Private	☐	Type reference (TYPE)	TY_TR_INSTANCES			20060713

Methods

#	Method	Level	Visibility	Method type	Description	Created on
1	CLOSE_CONNECTION	Instance method	Private	Method		20040927
2	CONSTRUCTOR	Instance method	Public	Constructor	CONSTRUCTOR	20040916
3	CREATE_LOCAL_PROXY_TABLE	Instance method	Private	Method		20041115
4	CREATE_REMOTE_JOIN_VIEW	Instance method	Private	Method		20041115
5	CREATE_REMOTE_TABLE	Instance method	Private	Method		20041115
6	CREATE_REMOTE_UNION_VIEW	Instance method	Private	Method		20041115
7	CREATE_REMOTE_VIEW	Instance method	Private	Method		20041115
8	DATA_EXISTS	Instance method	Public	Method		20041116
9	DELETE_DATA_PACKAGE	Instance method	Private	Method		20050315
10	DROP_REMOTE_TABLE	Instance method	Private	Method		20041116
11	DROP_REMOTE_VIEW	Instance method	Private	Method		20041116
12	EXECUTE_DDL	Instance method	Private	Method		20040927
13	GET_FIELD_DEFAULT	Instance method	Public	Method	Determine Default Value for Column	20040929
14	GET_TABLE_NAMES	Instance method	Public	Method	Create table	20041117
15	GET_TABL_DEFINITION	Static method	Private	Method		20041115
16	GET_VERSION_TABLE_NAMES	Instance method	Public	Method	Create table	20041117
17	RECONNECT	Instance method	Private	Method		20040927

Events

Class CL_RSDA_SDB_CONNECTION has no event.

Types

#	Type	Visibility	Typing	Associated Type	Description	Created on	Type Source
1	PTY_SX_TABL	Private	See coding		Complete Table Definition	20041115	BEGIN OF pty_sx_tabl, tabname TYPE tabname, gotstate TYPE ddgotstate, s_dd02v TYPE dd02v, s_dd09l TYPE dd09l, t_dd03p TYPE STANDARD TABLE OF dd03p WITH DEFAULT KEY, END OF pty_sx_tabl
2	TY_R_INSTANCE	Private	Object reference (TYPE REF TO)	CL_RSDA_SDB_CONNECTION		20060713
3	TY_TR_INSTANCES	Private	See coding			20060713	ty_tr_instances TYPE STANDARD TABLE OF ty_r_instance WITH KEY table_line

Method Signatures

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		Log	20060713

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

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		BW-Archivierung: Name der Nearline-Connection	20060713
2	Importing	I_CONNECTION_PARAMETERS	Call by reference	☑	Type reference (TYPE)	CLIKE			20060713

#	Exception	Resumable	Description	Created on
1	CX_RSDAI_COMMUNICATION_ERROR	☐	Zugriffsfehler (z.B. Netzwerkfehler)	20050207

Method CREATE_LOCAL_PROXY_TABLE 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	20060713
2	Importing	I_SX_TABL	Call by reference	☐	Type reference (TYPE)	PTY_SX_TABL		Komplette Tabellendefinition	20041115

#	Exception	Resumable	Description	Created on
1	CX_RSDAI_ACTION_FAILED	☐	Aktion wurde abgebrochen	20041115

Method CREATE_REMOTE_JOIN_VIEW 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	20060713
2	Importing	I_TABNAME	Call by reference	☑	Type reference (TYPE)	RSDA_TABNAME		Name einer Tabelle im Nearline Storage	20041117
3	Importing	I_TABNAME_REQUEST_STATE	Call by reference	☐	Type reference (TYPE)	RSDA_TABNAME		Name einer Tabelle im Nearline Storage	20041117
4	Importing	I_VIEWNAME	Call by reference	☐	Type reference (TYPE)	RSDA_TABNAME		Tabellenname	20041117

#	Exception	Resumable	Description	Created on
1	CX_RSDAI_ACTION_FAILED	☐	Aktion wurde abgebrochen	20041115
2	CX_RSDAI_COMMUNICATION_ERROR	☐	Zugriffsfehler (z.B. Netzwerkfehler)	20041115

Method CREATE_REMOTE_TABLE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_FOR_ARCHIVE	Call by reference	☑	Type reference (TYPE)	BOOLEAN		Boolean	20041115
2	Importing	I_PROXY_VIEWNAME	Call by reference	☑	Type reference (TYPE)	RSDAI_VIEW_NAME		Name der lokalen Proxy-Tabelle, falls erforderlich	20041117
3	Importing	I_R_LOG	Call by reference	☑	Object reference (TYPE REF TO)	IF_RSDAI_NEARLINE_LOG		Log	20060713
4	Importing	I_TABNAME	Call by reference	☐	Type reference (TYPE)	RSDAI_TABLE_NAME		Tabellenname	20041116
5	Importing	I_T_DDFIELDS	Call by reference	☑	Type reference (TYPE)	TY_T_DDFIELDS			20041115
6	Importing	I_T_FIELDS	Call by reference	☑	Type reference (TYPE)	IF_RSDAI_NEARLINE_CONNECTION=>T_TABLE_FIELDS		BW-Archivierung: Felder einer Tabelle im Nearline Storage	20041116

#	Exception	Resumable	Description	Created on
1	CX_RSDAI_ACTION_FAILED	☐	Aktion wurde abgebrochen	20041115
2	CX_RSDAI_COMMUNICATION_ERROR	☐	Zugriffsfehler (z.B. Netzwerkfehler)	20041115

Method CREATE_REMOTE_UNION_VIEW 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	20060713
2	Importing	I_T_ADDED_FIELDS	Call by reference	☑	Type reference (TYPE)	IF_RSDAI_NEARLINE_CONNECTION=>T_TABLE_FIELDS		BW-Archivierung: Felder einer Tabelle im Nearline Storage	20041116
3	Importing	I_VIEWNAME	Call by reference	☑	Type reference (TYPE)	IF_RSDAI_NEARLINE_CONNECTION=>VIEW_NAME		Name einer Tabelle im Nearline Storage	20041117
4	Importing	I_VIEWNAME_ADD	Call by reference	☐	Type reference (TYPE)	IF_RSDAI_NEARLINE_CONNECTION=>VIEW_NAME		Name einer Tabelle im Nearline Storage	20041117
5	Importing	I_VIEWNAME_UNION	Call by reference	☐	Type reference (TYPE)	IF_RSDAI_NEARLINE_CONNECTION=>VIEW_NAME		Tabellenname	20041117

#	Exception	Resumable	Description	Created on
1	CX_RSDAI_ACTION_FAILED	☐	Aktion wurde abgebrochen	20041115
2	CX_RSDAI_COMMUNICATION_ERROR	☐	Zugriffsfehler (z.B. Netzwerkfehler)	20041115

Method CREATE_REMOTE_VIEW Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_PROXY_VIEWNAME	Call by reference	☑	Type reference (TYPE)	IF_RSDAI_NEARLINE_CONNECTION=>VIEW_NAME		Name einer Tabelle im Nearline Storage	20041117
2	Importing	I_R_LOG	Call by reference	☑	Object reference (TYPE REF TO)	IF_RSDAI_NEARLINE_LOG		Log	20060713
3	Importing	I_TABNAME	Call by reference	☐	Type reference (TYPE)	IF_RSDAI_NEARLINE_CONNECTION=>TABLE_NAME		Name einer Tabelle oder eines Views	20041116
4	Importing	I_VIEWNAME	Call by reference	☐	Type reference (TYPE)	IF_RSDAI_NEARLINE_CONNECTION=>VIEW_NAME		Viewname	20041116

#	Exception	Resumable	Description	Created on
1	CX_RSDAI_ACTION_FAILED	☐	Aktion wurde abgebrochen	20041115
2	CX_RSDAI_COMMUNICATION_ERROR	☐	Zugriffsfehler (z.B. Netzwerkfehler)	20041115

Method DATA_EXISTS Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_TABLE_NAME	Call by reference	☐	Type reference (TYPE)	IF_RSDAI_NEARLINE_CONNECTION=>TABLE_NAME		Name einer Tabelle im Nearline Storage	20041116
2	Returning	R_RESULT	Value transfer	☐	Type reference (TYPE)	IF_RSDAI_NEARLINE_CONNECTION=>BOOLEAN		Boolean	20041116

Method DATA_EXISTS on class CL_RSDA_SDB_CONNECTION has no exception.

Method DELETE_DATA_PACKAGE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_DATA_PACKAGE_SID	Call by reference	☐	Type reference (TYPE)	RSSID		BW Archivierung: SID eines Archivierungs-/Rückladerequests	20050315
2	Importing	I_REQUEST_SID	Call by reference	☑	Type reference (TYPE)	RSDA_REQSID		Name der lokalen Proxy-Tabelle, falls erforderlich	20050315
3	Importing	I_R_LOG	Call by reference	☑	Object reference (TYPE REF TO)	IF_RSDAI_NEARLINE_LOG		Log	20060713
4	Importing	I_TABLE_NAME	Call by reference	☐	Type reference (TYPE)	RSDA_TABNAME		Tabellenname	20050315

#	Exception	Resumable	Description	Created on
1	CX_RSDAI_ACTION_FAILED	☐	Aktion wurde abgebrochen	20050315
2	CX_RSDAI_COMMUNICATION_ERROR	☐	Zugriffsfehler (z.B. Netzwerkfehler)	20050315

Method DROP_REMOTE_TABLE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_PROXY_VIEWNAME	Call by reference	☑	Type reference (TYPE)	RSDA_TABNAME		Name der lokalen Proxy-Tabelle, falls erforderlich	20041117
2	Importing	I_R_LOG	Call by reference	☑	Object reference (TYPE REF TO)	IF_RSDAI_NEARLINE_LOG		Log	20060713
3	Importing	I_TABNAME	Call by reference	☐	Type reference (TYPE)	RSDA_TABNAME		Tabellenname	20041116

#	Exception	Resumable	Description	Created on
1	CX_RSDAI_ACTION_FAILED	☐	Aktion wurde abgebrochen	20041116
2	CX_RSDAI_COMMUNICATION_ERROR	☐	Zugriffsfehler (z.B. Netzwerkfehler)	20041116

Method DROP_REMOTE_VIEW Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_PROXY_VIEWNAME	Call by reference	☑	Type reference (TYPE)	IF_RSDAI_NEARLINE_CONNECTION=>VIEW_NAME		Name einer Tabelle im Nearline Storage	20041117
2	Importing	I_R_LOG	Call by reference	☑	Object reference (TYPE REF TO)	IF_RSDAI_NEARLINE_LOG		Log	20060713
3	Importing	I_VIEWNAME	Call by reference	☐	Type reference (TYPE)	IF_RSDAI_NEARLINE_CONNECTION=>VIEW_NAME		Viewname	20041116

#	Exception	Resumable	Description	Created on
1	CX_RSDAI_ACTION_FAILED	☐	Aktion wurde abgebrochen	20041116
2	CX_RSDAI_COMMUNICATION_ERROR	☐	Zugriffsfehler (z.B. Netzwerkfehler)	20041116

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		Log	20060713
2	Importing	I_STATEMENT	Call by reference	☐	Type reference (TYPE)	CLIKE			20040927

#	Exception	Resumable	Description	Created on
1	CX_RSDAI_COMMUNICATION_ERROR	☐	Kommunikationsfehler (z.B. Netzwerkfehler)	20100818
2	CX_SQL_EXCEPTION	☐	Aktion wurde abgebrochen	20040927

Method GET_FIELD_DEFAULT Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_S_FIELD	Call by reference	☐	Type reference (TYPE)	IF_RSDAI_NEARLINE_CONNECTION=>S_TABLE_FIELD		Spaltendefinition einer Tabelle im Nearline Storage	20041117
2	Returning	R_DEFAULT	Value transfer	☐	Type reference (TYPE)	STRING		Defaultwert als String	20040929

Method GET_FIELD_DEFAULT on class CL_RSDA_SDB_CONNECTION has no exception.

Method GET_TABLE_NAMES Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	E_PROXY_VIEWNAME_REQUEST_STATE	Call by reference	☐	Type reference (TYPE)	RSDA_TABNAME		Proxy-View zum Lesen und Schreiben der RequestSteuertabelle	20041117
2	Exporting	E_PROXY_VIEWNAME_UNION_READ	Call by reference	☐	Type reference (TYPE)	RSDA_TABNAME		Proxy-View zum Lesen	20041117
3	Exporting	E_PROXY_VIEWNAME_WRITE	Call by reference	☐	Type reference (TYPE)	RSDA_TABNAME		Proxy-View zum Scheiben in die aktive Tabellenversion	20041117
4	Exporting	E_TABNAME_REQUEST_STATE	Call by reference	☐	Type reference (TYPE)	RSDA_TABNAME		Request-Steuertabelle für Statusverwaltung	20041117
5	Exporting	E_T_DICTIONARY_OBJECTS	Call by reference	☐	Type reference (TYPE)	IF_RSDAI_NEARLINE_CONNECTION=>T_DICTIONARY_OBJECTS		BW Nearline Interface: Objektliste f. DDIC-Massenaktivierung	20060202
6	Exporting	E_VIEWNAME_UNION_READ	Call by reference	☐	Type reference (TYPE)	RSDA_TABNAME		(Union-)View zum Lesen	20041117
7	Exporting	E_VIEWNAME_WRITE	Call by reference	☐	Type reference (TYPE)	RSDA_TABNAME		View zum Schreiben in die aktive Tabellenversion	20041117
8	Importing	I_S_HEADER	Call by reference	☐	Type reference (TYPE)	IF_RSDAI_NEARLINE_CONNECTION=>S_TABLE_HEADER		Name der Nearline-Tabelle	20041117

Method GET_TABLE_NAMES on class CL_RSDA_SDB_CONNECTION has no exception.

Method GET_TABL_DEFINITION Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_TABNAME	Call by reference	☐	Type reference (TYPE)	TABNAME		Tabellenname	20041115
2	Importing	I_TABPREFIX	Call by reference	☐	Type reference (TYPE)	RSDA_TABPREFIX		BW Nearline Interface: Tabellenpräfix	20041115
3	Importing	I_T_FIELDS	Call by reference	☑	Type reference (TYPE)	IF_RSDAI_NEARLINE_CONNECTION=>T_TABLE_FIELDS		BW-Archivierung: Felder einer Tabelle im Nearline Storage	20041115
4	Returning	R_SX_TABL	Value transfer	☐	Type reference (TYPE)	PTY_SX_TABL		Komplette Tabellendefinition	20041115

Method GET_TABL_DEFINITION on class CL_RSDA_SDB_CONNECTION has no exception.

Method GET_VERSION_TABLE_NAMES Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	E_TABNAME	Call by reference	☐	Type reference (TYPE)	RSDA_TABNAME		View zum Schreiben in die aktive Tabellenversion	20041117
2	Exporting	E_VIEWNAME_READ	Call by reference	☐	Type reference (TYPE)	RSDA_TABNAME		Proxy-View zum Lesen und Schreiben der RequestSteuertabelle	20041117
3	Exporting	E_VIEWNAME_UNION_READ	Call by reference	☐	Type reference (TYPE)	RSDA_TABNAME		(Union-)View zum Lesen	20041117
4	Importing	I_S_HEADER	Call by reference	☐	Type reference (TYPE)	IF_RSDAI_NEARLINE_CONNECTION=>S_TABLE_HEADER		Name der Nearline-Tabelle	20041117
5	Importing	I_S_VERSION_HEADER	Call by reference	☐	Type reference (TYPE)	IF_RSDAI_NEARLINE_CONNECTION=>S_TABLE_VERSION_HEADER		Name der Nearline-Tabelle	20041119

Method GET_VERSION_TABLE_NAMES on class CL_RSDA_SDB_CONNECTION has no exception.

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			20070509
2	Importing	I_R_LOG	Call by reference	☑	Object reference (TYPE REF TO)	IF_RSDAI_NEARLINE_LOG		Log	20060713

#	Exception	Resumable	Description	Created on
1	CX_RSDAI_COMMUNICATION_ERROR	☐	Zugriffsfehler (z.B. Netzwerkfehler)	20100818
2	CX_SQL_EXCEPTION	☐	Ausnahmeklasse für SQL Fehler	20070509

History

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