SAP ABAP Class CL_IUUC_SQL_TOOLS (Superclass for sql tools used for accessing secondary DB)
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 - Used By
# Relationship type Used by Short Description Created on
1 Inheritance (c INHERITING FROM c_ref)  CL_IUUC_SQL_TOOLS_INF Collection of native SQL tools for Informix 20130214
2 Inheritance (c INHERITING FROM c_ref)  CL_IUUC_SQL_TOOLS_ORA Collection of native SQL tools for Oracle 20130214
Properties
Class CL_IUUC_SQL_TOOLS  
Short Description Superclass for sql tools used for accessing secondary DB    
Super Class    
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 20130214   SAP 
Last change 20141030    
Shared Memory-enabled    
Fixed point arithmetic    
Unicode checks active    
Forward declarations
Class CL_IUUC_SQL_TOOLS has no forward declaration.
Interfaces
Class CL_IUUC_SQL_TOOLS has no interface implemented.
Friends
Class CL_IUUC_SQL_TOOLS has no friend class.
Attributes
# Attribute Level Visibility Read only Typing Associated Type Initial Value Description Created on
1 DBCON_NAME Instance attribute Protected Type reference (TYPE) DBCON_NAME Logical name for a database connection 20130214
2 SQL_CONNECTION Instance attribute Protected Object reference (TYPE REF TO) CL_SQL_CONNECTION Database Connection 20130214
3 SQL_STATEMENT Instance attribute Protected Object reference (TYPE REF TO) CL_SQL_STATEMENT SQL statement 20130214
Methods
# Method Level Visibility Method type Description Created on
1 CHARACTER_CHECK Instance method Protected Method Character check for names to avoid SQL code intrusion 20130926
2 CLOSE Instance method Public Method Commit and close the db connection, unregisters in factory 20130214
3 CONSTRUCTOR Instance method Public Constructor 20130214
4 CREATE_INDEX Instance method Public Method Create a database index 20130304
5 CREATE_SYNONYM Instance method Public Method Create synonym 20131218
6 CREATE_TABLE Instance method Public Method Create a database table 20130226
7 CREATE_TRIGGER Instance method Public Method Create database triggers 20131218
8 CREATE_VIEW Instance method Public Method Create view either as 1:1 mapping or as defined in columns 20130220
9 DROP_INDEX Instance method Public Method Drop a database index 20130304
10 DROP_SYNONYM Instance method Public Method Drop synonym 20131218
11 DROP_TABLE Instance method Public Method Drop a database table 20130226
12 DROP_VIEW Instance method Public Method Drop a view 20130220
13 GET_COLUMNS Instance method Public Method Return native definition of all table columns 20130215
14 GET_DBCON_NAME Instance method Public Method Return the name of the database connection 20130214
15 GET_DBMS Instance method Public Method Returns the database system 20130214
16 GET_INDEXES Instance method Public Method Returns a list of all indexes with the respective fields 20130220
17 GET_SCHEMAS Instance method Public Method List all schemas in database 20131218
18 GET_SYNONYMS Instance method Public Method Synonyms in schema and/or matching pattern 20131218
19 GET_TABLES Instance method Public Method Return list of all tables in schema and/or matching pattern 20130215
20 GET_TRIGGERS Instance method Public Method Returns a list of all triggers for a given table 20130222
21 GET_TRIGGER_CODE Instance method Public Method Return trigger coding 20131218
22 GET_VIEWS Instance method Public Method List all views in a schema and/or matching a pattern 20130220
23 MAP_ABAP_TO_NATIVE_TYPE Instance method Public Method Map ABAP data types to native database types 20131218
24 MAP_NATIVE_TO_ABAP_TYPE Instance method Public Method Type mapping from native to ABAP types 20131218
25 OPEN_CONNECTION Instance method Protected Method Open connection to database 20130215
Events
Class CL_IUUC_SQL_TOOLS has no event.
Types
Class CL_IUUC_SQL_TOOLS has no local type.
Method Signatures

Method CHARACTER_CHECK 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 20130926
2 Importing IT_FIELDS Call by reference Type reference (TYPE) IUUC_DB_REPO_COLUMN_LIST List of columns of a database table 20130926
3 Importing IT_INDEX Call by reference Type reference (TYPE) IUUC_DB_REPO_INDEX_LIST List of all database indexes defined for a table 20131014
4 Importing IV_DB_TABNAME Call by reference Type reference (TYPE) DMC_DB_TABNAME Generic data element for database table names 20130926
5 Importing IV_SCHEMA Call by reference Type reference (TYPE) IUUC_IMDB_SCHEMA Configuration Name 20130926
# Exception Resumable Description Created on
1 CX_IUUC_DB_CONN Excep. class for db connection 20130926

Method CLOSE Signature

Method CLOSE on class CL_IUUC_SQL_TOOLS has no parameter.
Method CLOSE on class CL_IUUC_SQL_TOOLS has no exception.

Method CONSTRUCTOR Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Importing IV_DBCON_NAME Call by reference Type reference (TYPE) DBCON_NAME 20130214
# Exception Resumable Description Created on
1 CX_IUUC_DB_CONN Excep. class for db connection 20130215

Method CREATE_INDEX Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Importing IT_INDEX Call by reference Type reference (TYPE) IUUC_DB_REPO_INDEX_LIST Definition of a database index 20130304
2 Importing IV_INDEX_NAME Call by reference Type reference (TYPE) IUUC_DB_REPO_INDEX_NAME Index name provided by database repository 20131218
3 Importing IV_INDEX_SCHEMA Call by reference Type reference (TYPE) IUUC_IMDB_SCHEMA 20131218
4 Importing IV_TABLE_NAME Call by reference Type reference (TYPE) DMC_DB_TABNAME 20131218
5 Importing IV_TABLE_SCHEMA Call by reference Type reference (TYPE) IUUC_IMDB_SCHEMA 20131218
# Exception Resumable Description Created on
1 CX_IUUC_DB_CONN Excep. class for db connection 20130304

Method CREATE_SYNONYM Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Importing IV_SYNONYM_NAME Call by reference Type reference (TYPE) DMC_DB_TABNAME Name of the synonym 20131218
2 Importing IV_SYNONYM_SCHEMA Call by reference Type reference (TYPE) IUUC_IMDB_SCHEMA Schema of the synonym, leave blank for public synonym 20131218
3 Importing IV_TABLE_NAME Call by reference Type reference (TYPE) DMC_DB_TABNAME Name of the source table 20131218
4 Importing IV_TABLE_SCHEMA Call by reference Type reference (TYPE) IUUC_IMDB_SCHEMA Schema of the source table 20131218
# Exception Resumable Description Created on
1 CX_IUUC_DB_CONN Excep. class for db connection 20131218

Method CREATE_TABLE Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Importing IT_COLUMNS Call by reference Type reference (TYPE) IUUC_DB_REPO_COLUMN_LIST List of columns of a database table 20131218
2 Importing IV_TABLESPACE Call by reference Type reference (TYPE) IUUC_DB_REPO_TABLESPACE Tablespace on database 20130314
3 Importing IV_TABLE_NAME Call by reference Type reference (TYPE) DMC_DB_TABNAME Generic data element for database table names 20130226
4 Importing IV_TABLE_SCHEMA Call by reference Type reference (TYPE) IUUC_IMDB_SCHEMA Schema Name 20130226
# Exception Resumable Description Created on
1 CX_IUUC_DB_CONN Excep. class for db connection 20130226

Method CREATE_TRIGGER Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Importing IT_LOGGED_FIELDS Call by reference Type reference (TYPE) IUUC_DB_REPO_TRIG_COLUMN_LIST Table type for IUUC_DB_REPO_TRIGGER_COLUMN 20131218
2 Importing IT_TRIGGER_CONDITIONS Call by reference Type reference (TYPE) ABAPPROG Table Type for ABAP Programs 20131218
3 Importing IV_LOGTAB_NAME Call by reference Type reference (TYPE) DMC_DB_TABNAME Name of the logging table 20131218
4 Importing IV_LOGTAB_SCHEMA Call by reference Type reference (TYPE) IUUC_IMDB_SCHEMA Schema of the logging table 20131218
5 Importing IV_TABLE_NAME Call by reference Type reference (TYPE) DMC_DB_TABNAME Name of the triggered table 20131218
6 Importing IV_TABLE_SCHEMA Call by reference Type reference (TYPE) IUUC_IMDB_SCHEMA Schema of the triggered table 20131218
7 Importing IV_TRIGGER_NAME Call by reference Type reference (TYPE) DMC_DB_TABNAME Name of the trigger 20131218
8 Importing IV_TRIGGER_SCHEMA Call by reference Type reference (TYPE) IUUC_IMDB_SCHEMA Schema of the trigger 20131218
9 Importing IV_TRIGGER_TYPE Call by reference Type reference (TYPE) IUUC_DB_REPO_TRIGGER_TYPE boolean variable (X=true, -=false, space=unknown) 20131218
# Exception Resumable Description Created on
1 CX_IUUC_DB_CONN Excep. class for db connection 20131218

Method CREATE_VIEW Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Importing IT_VIEW_COLUMNS Call by reference Type reference (TYPE) IUUC_DB_REPO_VIEW_COLUMN_LIST List of columns of a view 20131218
2 Importing IV_TABLE_NAME Call by reference Type reference (TYPE) DMC_DB_TABNAME Name of source table 20131218
3 Importing IV_TABLE_SCHEMA Call by reference Type reference (TYPE) IUUC_IMDB_SCHEMA Name of source table's schema 20131218
4 Importing IV_VIEW_NAME Call by reference Type reference (TYPE) DMC_DB_TABNAME Name of the view that will be created 20130220
5 Importing IV_VIEW_SCHEMA Call by reference Type reference (TYPE) IUUC_IMDB_SCHEMA Name of the schema where the view will be created 20130220
# Exception Resumable Description Created on
1 CX_IUUC_DB_CONN Excep. class for db connection 20130220

Method DROP_INDEX Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Importing IV_INDEX_NAME Call by reference Type reference (TYPE) IUUC_DB_REPO_INDEX_NAME Index name provided by database repository 20130304
2 Importing IV_INDEX_SCHEMA Call by reference Type reference (TYPE) IUUC_IMDB_SCHEMA Owner of the index 20130304
# Exception Resumable Description Created on
1 CX_IUUC_DB_CONN Excep. class for db connection 20130304

Method DROP_SYNONYM Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Importing IV_SYNONYM_NAME Call by reference Type reference (TYPE) DMC_DB_TABNAME Generic data element for database table names 20131218
2 Importing IV_SYNONYM_SCHEMA Call by reference Type reference (TYPE) IUUC_IMDB_SCHEMA Configuration Name 20131218
# Exception Resumable Description Created on
1 CX_IUUC_DB_CONN Excep. class for db connection 20131218

Method DROP_TABLE Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Importing IV_TABLE_NAME Call by reference Type reference (TYPE) DMC_DB_TABNAME Generic data element for database table names 20130226
2 Importing IV_TABLE_SCHEMA Call by reference Type reference (TYPE) IUUC_IMDB_SCHEMA Schema Name 20130226
# Exception Resumable Description Created on
1 CX_IUUC_DB_CONN Excep. class for db connection 20130226

Method DROP_VIEW Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Importing IV_VIEW_NAME Call by reference Type reference (TYPE) DMC_DB_TABNAME Generic data element for database table names 20130220
2 Importing IV_VIEW_SCHEMA Call by reference Type reference (TYPE) IUUC_IMDB_SCHEMA Schema Name 20130220
# Exception Resumable Description Created on
1 CX_IUUC_DB_CONN Excep. class for db connection 20130220

Method GET_COLUMNS Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Importing IV_TABLE_NAME Call by reference Type reference (TYPE) DMC_DB_TABNAME Generic data element for database table names 20130222
2 Importing IV_TABLE_SCHEMA Call by reference Type reference (TYPE) IUUC_IMDB_SCHEMA Schema Name 20130222
3 Exporting RT_COLUMNS Call by reference Type reference (TYPE) IUUC_DB_REPO_COLUMN_LIST Column list with their native type definition 20131218
# Exception Resumable Description Created on
1 CX_IUUC_DB_CONN Excep. class for db connection 20130215

Method GET_DBCON_NAME Signature

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

Method GET_DBCON_NAME on class CL_IUUC_SQL_TOOLS has no exception.

Method GET_DBMS Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Returning RV_DBMS Value transfer Type reference (TYPE) DBCON_DBMS Database system (ORA,INF, ... etc.) 20130214

Method GET_DBMS on class CL_IUUC_SQL_TOOLS has no exception.

Method GET_INDEXES Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Importing IV_INDEX_NAME Call by reference Type reference (TYPE) IUUC_DB_REPO_INDEX_NAME Index name provided by database repository 20131218
2 Importing IV_INDEX_TYPE Call by reference Type reference (TYPE) IUUC_DB_REPO_INDEX_TYPE Type of an index as provided by database repository 20131218
3 Importing IV_TABLE_NAME Call by reference Type reference (TYPE) DMC_DB_TABNAME Generic data element for database table names 20130222
4 Importing IV_TABLE_SCHEMA Call by reference Type reference (TYPE) IUUC_IMDB_SCHEMA Schema Name 20130222
5 Returning RT_INDEXES Value transfer Type reference (TYPE) IUUC_DB_REPO_INDEX_LIST List of all database indexes defined for a table 20130222
# Exception Resumable Description Created on
1 CX_IUUC_DB_CONN Excep. class for db connection 20130220

Method GET_SCHEMAS Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Importing IV_SCHEMA_PATTERN Call by reference Type reference (TYPE) IUUC_IMDB_SCHEMA Configuration Name 20131218
2 Returning RT_SCHEMAS Value transfer Type reference (TYPE) IUUC_DB_REPO_SCHEMA_LIST List of all database schemas 20131218
# Exception Resumable Description Created on
1 CX_IUUC_DB_CONN Excep. class for db connection 20131218

Method GET_SYNONYMS Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Importing IV_SYNONYM_PATTERN Call by reference Type reference (TYPE) DMC_DB_TABNAME Generic data element for database table names 20131218
2 Importing IV_SYNONYM_SCHEMA Call by reference Type reference (TYPE) IUUC_IMDB_SCHEMA Configuration Name 20131218
# Exception Resumable Description Created on
1 CX_IUUC_DB_CONN Excep. class for db connection 20131218

Method GET_TABLES Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Importing IV_TABLE_PATTERN Call by reference Type reference (TYPE) DMC_DB_TABNAME Generic data element for database table names 20131218
2 Importing IV_TABLE_SCHEMA Call by reference Type reference (TYPE) IUUC_IMDB_SCHEMA Schema Name 20130222
3 Returning RT_DB_TABLES Value transfer Type reference (TYPE) IUUC_DB_REPO_TABLE_LIST List of database tables as obtained from database repository 20130222
# Exception Resumable Description Created on
1 CX_IUUC_DB_CONN Excep. class for db connection 20130215

Method GET_TRIGGERS Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Importing IV_TABLE_PATTERN Call by reference Type reference (TYPE) DMC_DB_TABNAME Generic data element for database table names 20131218
2 Importing IV_TABLE_SCHEMA Call by reference Type reference (TYPE) IUUC_IMDB_SCHEMA Schema Name 20130222
3 Importing IV_TRIGGER_PATTERN Call by reference Type reference (TYPE) IUUC_DB_REPO_TRIGGER_NAME Trigger name provided by the database repository 20131218
4 Importing IV_TRIGGER_SCHEMA Call by reference Type reference (TYPE) IUUC_IMDB_SCHEMA Configuration Name 20131218
5 Importing IV_TRIGGER_TYPE Call by reference Type reference (TYPE) IUUC_DB_REPO_TRIGGER_TYPE Trigger type 20131218
6 Returning RT_TRIGGERS Value transfer Type reference (TYPE) IUUC_DB_REPO_TRIGGER_LIST List of database triggers 20130222
# Exception Resumable Description Created on
1 CX_IUUC_DB_CONN Excep. class for db connection 20130222

Method GET_TRIGGER_CODE Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Importing IV_TABLE_NAME Call by reference Type reference (TYPE) DMC_DB_TABNAME Generic data element for database table names 20131218
2 Importing IV_TABLE_SCHEMA Call by reference Type reference (TYPE) IUUC_IMDB_SCHEMA Configuration Name 20131218
3 Importing IV_TRIGGER_NAME Call by reference Type reference (TYPE) IUUC_DB_REPO_TRIGGER_NAME Trigger name provided by the database repository 20131218
4 Importing IV_TRIGGER_SCHEMA Call by reference Type reference (TYPE) IUUC_IMDB_SCHEMA Configuration Name 20131218
5 Returning RT_TRIGGER_LIST Value transfer Type reference (TYPE) IUUC_DB_REPO_TRIGGER_LIST List of database triggers 20131218
# Exception Resumable Description Created on
1 CX_IUUC_DB_CONN Excep. class for db connection 20131218

Method GET_VIEWS Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Importing IV_VIEW_PATTERN Call by reference Type reference (TYPE) DMC_DB_TABNAME Schema of the underlying table 20131218
2 Importing IV_VIEW_SCHEMA Call by reference Type reference (TYPE) IUUC_IMDB_SCHEMA Schema of the view 20130222
3 Returning RT_VIEWS Value transfer Type reference (TYPE) IUUC_DB_REPO_VIEW_LIST List of database views with the respective tables 20130220
# Exception Resumable Description Created on
1 CX_IUUC_DB_CONN Excep. class for db connection 20130220

Method MAP_ABAP_TO_NATIVE_TYPE Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Exporting EV_IS_NOT_NULL Call by reference Type reference (TYPE) BOOLEAN boolean variable (X=true, -=false, space=unknown) 20131219
2 Exporting EV_NATIVE_CHAR_LENGTH Call by reference Type reference (TYPE) INT4 For character fields, data length in characters 20131218
3 Exporting EV_NATIVE_DATA_TYPE Call by reference Type reference (TYPE) IUUC_DB_REPO_DATA_TYPE Native data type provided by database 20131219
4 Exporting EV_NATIVE_LENGTH Call by reference Type reference (TYPE) INT4 Data length in byte 20131218
5 Exporting EV_NATIVE_PRECISION Call by reference Type reference (TYPE) INT2 2 byte integer (signed) 20131219
6 Exporting EV_NATIVE_SCALE Call by reference Type reference (TYPE) INT2 2 byte integer (signed) 20131218
7 Importing IV_ABAP_DATATYPE Call by reference Type reference (TYPE) DATATYPE_D Data Type in ABAP Dictionary 20131218
8 Importing IV_ABAP_DECIMALS Call by reference Type reference (TYPE) DDLENG Length (No. of Characters) 20131218
9 Importing IV_ABAP_LENGTH Call by reference Type reference (TYPE) DDLENG Length (No. of Characters) 20131218
# Exception Resumable Description Created on
1 CX_IUUC_DB_CONN Excep. class for db connection 20131218

Method MAP_NATIVE_TO_ABAP_TYPE Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Exporting EV_ABAP_DATATYPE Call by reference Type reference (TYPE) DATATYPE_D Data Type in ABAP Dictionary 20131218
2 Exporting EV_ABAP_DECIMALS Call by reference Type reference (TYPE) DDLENG Length (No. of Characters) 20131218
3 Exporting EV_ABAP_LENGTH Call by reference Type reference (TYPE) DDLENG Length (No. of Characters) 20131218
4 Importing IV_IS_NOT_NULL Call by reference Type reference (TYPE) BOOLEAN boolean variable (X=true, -=false, space=unknown) 20131219
5 Importing IV_NATIVE_CHAR_LENGTH Call by reference Type reference (TYPE) INT4 Natural number 20131218
6 Importing IV_NATIVE_DATA_TYPE Call by reference Type reference (TYPE) IUUC_DB_REPO_DATA_TYPE Native data type provided by database 20131219
7 Importing IV_NATIVE_DESCRIPTION Call by reference Type reference (TYPE) IUUC_DB_REPO_COLUMN_DESCR Column description as obtaind from database repository 20131219
8 Importing IV_NATIVE_LENGTH Call by reference Type reference (TYPE) INT4 Natural number 20131218
9 Importing IV_NATIVE_PRECISION Call by reference Type reference (TYPE) INT2 2 byte integer (signed) 20131219
10 Importing IV_NATIVE_SCALE Call by reference Type reference (TYPE) INT2 2 byte integer (signed) 20131218
# Exception Resumable Description Created on
1 CX_IUUC_DB_CONN Excep. class for db connection 20131218

Method OPEN_CONNECTION Signature

Method OPEN_CONNECTION on class CL_IUUC_SQL_TOOLS has no parameter.
# Exception Resumable Description Created on
1 CX_IUUC_DB_CONN Excep. class for db connection 20130215
History
Last changed by/on SAP  20141030 
SAP Release Created in 2010_1_620