SAP ABAP Class CL_SMIGR_DDL (DDL for Homogeneous and Non-Homogeneous DB Migration)

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-DB (Application Component) Database Interface, Database Platforms
     ⤷ SMIGR (Package) Homogeneous and Non-Homogeneous DB System Migration

Meta Relationship - Used By

#	Relationship type	Used by	Short Description	Created on
1	Inheritance (c INHERITING FROM c_ref)	CL_SMIGR_DDL_ADA	DDL for Homogeneous and Non-Homogeneous DB Migration	20040511
2	Inheritance (c INHERITING FROM c_ref)	CL_SMIGR_DDL_DB2	DDL for Homogeneous and Non-Homogeneous DB Migration	20040510
3	Inheritance (c INHERITING FROM c_ref)	CL_SMIGR_DDL_DB4	DDL for Homogeneous and Non-Homogeneous DB Migration	20040429
4	Inheritance (c INHERITING FROM c_ref)	CL_SMIGR_DDL_DB6	DDL for Homogeneous and Non-Homogeneous DB Migration	20040429
5	Inheritance (c INHERITING FROM c_ref)	CL_SMIGR_DDL_HDB	DDL for Homogeneous and Non-Homogeneous DB Migration	20110104
6	Inheritance (c INHERITING FROM c_ref)	CL_SMIGR_DDL_INF	DDL for Homogeneous and Non-Homogeneous DB Migr. to Informix	20040429
7	Inheritance (c INHERITING FROM c_ref)	CL_SMIGR_DDL_MSQ	DDL for Homogeneous and Non-Homogeneous DB Migration	20040429
8	Inheritance (c INHERITING FROM c_ref)	CL_SMIGR_DDL_ORA	DDL for Homogeneous and Non-Homogeneous DB Migr. to Informix	20040513
9	Inheritance (c INHERITING FROM c_ref)	CL_SMIGR_DDL_SYB	DDL for Homogeneous and Non-Homogeneous DB Migration to SYB	20100906

Properties

Class	CL_SMIGR_DDL
Short Description	DDL for Homogeneous and Non-Homogeneous DB Migration
Super Class
Instantiability of a Class	2	Public
Final	☐

General Data

Message Class
Program status
Category	0
Package	SMIGR	Homogeneous and Non-Homogeneous DB System Migration
Created	20040429	SAP
Last change	20130531	SAP
Shared Memory-enabled	☐
Fixed point arithmetic	☑
Unicode checks active	☑

Forward declarations

#	Type group / Object type	Type	Type Description
1	MGR	Type group use (TYPE-POOLS tp)	Type group use (TYPE-POOLS tp)

Interfaces

Class CL_SMIGR_DDL has no interface implemented.

Friends

Class CL_SMIGR_DDL has no friend class.

Attributes

#	Attribute	Level	Visibility	Read only	Typing	Associated Type	Initial Value	Description	Created on
1	P_C_MAX_STMT_LENGTH	Constant	Private	☐	Type reference (TYPE)	I	64	Maximum length of an SQL statement	20120216
2	P_DEST_DBSYS	Instance attribute	Protected	☐	Attribute reference (LIKE)	SY-DBSYS		R/3 System, Name of Central Database System	20040512
3	P_INFO	Instance attribute	Protected	☐	Type reference (TYPE)	STRING		Extra Information Field; Any Purpose (e.g. DB Version)	20040429
4	P_IS_UNICODE	Instance attribute	Protected	☐	Type reference (TYPE)	CHAR1		Single-Character Flag	20040511
5	P_PATH	Instance attribute	Protected	☐	Type reference (TYPE)	STRING		Directory Path to Generated SQL Files	20040429
6	P_R_CX_ROOT	Instance attribute	Protected	☐	Object reference (TYPE REF TO)	CX_ROOT		Abstract Superclass for All Global Exceptions	20040506
7	P_R_DDST_BW	Instance attribute	Protected	☐	Object reference (TYPE REF TO)	IF_SMIGR_DDL		Homogeneous and Non-Homogeneous DB System Migration	20040506
8	P_S_DDL	Instance attribute	Protected	☐	Type reference (TYPE)	MGR_S_DDL		Internal Structure for DDL Statements	20040429
9	P_TABART	Instance attribute	Protected	☐	Type reference (TYPE)	TABART		Restriction on Table Type	20040510
10	P_TABNAME	Instance attribute	Protected	☐	Type reference (TYPE)	TABNAME		Table Name	20040510

Methods

#	Method	Level	Visibility	Method type	Description	Created on
1	CHECK_STMT_SIZE	Instance method	Private	Method	Check the length	20120216
2	CONSTRUCTOR	Instance method	Public	Constructor		20040429
3	GET_DDL_ADA	Instance method	Protected	Method	Get DDL for Max DB as Source Platform	20040511
4	GET_DDL_DB2	Instance method	Protected	Method	Get DDL for DB2 as Source Platform	20040429
5	GET_DDL_DB4	Instance method	Protected	Method	Get DDL for DB4 as Source Platform	20040429
6	GET_DDL_DB6	Instance method	Protected	Method	Get DDL for DB6 as Source Platform	20040429
7	GET_DDL_HDB	Instance method	Protected	Method	Get DDL for IMCE as Source Platform	20110104
8	GET_DDL_INF	Instance method	Protected	Method	Get DDL for INFORMIX as Source Platform	20040429
9	GET_DDL_MSQ	Instance method	Protected	Method	Get DDL for MS SQL as Source Platform	20040429
10	GET_DDL_ORA	Instance method	Protected	Method	Get DDL for Oracle as Source Platform	20040429
11	GET_DDL_SYB	Instance method	Protected	Method	Get DDL for SYB as Source Platform	20100906
12	WRITE_DDL_TO_FILE	Instance method	Public	Method	Write DDL to R3LOAD SQL File (p_path/.SQL)	20040429
13	WRITE_DDL_TO_TABLE	Instance method	Public	Method	Write DDL to Database Table MIGRDDL	20040429

Events

Class CL_SMIGR_DDL has no event.

Types

Class CL_SMIGR_DDL has no local type.

Method Signatures

Method CHECK_STMT_SIZE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_T_STMT	Call by reference	☐	Type reference (TYPE)	STANDARD TABLE			20120216
2	Returning	STMT_LENGTH	Value transfer	☐	Type reference (TYPE)	I			20120216

Method CHECK_STMT_SIZE on class CL_SMIGR_DDL has no exception.

Method CONSTRUCTOR Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_DEST_DBSYS	Call by reference	☐	Type reference (TYPE)	SY-DBSYS		R/3-System, Name des zentralen Datenbanksystems	20040429
2	Importing	I_INFO	Call by reference	☑	Type reference (TYPE)	STRING			20040429
3	Importing	I_IS_UNICODE	Call by reference	☐	Type reference (TYPE)	CHAR1		Unicode Flag	20040511
4	Importing	I_PATH	Call by reference	☐	Type reference (TYPE)	CHAR512		Character 512	20040429
5	Importing	I_TABART	Call by reference	☑	Type reference (TYPE)	TABART		Datenart in Technischen Einstellungen	20040510
6	Importing	I_TABNAME	Call by reference	☑	Type reference (TYPE)	TABNAME		Tabellenname	20040510

Method CONSTRUCTOR on class CL_SMIGR_DDL has no exception.

Method GET_DDL_ADA Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	E_T_DDL	Call by reference	☐	Type reference (TYPE)	MGR_T_DDL			20040511
2	Importing	I_INFO	Call by reference	☑	Type reference (TYPE)	STRING			20040511
3	Importing	I_TABART	Call by reference	☐	Type reference (TYPE)	TABART		Tabellenart	20040511
4	Importing	I_TBLNM	Call by reference	☐	Type reference (TYPE)	TABNAME		Tabellenname	20040511

#	Exception	Resumable	Description	Created on
1	CX_SMIGR_PROGRAM_ERROR	☐	Programm Fehler: Generieren von DDL für die Migration	20040511

Method GET_DDL_DB2 Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	E_T_DDL	Call by reference	☐	Type reference (TYPE)	MGR_T_DDL			20040429
2	Importing	I_INFO	Call by reference	☑	Type reference (TYPE)	STRING			20040429
3	Importing	I_TABART	Call by reference	☐	Type reference (TYPE)	TABART		Tabellenart	20040505
4	Importing	I_TBLNM	Call by reference	☐	Type reference (TYPE)	TABNAME		Tabellenname	20040429

#	Exception	Resumable	Description	Created on
1	CX_SMIGR_PROGRAM_ERROR	☐	Programm Fehler: Generieren von DDL für die Migration	20040510

Method GET_DDL_DB4 Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	E_T_DDL	Call by reference	☐	Type reference (TYPE)	MGR_T_DDL			20040429
2	Importing	I_INFO	Call by reference	☑	Type reference (TYPE)	STRING			20040429
3	Importing	I_TABART	Call by reference	☐	Type reference (TYPE)	TABART		Tabellenart	20040505
4	Importing	I_TBLNM	Call by reference	☐	Type reference (TYPE)	TABNAME		Tabellenname	20040429

#	Exception	Resumable	Description	Created on
1	CX_SMIGR_PROGRAM_ERROR	☐	Programm Fehler: Generieren von DDL für die Migration	20040510

Method GET_DDL_DB6 Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	E_T_DDL	Call by reference	☐	Type reference (TYPE)	MGR_T_DDL			20040429
2	Importing	I_INFO	Call by reference	☑	Type reference (TYPE)	STRING			20040429
3	Importing	I_TABART	Call by reference	☐	Type reference (TYPE)	TABART		Tabellenart	20040505
4	Importing	I_TBLNM	Call by reference	☐	Type reference (TYPE)	TABNAME		Tabellenname	20040429

#	Exception	Resumable	Description	Created on
1	CX_SMIGR_PROGRAM_ERROR	☐	Programm Fehler: Generieren von DDL für die Migration	20040510

Method GET_DDL_HDB Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	E_T_DDL	Call by reference	☐	Type reference (TYPE)	MGR_T_DDL			20110104
2	Importing	I_INFO	Call by reference	☑	Type reference (TYPE)	STRING			20110104
3	Importing	I_TABART	Call by reference	☐	Type reference (TYPE)	TABART		Tabellenart	20110104
4	Importing	I_TBLNM	Call by reference	☐	Type reference (TYPE)	TABNAME		Tabellenname	20110104

#	Exception	Resumable	Description	Created on
1	CX_SMIGR_PROGRAM_ERROR	☐	Programm Fehler: Generieren von DDL für die Migration	20110104

Method GET_DDL_INF Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	E_T_DDL	Call by reference	☐	Type reference (TYPE)	MGR_T_DDL			20040429
2	Importing	I_INFO	Call by reference	☑	Type reference (TYPE)	STRING			20040429
3	Importing	I_TABART	Call by reference	☐	Type reference (TYPE)	TABART		Tabellenart	20040505
4	Importing	I_TBLNM	Call by reference	☐	Type reference (TYPE)	TABNAME		Tabellenname	20040429

#	Exception	Resumable	Description	Created on
1	CX_SMIGR_PROGRAM_ERROR	☐	Programm Fehler: Generieren von DDL für die Migration	20040510

Method GET_DDL_MSQ Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	E_T_DDL	Call by reference	☐	Type reference (TYPE)	MGR_T_DDL			20040429
2	Importing	I_INFO	Call by reference	☑	Type reference (TYPE)	STRING			20040429
3	Importing	I_TABART	Call by reference	☐	Type reference (TYPE)	TABART		Tabellenart	20040505
4	Importing	I_TBLNM	Call by reference	☐	Type reference (TYPE)	TABNAME		Tabellenname	20040429

#	Exception	Resumable	Description	Created on
1	CX_SMIGR_PROGRAM_ERROR	☐	Programm Fehler: Generieren von DDL für die Migration	20040510

Method GET_DDL_ORA Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	E_T_DDL	Call by reference	☐	Type reference (TYPE)	MGR_T_DDL			20040429
2	Importing	I_INFO	Call by reference	☑	Type reference (TYPE)	STRING			20040429
3	Importing	I_TABART	Call by reference	☐	Type reference (TYPE)	TABART		Tabellenart	20040505
4	Importing	I_TBLNM	Call by reference	☐	Type reference (TYPE)	TABNAME		Tabellenname	20040429

#	Exception	Resumable	Description	Created on
1	CX_SMIGR_PROGRAM_ERROR	☐	Programm Fehler: Generieren von DDL für die Migration	20040510

Method GET_DDL_SYB Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	E_T_DDL	Call by reference	☐	Type reference (TYPE)	MGR_T_DDL			20100906
2	Importing	I_INFO	Call by reference	☑	Type reference (TYPE)	STRING			20100906
3	Importing	I_TABART	Call by reference	☐	Type reference (TYPE)	TABART		Tabellenart	20100906
4	Importing	I_TBLNM	Call by reference	☐	Type reference (TYPE)	TABNAME		Tabellenname	20100906

#	Exception	Resumable	Description	Created on
1	CX_SMIGR_PROGRAM_ERROR	☐	Programm Fehler: Generieren von DDL für die Migration	20100906

Method WRITE_DDL_TO_FILE Signature

Method WRITE_DDL_TO_FILE on class CL_SMIGR_DDL has no parameter.

#	Exception	Resumable	Description	Created on
1	CX_SMIGR_PROGRAM_ERROR	☐	Programm Fehler: Generieren von DDL für die Migration	20040517

Method WRITE_DDL_TO_TABLE Signature

Method WRITE_DDL_TO_TABLE on class CL_SMIGR_DDL has no parameter.

#	Exception	Resumable	Description	Created on
1	CX_SMIGR_PROGRAM_ERROR	☐	Programm Fehler: Generieren von DDL für die Migration	20040517

History

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