SAP ABAP Class CL_IUUC_DB_RCV_HDB (HANA implementation)

Hierarchy

☛ DMIS (Software Component) DMIS 2011_1
   ⤷ CA-EUR (Application Component) European Monetary Union: Euro
     ⤷ CNV_IUUC_DB_CONNECTION (Package) Encapsulation of communication with remote systems non RFC

Meta Relationship - Using

#	Relationship type	Using	Short Description	Created on
1	Inheritance (c INHERITING FROM c_ref)	CL_IUUC_DB_CONN_RCV	abstract super class for db connections	20120425

Properties

Class	CL_IUUC_DB_RCV_HDB
Short Description	HANA implementation
Super Class	CL_IUUC_DB_CONN_RCV	abstract super class for db connections
Instantiability of a Class	2	Public
Final	☑

General Data

Message Class
Program status
Category	0
Package	CNV_IUUC_DB_CONNECTION	Encapsulation of communication with remote systems non RFC
Created	20120425	SAP
Last change	20141030
Shared Memory-enabled	☐
Fixed point arithmetic	☑
Unicode checks active	☑

Forward declarations

Class CL_IUUC_DB_RCV_HDB has no forward declaration.

Interfaces

Class CL_IUUC_DB_RCV_HDB has no interface implemented.

Friends

Class CL_IUUC_DB_RCV_HDB has no friend class.

Attributes

#	Attribute	Level	Visibility	Read only	Typing	Associated Type	Initial Value	Description	Created on
1	GC_SYNONYM_EXISTS	Constant	Public	☐	Type reference (TYPE)	I	330		20140218
2	RS_ORDER_EXIST	Instance attribute	Private	☐	Type reference (TYPE)	BOOLEAN		boolean variable (X=true, -=false, space=unknown)	20120604
3	RS_ORDER_EXIST_READ	Instance attribute	Private	☐	Type reference (TYPE)	BOOLEAN		boolean variable (X=true, -=false, space=unknown)	20120604
4	RS_STATUS_DECISECOND	Instance attribute	Private	☐	Type reference (TYPE)	IUUC_COUNT	0	Number of table entries	20120905
5	RS_STATUS_TIMESTAMP	Instance attribute	Private	☐	Type reference (TYPE)	TIMESTAMP		Value of the last issued timestamp	20121220
6	RS_TABLES_ALTER	Instance attribute	Private	☐	Type reference (TYPE)	IUUC_S_CHECK_CNTR_TAB_RESULT		boolean variable (X=true, -=false, space=unknown)	20120611

Methods

#	Method	Level	Visibility	Method type	Description	Created on
1	ADJUST_TABLE_TYPE	Instance method	Private	Method	adjust the table type row/column/history column	20121019
2	CHECK_ALTERED_CNTR_TAB	Instance method	Private	Method	check if RS_ORDER is already altered	20120611
3	CHECK_CREATE_ROLE	Instance method	Private	Method	first check and afterwards create role	20120524
4	CHECK_CREATE_SCHEMA	Instance method	Private	Method	check schema existence and create schema	20120516
5	CHECK_CREATE_USER	Instance method	Private	Method	check user existence and create user	20120516
6	CHECK_SND_ALREADY_IN_USE	Instance method	Private	Method	do not allow 1:N and N:1 replication combined	20120516
7	CONCAT_CREATE_STATEMENT	Instance method	Private	Method	concatenate the create statement	20120530
8	CREATE_NON_UNIQUE_SEC_INDICES	Instance method	Private	Method	create unique indices of the table	20140224
9	CREATE_TABLE_COMMENTS	Instance method	Private	Method	add comments to the table/column	20121025
10	CREATE_UNIQUE_SEC_INDICES	Instance method	Private	Method	create unique indices of the table	20140224
11	GET_CREATE_AS_STRING	Instance method	Private	Method	get create statement as string into statement attribute	20121025
12	GET_MAX_SYNONYM	Instance method	Private	Method	get max synonym with specific naming convention	20120925
13	GET_SCHEMAS	Instance method	Private	Method	Read schema from SYS_REPL.RS_REPLICATION_COMPONENTS	20140123
14	GET_SEQS_PROCS_AS_STRING	Instance method	Private	Method	Get sequences or procedures as strings	20120525
15	GET_SYNONYMS	Instance method	Private	Method	Returns list of all synonyms in schema	20140127
16	GET_TABLES	Instance method	Private	Method	Return list of all tables in given schema or schemas	20140127
17	GET_TIMESTAMP	Instance method	Private	Method	Returns the hana valid timestamp	20120905
18	GRANT_IN_CONFIG_TRG	Instance method	Private	Method	grant in the configuration target	20120525
19	GRANT_IN_REPL_TRG	Instance method	Private	Method	grant in the replication target	20120525
20	GRANT_STATIC	Static method	Public	Method	allow special grant options	20120529
21	INSERT_DB_RCV_CONF_PARAMS	Static method	Public	Method	insert into iuuc_db_rcv_conf Oracle specific params	20130208
22	TYPRED_BUILD_REDEFINITON	Instance method	Private	Method	Redefine type mapping	20121114
23	TYPRED_TYPE_REPLACE	Instance method	Private	Method	Replace type mapping	20130115

Events

Class CL_IUUC_DB_RCV_HDB has no event.

Types

#	Type	Visibility	Typing	Associated Type	Description	Created on	Type Source
1	TT_FIELDS_IN_STMT	Private	See coding		Fields in statement	20121114
2	T_FIELDS_IN_STMT	Private	See coding		Field in statement	20121114

Method Signatures

Method ADJUST_TABLE_TYPE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IV_ROW_STORE	Call by reference	☐	Type reference (TYPE)	IUUC_REPL_TABLE_TYPE		table type like default column store / row store / history m	20121019
2	Changing	XT_STATEMENTS	Call by reference	☐	Type reference (TYPE)	IUUC_REPL_T_STATEMENTS		Statements for execution in remote system	20121019

Method ADJUST_TABLE_TYPE on class CL_IUUC_DB_RCV_HDB has no exception.

Method CHECK_ALTERED_CNTR_TAB Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IV_SCHEMA_NAME	Call by reference	☐	Type reference (TYPE)	IUUC_IMDB_SCHEMA		Schema Name	20120611
2	Returning	RS_CHECK_RESULT	Value transfer	☐	Type reference (TYPE)	IUUC_S_CHECK_CNTR_TAB_RESULT		boolean variable (X=true, -=false, space=unknown)	20121023

#	Exception	Resumable	Description	Created on
1	CX_IUUC_REPL_SQL	☐	SQL error in the access clases	20120611

Method CHECK_CREATE_ROLE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IV_ROLE_NAME	Call by reference	☐	Type reference (TYPE)	IUUC_REPL_ROLE_TYPE		Role Type	20120524
2	Importing	IV_SCHEMA_NAME	Call by reference	☐	Type reference (TYPE)	IUUC_IMDB_SCHEMA		Schema Name	20120524
3	Returning	RV_ROLE_EXIST	Value transfer	☐	Type reference (TYPE)	BOOLEAN		boolean variable (X=true, -=false, space=unknown)	20120524

#	Exception	Resumable	Description	Created on
1	CX_IUUC_REPL_SQL	☐	SQL error in the access clases	20120524

Method CHECK_CREATE_SCHEMA Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IV_SCHEMA_NAME	Call by reference	☐	Type reference (TYPE)	IUUC_IMDB_SCHEMA		Schema Name	20120516
2	Importing	IV_USER_NAME	Call by reference	☐	Type reference (TYPE)	IUUC_IMDB_USER		Name of IMDB user	20120516
3	Returning	RV_SCHEMA_EXISTS	Value transfer	☐	Type reference (TYPE)	BOOLEAN		boolean variable (X=true, -=false, space=unknown)	20120516

#	Exception	Resumable	Description	Created on
1	CX_IUUC_REPL_SQL	☐	SQL error in the access clases	20120516

Method CHECK_CREATE_USER Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IV_CHECK_ONLY	Call by reference	☑	Type reference (TYPE)	BOOLEAN		boolean variable (X=true, -=false, space=unknown)	20120523
2	Importing	IV_PASSWORD	Call by reference	☐	Type reference (TYPE)	STRING			20120516
3	Importing	IV_USER_NAME	Call by reference	☐	Type reference (TYPE)	IUUC_IMDB_USER		Name of IMDB user	20120516
4	Returning	RV_USER_EXISTS	Value transfer	☐	Type reference (TYPE)	BOOLEAN		boolean variable (X=true, -=false, space=unknown)	20120516

#	Exception	Resumable	Description	Created on
1	CX_IUUC_REPL_SQL	☐	SQL error in the access clases	20120516

Method CHECK_SND_ALREADY_IN_USE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IV_SCHEMA_NAME	Call by reference	☐	Type reference (TYPE)	IUUC_IMDB_SCHEMA		Schema Name	20120516
2	Importing	IV_SOURCE_RFCDEST	Call by reference	☐	Type reference (TYPE)	RFCDEST		Logical Destination (Specified in Function Call)	20120516
3	Returning	RV_SID	Value transfer	☐	Type reference (TYPE)	BOOLEAN		boolean variable (X=true, -=false, space=unknown)	20120516

#	Exception	Resumable	Description	Created on
1	CX_IUUC_REPL_CONFIGURATION	☐	Configuration static check	20120516
2	CX_SQL_EXCEPTION	☐	Exception Class for SQL Error	20120516

Method CONCAT_CREATE_STATEMENT Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IV_SCHEMA_NAME	Call by reference	☐	Type reference (TYPE)	IUUC_IMDB_SCHEMA		Schema Name	20120530
2	Importing	IV_TABNAME	Call by reference	☐	Type reference (TYPE)	TABNAME		Table Name	20120530

Method CONCAT_CREATE_STATEMENT on class CL_IUUC_DB_RCV_HDB has no exception.

Method CREATE_NON_UNIQUE_SEC_INDICES Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IT_DD03P	Call by reference	☐	Type reference (TYPE)	DMC_DD03P_TAB		DMC: Table type for the field list of a structure	20140224
2	Importing	IV_MT_ID	Call by reference	☐	Type reference (TYPE)	DMC_MT_IDENTIFIER		DMC: Indicator for Mass Transfer	20140224
3	Importing	IV_SRC_TABNAME	Call by reference	☐	Type reference (TYPE)	TABNAME		Table Name	20140224
4	Importing	IV_TRG_TABNAME	Call by reference	☐	Type reference (TYPE)	TABNAME		Table Name	20140224

#	Exception	Resumable	Description	Created on
1	CX_IUUC_REPL_SQL	☐	SQL error in the access clases	20140224

Method CREATE_TABLE_COMMENTS Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IS_DD02V	Call by reference	☑	Type reference (TYPE)	DD02V		Generated Table for View DD02V	20121025
2	Importing	IT_DD03P_W_COMMENT	Call by reference	☐	Type reference (TYPE)	DMC_DD03P_TAB		DMC: Table type for the field list of a structure	20121025

#	Exception	Resumable	Description	Created on
1	CX_IUUC_REPL_SQL	☐	SQL error in the access clases	20130208

Method CREATE_UNIQUE_SEC_INDICES Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IT_DD03P	Call by reference	☐	Type reference (TYPE)	DMC_DD03P_TAB		DMC: Table type for the field list of a structure	20140224
2	Importing	IV_MT_ID	Call by reference	☐	Type reference (TYPE)	DMC_MT_IDENTIFIER		DMC: Indicator for Mass Transfer	20140224
3	Importing	IV_SRC_TABNAME	Call by reference	☐	Type reference (TYPE)	TABNAME		Table Name	20140224
4	Importing	IV_TRG_TABNAME	Call by reference	☐	Type reference (TYPE)	TABNAME		Table Name	20140224

#	Exception	Resumable	Description	Created on
1	CX_IUUC_REPL_SQL	☐	SQL error in the access clases	20140224

Method GET_CREATE_AS_STRING Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IT_STATEMENTS	Call by reference	☐	Type reference (TYPE)	IUUC_REPL_T_STATEMENTS		Table Name	20121025
2	Importing	IV_PARTITION_CMD	Call by reference	☑	Type reference (TYPE)	STRING			20121025

Method GET_CREATE_AS_STRING on class CL_IUUC_DB_RCV_HDB has no exception.

Method GET_MAX_SYNONYM Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IV_NAMING_CONVENTION	Call by reference	☐	Type reference (TYPE)	STRING			20120925
2	Returning	RV_SYNONYM	Value transfer	☐	Type reference (TYPE)	TABNAME		Table Name	20120925

#	Exception	Resumable	Description	Created on
1	CX_IUUC_REPL_SQL	☐	SQL error in the access clases	20130208
2	CX_IUUC_REPL_TECHNICAL	☐	Technical error in the access clases	20120925

Method GET_SCHEMAS Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IV_SLT_HOST	Call by reference	☑	Type reference (TYPE)	SYHOST		R/3 System, Name of Application Server	20140227
2	Importing	IV_SLT_SID	Call by reference	☑	Type reference (TYPE)	SYSYSID		Name of SAP R/3 System	20140227
3	Returning	RT_SCHEMAS	Value transfer	☐	Type reference (TYPE)	IUUC_T_SCHEMAS		Configuration Name	20140123

#	Exception	Resumable	Description	Created on
1	CX_IUUC_DB_CONN	☐	Excep. class for db connection	20140123

Method GET_SEQS_PROCS_AS_STRING Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	EV_RS_GRANT_ACCESS	Call by reference	☐	Type reference (TYPE)	STRING			20120525
2	Exporting	EV_RS_ORDERID_SEQ	Call by reference	☐	Type reference (TYPE)	STRING			20120525
3	Exporting	EV_RS_REVOKE_ACCESS	Call by reference	☐	Type reference (TYPE)	STRING			20120525
4	Importing	IV_SCHEMA_NAME	Call by reference	☐	Type reference (TYPE)	IUUC_IMDB_SCHEMA		Schema Name	20120525

Method GET_SEQS_PROCS_AS_STRING on class CL_IUUC_DB_RCV_HDB has no exception.

Method GET_SYNONYMS Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IT_OBJECT_SCHEMAS	Call by reference	☐	Type reference (TYPE)	IUUC_T_SCHEMAS		Schema of the base objects	20140203
2	Returning	RT_SYNONYM_LIST	Value transfer	☐	Type reference (TYPE)	IUUC_DB_REPO_SYNONYM_LIST		List of database synonyms with respective tables	20140127

#	Exception	Resumable	Description	Created on
1	CX_IUUC_DB_CONN	☐	Excep. class for db connection	20140127

Method GET_TABLES Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IT_TABLE_SCHEMAS	Call by reference	☑	Type reference (TYPE)	IUUC_T_SCHEMAS		Table Type of IMDB table SCHEMAS	20140127
2	Importing	IV_TABLE_PATTERN	Call by reference	☑	Type reference (TYPE)	DMC_DB_TABNAME		Generic data element for database table names	20140127
3	Importing	IV_TABLE_SCHEMA	Call by reference	☑	Type reference (TYPE)	IUUC_IMDB_SCHEMA		Configuration Name	20140127
4	Returning	RT_TABLES	Value transfer	☐	Type reference (TYPE)	IUUC_DB_REPO_TABLE_LIST		List of database tables as obtained from database repository	20140127

#	Exception	Resumable	Description	Created on
1	CX_IUUC_DB_CONN	☐	Excep. class for db connection	20140127

Method GET_TIMESTAMP Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Returning	RV_TIMESTAMP	Value transfer	☐	Type reference (TYPE)	STRING			20120905

Method GET_TIMESTAMP on class CL_IUUC_DB_RCV_HDB has no exception.

Method GRANT_IN_CONFIG_TRG Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IV_SCHEMA_NAME	Call by reference	☐	Type reference (TYPE)	IUUC_IMDB_SCHEMA		Schema Name	20120525

#	Exception	Resumable	Description	Created on
1	CX_IUUC_REPL_SQL	☐	SQL error in the access clases	20120525

Method GRANT_IN_REPL_TRG Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IV_SCHEMA_NAME	Call by reference	☐	Type reference (TYPE)	IUUC_IMDB_SCHEMA		Schema Name	20120525

#	Exception	Resumable	Description	Created on
1	CX_IUUC_REPL_SQL	☐	SQL error in the access clases	20120525

Method GRANT_STATIC Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IO_SQL_STATEMENT	Call by reference	☐	Object reference (TYPE REF TO)	CL_SQL_STATEMENT		Database Connection	20120529
2	Importing	IV_GRANT_ON_SCHEMA	Call by reference	☑	Type reference (TYPE)	STRING			20120529
3	Importing	IV_GRANT_ON_TABLE	Call by reference	☐	Type reference (TYPE)	STRING			20120529
4	Importing	IV_GRANT_OPTION	Call by reference	☐	Type reference (TYPE)	STRING			20120529
5	Importing	IV_ROLE	Call by reference	☐	Type reference (TYPE)	STRING			20120529
6	Importing	IV_SCHEMA_NAME	Call by reference	☐	Type reference (TYPE)	IUUC_IMDB_SCHEMA		Configuration GUID	20120529
7	Returning	RV_RESULT	Value transfer	☐	Type reference (TYPE)	BOOLEAN		boolean variable (X=true, -=false, space=unknown)	20120529

#	Exception	Resumable	Description	Created on
1	CX_IUUC_REPL_SQL	☐	SQL error in the access clases	20120529

Method INSERT_DB_RCV_CONF_PARAMS Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IV_CONFIG_GUID	Call by reference	☐	Type reference (TYPE)	IUUC_REPL_CONFIG_GUID		Configuration GUID	20130208

Method INSERT_DB_RCV_CONF_PARAMS on class CL_IUUC_DB_RCV_HDB has no exception.

Method TYPRED_BUILD_REDEFINITON Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IT_DD03P	Call by reference	☐	Type reference (TYPE)	DMC_DD03P_TAB		DMC: Table type for the field list of a structure	20121114
2	Importing	IV_MT_ID	Call by reference	☐	Type reference (TYPE)	DMC_MT_IDENTIFIER		DMC: Indicator for Mass Transfer	20121114
3	Importing	IV_TABNAME	Call by reference	☐	Type reference (TYPE)	TABNAME		Table Name	20121114

#	Exception	Resumable	Description	Created on
1	CX_IUUC_REPL_TECHNICAL	☐	Technical error in the access clases	20121114

Method TYPRED_TYPE_REPLACE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IT_DD03P	Call by reference	☐	Type reference (TYPE)	DMC_DD03P_TAB		DMC: Table type for the field list of a structure	20130115
2	Importing	IT_FIELDS_IN_REDEF_STMT	Call by reference	☐	Type reference (TYPE)	TT_FIELDS_IN_STMT			20130115

Method TYPRED_TYPE_REPLACE on class CL_IUUC_DB_RCV_HDB has no exception.

History

Last changed by/on	SAP	20141030
SAP Release Created in	2010_1_620