SAP ABAP Class CL_DB2_CCMS_DDIC (DBA tables - creation, check etc.)

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-DB-DB2 (Application Component) DB2 for z/OS
     ⤷ STU2 (Package) CCMS for DB2 for OS/390

Properties

Class	CL_DB2_CCMS_DDIC
Short Description	DBA tables - creation, check etc.
Super Class
Instantiability of a Class	2	Public
Final	☑

General Data

Message Class
Program status
Category	0
Package	STU2	CCMS for DB2 for OS/390
Created	20090319	SAP
Last change	20140121	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_DB2_CCMS_DDIC has no interface implemented.

Friends

Class CL_DB2_CCMS_DDIC has no friend class.

Attributes

#	Attribute	Level	Visibility	Read only	Typing	Associated Type	Initial Value	Description	Created on
1	C_DUPLICATES_ALLOWED	Constant	Public	☐	Type reference (TYPE)	ABAP_CHAR1	SPACE	Unique Rule Duplicates allowed	20130812
2	C_PRIMARY_KEY	Constant	Public	☐	Type reference (TYPE)	ABAP_CHAR1	'P'	Unique Rule: Primary Key	20130812
3	C_UNIQUE_INDEX	Constant	Public	☐	Type reference (TYPE)	ABAP_CHAR1	'U'	Unique Rule: Unique Index	20130812
4	DBNAME	Instance attribute	Private	☐	Type reference (TYPE)	DB2DBNAML		DB2 DB Name	20090323
5	IMPLICIT	Instance attribute	Private	☐	Type reference (TYPE)	ABAP_BOOL		implicit object creation	20090323
6	REMOTE_DBCON	Instance attribute	Private	☐	Type reference (TYPE)	DBCON-CON_NAME		Logical name for a database connection	20090323
7	SCHEMA	Instance attribute	Private	☐	Type reference (TYPE)	DB2CREATOR		Schema	20090323
8	TSNAME	Instance attribute	Private	☐	Type reference (TYPE)	DB2TSNAML		TS Name	20090323

Methods

#	Method	Level	Visibility	Method type	Description	Created on
1	CHECK_DDIC_TABLE	Instance method	Public	Method	compare DDIC table definition to DB2 catalog	20090323
2	CHECK_NATIVE_TABLE	Instance method	Public	Method	compare table definition to DB2 catalog	20090323
3	CHECK_TABLE	Instance method	Private	Method	check table	20090323
4	CONSTRUCTOR	Instance method	Public	Constructor	constructor	20090323
5	CREATE_AUX_TABLE	Instance method	Private	Method	create AUX Table	20090323
6	CREATE_AUX_TS	Instance method	Private	Method	create AUX TS	20090323
7	CREATE_DDIC_TABLE	Instance method	Public	Method	create DB table as defined in the SAP DDIC	20090323
8	CREATE_INDEX	Instance method	Private	Method	create index	20110603
9	CREATE_NATIVE_TABLE	Instance method	Public	Method	create DB table as specified in the input table	20090323
10	CREATE_TABLE	Instance method	Private	Method	create table	20090323
11	DROP_TABLE	Instance method	Private	Method	drops table	20090323
12	GET_DDIC_DESCR	Instance method	Private	Method	read table and index description from DDIC	20110531
13	INDEX_EXISTS	Instance method	Public	Method	does table exist in db2	20130307
14	TABLE_EXISTS	Instance method	Public	Method	does table exist in db2	20110606
15	TABLE_IS_EMPTY	Static method	Public	Method	checks if table is empty	20121129

Events

Class CL_DB2_CCMS_DDIC has no event.

Types

Class CL_DB2_CCMS_DDIC has no local type.

Method Signatures

Method CHECK_DDIC_TABLE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	ALTER	Call by reference	☐	Type reference (TYPE)	ABAP_BOOL			20090323
2	Exporting	DIFFERS	Value transfer	☐	Type reference (TYPE)	ABAP_BOOL			20090323
3	Exporting	EXISTS	Value transfer	☐	Type reference (TYPE)	ABAP_BOOL			20090323
4	Importing	TABLE_NAME	Call by reference	☐	Type reference (TYPE)	DB2TABNAML			20090323

#	Exception	Resumable	Description	Created on
1	CX_DB2_ROOT	☐	DB2: root class regarding exceptions	20090323
2	CX_SQL_EXCEPTION	☐	Exception Class for SQL Error	20090323

Method CHECK_NATIVE_TABLE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	ALTER	Call by reference	☐	Type reference (TYPE)	ABAP_BOOL			20090323
2	Importing	DESCR	Call by reference	☐	Type reference (TYPE)	DB2_COLUMN_DESCRIPTION_TAB			20090323
3	Exporting	DIFFERS	Value transfer	☐	Type reference (TYPE)	ABAP_BOOL			20090323
4	Exporting	EXISTS	Value transfer	☐	Type reference (TYPE)	ABAP_BOOL			20090323
5	Importing	INDEX_DESCR	Value transfer	☑	Type reference (TYPE)	DB2_IDX_COLUMN_DESCRIPTION_TAB		Internal table for column description of a DB Index	20130307
6	Importing	INDEX_NAME	Call by reference	☑	Type reference (TYPE)	DB2IDXNAML		DB2 long index name	20130307
7	Importing	TABLE_NAME	Call by reference	☐	Type reference (TYPE)	DB2TABNAML			20090323
8	Importing	UNIQUE_RULE	Call by reference	☐	Type reference (TYPE)	ABAP_CHAR1	C_PRIMARY_KEY		20130812

#	Exception	Resumable	Description	Created on
1	CX_DB2_ROOT	☐	DB2: root class regarding exceptions	20090323
2	CX_SQL_EXCEPTION	☐	Exception Class for SQL Error	20090323

Method CHECK_TABLE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	DESCR	Call by reference	☐	Type reference (TYPE)	DB2_COLUMN_DESCRIPTION_TAB			20090323
2	Returning	DIFFERS	Value transfer	☐	Type reference (TYPE)	ABAP_BOOL			20090323
3	Importing	TABLE_NAME	Call by reference	☐	Type reference (TYPE)	DB2TABNAML			20090323

#	Exception	Resumable	Description	Created on
1	CX_DB2_ROOT	☐	DB2: root class regarding exceptions	20090323
2	CX_SQL_EXCEPTION	☐	Exception Class for SQL Error	20090323

Method CONSTRUCTOR Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	REMOTE_DBCON	Call by reference	☐	Type reference (TYPE)	DBCON-CON_NAME			20090323

#	Exception	Resumable	Description	Created on
1	CX_DB2_ROOT	☐	DB2: root class regarding exceptions	20090323
2	CX_SQL_EXCEPTION	☐	Exception Class for SQL Error	20090323

Method CREATE_AUX_TABLE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	COLUMN_NAME	Call by reference	☐	Type reference (TYPE)	DB2COLNAML			20090323
2	Importing	TABLE_NAME	Call by reference	☐	Type reference (TYPE)	DB2TABNAML			20090323

#	Exception	Resumable	Description	Created on
1	CX_DB2_ROOT	☐	DB2: root class regarding exceptions	20090323
2	CX_SQL_EXCEPTION	☐	Exception Class for SQL Error	20090323

Method CREATE_AUX_TS Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Returning	TSAUX	Value transfer	☐	Type reference (TYPE)	DB2TSNAME			20110606

#	Exception	Resumable	Description	Created on
1	CX_DB2_ROOT	☐	DB2: root class regarding exceptions	20090323
2	CX_SQL_EXCEPTION	☐	Exception Class for SQL Error	20090323

Method CREATE_DDIC_TABLE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	TABLE_NAME	Call by reference	☐	Type reference (TYPE)	DB2TABNAML			20090323

#	Exception	Resumable	Description	Created on
1	CX_DB2_ROOT	☐	DB2: root class regarding exceptions	20090323
2	CX_SQL_EXCEPTION	☐	Exception Class for SQL Error	20090323

Method CREATE_INDEX Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	INDEX_DESCR	Value transfer	☐	Type reference (TYPE)	DB2_IDX_COLUMN_DESCRIPTION_TAB		Internal table for column description of a DB Index	20110603
2	Importing	INDEX_NAME	Call by reference	☐	Type reference (TYPE)	DB2IDXNAML		DB2 long index name	20110603
3	Importing	TABLE_NAME	Call by reference	☐	Type reference (TYPE)	DB2TABNAML			20110603
4	Importing	UNIQUE_RULE	Call by reference	☑	Type reference (TYPE)	ABAP_CHAR1			20130812

#	Exception	Resumable	Description	Created on
1	CX_DB2_ROOT	☐		20110603
2	CX_SQL_EXCEPTION	☐		20110603

Method CREATE_NATIVE_TABLE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	DESCR	Call by reference	☐	Type reference (TYPE)	DB2_COLUMN_DESCRIPTION_TAB			20090323
2	Importing	TABLE_NAME	Call by reference	☐	Type reference (TYPE)	DB2TABNAML			20090323

#	Exception	Resumable	Description	Created on
1	CX_DB2_ROOT	☐	DB2: root class regarding exceptions	20090323
2	CX_SQL_EXCEPTION	☐	Exception Class for SQL Error	20090323

Method CREATE_TABLE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	DESCR	Value transfer	☐	Type reference (TYPE)	DB2_COLUMN_DESCRIPTION_TAB			20090323
2	Importing	TABLE_NAME	Call by reference	☐	Type reference (TYPE)	DB2TABNAML			20090323

#	Exception	Resumable	Description	Created on
1	CX_DB2_ROOT	☐	DB2: root class regarding exceptions	20090323
2	CX_SQL_EXCEPTION	☐	Exception Class for SQL Error	20090323

Method DROP_TABLE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	TABLE_NAME	Call by reference	☐	Type reference (TYPE)	DB2TABNAML			20090323

#	Exception	Resumable	Description	Created on
1	CX_DB2_ROOT	☐	DB2: root class regarding exceptions	20090323
2	CX_SQL_EXCEPTION	☐	Exception Class for SQL Error	20090323

Method GET_DDIC_DESCR Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	PKEY_DESCR	Call by reference	☐	Type reference (TYPE)	DB2_IDX_COLUMN_DESCRIPTION_TAB		Internal table for column description of a DB Index	20110601
2	Exporting	PKEY_NAME	Call by reference	☐	Type reference (TYPE)	DB2IDXNAML		DB2 long index name	20110603
3	Exporting	TABLE_DESCR	Call by reference	☐	Type reference (TYPE)	DB2_COLUMN_DESCRIPTION_TAB		internal table for column descriptions	20110601
4	Importing	TABLE_NAME	Call by reference	☐	Type reference (TYPE)	DB2TABNAML		DB2 long table name	20110531

#	Exception	Resumable	Description	Created on
1	CX_DB2_ROOT	☐	DBA Cockpit: Root exception class	20110601

Method INDEX_EXISTS Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Returning	EXISTS	Value transfer	☐	Type reference (TYPE)	ABAP_BOOL			20130307
2	Importing	INDEX_NAME	Call by reference	☐	Type reference (TYPE)	DB2IDXNAML		DB2 long index name	20130307

#	Exception	Resumable	Description	Created on
1	CX_DB2_ROOT	☐	DB2: root class regarding exceptions	20130307
2	CX_SQL_EXCEPTION	☐	Exception Class for SQL Error	20130307

Method TABLE_EXISTS Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Returning	EXISTS	Value transfer	☐	Type reference (TYPE)	ABAP_BOOL			20110606
2	Importing	TABLE_NAME	Call by reference	☐	Type reference (TYPE)	DB2TABNAML			20110606

#	Exception	Resumable	Description	Created on
1	CX_DB2_ROOT	☐	DB2: root class regarding exceptions	20110606
2	CX_SQL_EXCEPTION	☐	Exception Class for SQL Error	20110606

Method TABLE_IS_EMPTY Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Returning	EMPTY	Value transfer	☐	Type reference (TYPE)	ABAP_BOOL			20121129
2	Importing	REMOTE_DBCON	Call by reference	☐	Type reference (TYPE)	DBCON-CON_NAME		Logical name for a database connection	20130402
3	Importing	TABLE_NAME	Call by reference	☐	Type reference (TYPE)	DB2TABNAML		DB2 long table name	20121129

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

History

Last changed by/on	SAP	20140121
SAP Release Created in	731