SAP ABAP Class CL_DB2_TABLE_INFO (class with table information)

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-DB-DB2 (Application Component) DB2 for z/OS
     ⤷ STU3 (Package) Development Class for Database Monitor

Properties

Class	CL_DB2_TABLE_INFO
Short Description	class with table information
Super Class
Instantiability of a Class	2	Public
Final	☑

General Data

Message Class
Program status
Category	0
Package	STU3	Development Class for Database Monitor
Created	20090615	SAP
Last change	20130531	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_TABLE_INFO has no interface implemented.

Friends

Class CL_DB2_TABLE_INFO has no friend class.

Attributes

#	Attribute	Level	Visibility	Read only	Typing	Associated Type	Initial Value	Description	Created on
1	BASE	Instance attribute	Public	☐	Type reference (TYPE)	DB2BASETAB		structure with base and aux table	20120522
2	DB2RELEASE	Static Attribute	Private	☐	Type reference (TYPE)	DB2RELEASE		DB2 Version / Release	20091021
3	DETAILS	Instance attribute	Public	☐	Type reference (TYPE)	DB2_DB02_TAB_TS_DETAILS		datails	20091021
4	GENERAL_DATA	Instance attribute	Public	☐	Type reference (TYPE)	DB2_DB02_TAB_GEN		general data	20091021
5	HISTORY	Instance attribute	Public	☐	Type reference (TYPE)	DB_T_TABHIST		history	20091021
6	INDEXES	Instance attribute	Public	☐	Type reference (TYPE)	DB2TABIXS_TAB		indexes	20091021
7	LAST_RUN_DATE	Instance attribute	Private	☐	Type reference (TYPE)	DB2DATE		last collection run (date)	20120711
8	LAST_RUN_TIME	Instance attribute	Private	☐	Type reference (TYPE)	DB2TIME		last collection run (time)	20120711
9	LOBS	Instance attribute	Public	☐	Type reference (TYPE)	DB2_T_LOBS		lobs	20091021
10	PARTITIONS	Instance attribute	Public	☐	Type reference (TYPE)	DB2TBPARTLIST		partitions	20091021
11	PARTITION_DETAILS	Instance attribute	Public	☐	Type reference (TYPE)	DB2_DB02_TAB_PART_DETAILS		partition details	20091021
12	REMOTE_DBCON	Instance attribute	Private	☐	Type reference (TYPE)	DBCON-CON_NAME		remote_dbcon	20091021
13	STRUCTURE	Instance attribute	Public	☐	Type reference (TYPE)	DB2_T_TABSTRUC		structure	20091021
14	TABLE_CREATOR	Instance attribute	Private	☐	Type reference (TYPE)	DB2CREATORL		Table Creator	20091021
15	TABLE_NAME	Instance attribute	Private	☐	Type reference (TYPE)	DB2TABNAML		table name	20091021
16	TS_INFO	Instance attribute	Private	☐	Object reference (TYPE REF TO)	CL_DB2_TABLESPACE_INFO		tablespace	20091021

Methods

#	Method	Level	Visibility	Method type	Description	Created on
1	CONSTRUCTOR	Instance method	Public	Constructor	constructor	20091021
2	GET_BASE	Instance method	Public	Method	get LOBs Information	20120522
3	GET_DB_VERSION	Instance method	Private	Method	get DB Version / Release	20091021
4	GET_DETAILS	Instance method	Public	Method	get detail information	20091021
5	GET_GENERAL_DATA	Instance method	Public	Method	get general data	20091021
6	GET_HISTORY	Instance method	Public	Method	get history information	20091021
7	GET_INDEXES	Instance method	Public	Method	get index information	20091021
8	GET_LAST_RUN	Instance method	Public	Method	get date / time of last collection run	20120711
9	GET_LOBS	Instance method	Public	Method	get LOBs Information	20091021
10	GET_PARTITIONS	Instance method	Public	Method	get partitions information	20091021
11	GET_PARTITION_DETAILS	Instance method	Public	Method	get partition detail information	20091021
12	GET_STRUCTURE	Instance method	Public	Method	get structure information	20091021
13	GET_TABLESPACE_REF	Instance method	Public	Method	get tablespace reference	20091021

Events

Class CL_DB2_TABLE_INFO has no event.

Types

Class CL_DB2_TABLE_INFO has no local type.

Method Signatures

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		Logical name for a database connection	20091021
2	Importing	TABLE_CREATOR	Call by reference	☐	Type reference (TYPE)	DB2CREATORL		DB2 creator name	20091021
3	Importing	TABLE_NAME	Call by reference	☐	Type reference (TYPE)	DB2TABNAML		DB2 long table name	20091021

#	Exception	Resumable	Description	Created on
1	ADBC_SQL_ERROR	☐		20091021
2	CX_DB2_ROOT	☐		20091021

Method GET_BASE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	SQLERR_REF	Call by reference	☐	Object reference (TYPE REF TO)	CX_SQL_EXCEPTION		Exception Class for SQL Error	20120522

#	Exception	Resumable	Description	Created on
1	ADBC_SQL_ERROR	☐		20120522
2	INTERNAL_ERROR	☐		20120522

Method GET_DB_VERSION Signature

Method GET_DB_VERSION on class CL_DB2_TABLE_INFO has no parameter.

#	Exception	Resumable	Description	Created on
1	ADBC_SQL_ERROR	☐		20091021
2	INTERNAL_ERROR	☐		20091021

Method GET_DETAILS Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	SQLERR_REF	Call by reference	☐	Object reference (TYPE REF TO)	CX_SQL_EXCEPTION		Exception Class for SQL Error	20091021

#	Exception	Resumable	Description	Created on
1	ADBC_SQL_ERROR	☐		20091021
2	INTERNAL_ERROR	☐		20091021

Method GET_GENERAL_DATA Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	SQLERR_REF	Call by reference	☐	Object reference (TYPE REF TO)	CX_SQL_EXCEPTION		Exception Class for SQL Error	20091021

#	Exception	Resumable	Description	Created on
1	ADBC_SQL_ERROR	☐		20091021
2	INTERNAL_ERROR	☐		20091021

Method GET_HISTORY Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	EXPANDED	Call by reference	☐	Type reference (TYPE)	ABAP_BOOL	ABAP_FALSE		20091103
2	Importing	FROM_DATE	Call by reference	☐	Type reference (TYPE)	DB2DATE		Field type date, YYYYMMDD	20091021
3	Importing	RANGE	Call by reference	☐	Type reference (TYPE)	DB2HIST_RANGE		Range for History ( daily, weekly, monthly )	20091021
4	Exporting	SQLERR_REF	Call by reference	☐	Object reference (TYPE REF TO)	CX_SQL_EXCEPTION		Exception Class for SQL Error	20091021
5	Importing	TO_DATE	Call by reference	☐	Type reference (TYPE)	DB2DATE		Field type date, YYYYMMDD	20091021

#	Exception	Resumable	Description	Created on
1	ADBC_SQL_ERROR	☐		20091021
2	INTERNAL_ERROR	☐		20091021

Method GET_INDEXES Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	SQLERR_REF	Call by reference	☐	Object reference (TYPE REF TO)	CX_SQL_EXCEPTION		Exception Class for SQL Error	20091021

#	Exception	Resumable	Description	Created on
1	ADBC_SQL_ERROR	☐		20091021
2	INTERNAL_ERROR	☐		20091021

Method GET_LAST_RUN Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	LAST_DATE	Call by reference	☐	Type reference (TYPE)	DB2DATE		Field type date, YYYYMMDD	20120711
2	Exporting	LAST_TIME	Call by reference	☐	Type reference (TYPE)	DB2TIME		Field type time, HHMMSS	20120711

Method GET_LAST_RUN on class CL_DB2_TABLE_INFO has no exception.

Method GET_LOBS Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	SQLERR_REF	Call by reference	☐	Object reference (TYPE REF TO)	CX_SQL_EXCEPTION		Exception Class for SQL Error	20091021

#	Exception	Resumable	Description	Created on
1	ADBC_SQL_ERROR	☐		20091021
2	INTERNAL_ERROR	☐		20091021

Method GET_PARTITIONS Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	SQLERR_REF	Call by reference	☐	Object reference (TYPE REF TO)	CX_SQL_EXCEPTION		Exception Class for SQL Error	20091021

#	Exception	Resumable	Description	Created on
1	ADBC_SQL_ERROR	☐		20091021
2	INTERNAL_ERROR	☐		20091021

Method GET_PARTITION_DETAILS Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	PARTNO	Call by reference	☑	Type reference (TYPE)	INT2		2 byte integer (signed)	20091021
2	Exporting	SQLERR_REF	Call by reference	☐	Object reference (TYPE REF TO)	CX_SQL_EXCEPTION		Exception Class for SQL Error	20091021

#	Exception	Resumable	Description	Created on
1	ADBC_SQL_ERROR	☐		20091021
2	INTERNAL_ERROR	☐		20091021

Method GET_STRUCTURE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	SQLERR_REF	Call by reference	☐	Object reference (TYPE REF TO)	CX_SQL_EXCEPTION		Exception Class for SQL Error	20091021

#	Exception	Resumable	Description	Created on
1	ADBC_SQL_ERROR	☐		20091021
2	INTERNAL_ERROR	☐		20091021

Method GET_TABLESPACE_REF Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	TSNAME	Call by reference	☐	Type reference (TYPE)	DB2TSNAML		DB2 TS Name	20091021
2	Importing	TS_DBNAME	Call by reference	☐	Type reference (TYPE)	DB2DBNAML		DB2 creator name	20091021

Method GET_TABLESPACE_REF on class CL_DB2_TABLE_INFO has no exception.

History

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