SAP ABAP Class CL_SQL_METADATA_MSS (Method to Describe DB Objects)

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-DB-MSS (Application Component) Microsoft SQL Server
     ⤷ STUN_MSS (Package) Package for new SQL Server monitoring objects

Meta Relationship - Using

#	Relationship type	Using	Short Description	Created on
1	Inheritance (c INHERITING FROM c_ref)	CL_SQL_METADATA	Method to Describe DB Objects	20010628

Properties

Class	CL_SQL_METADATA_MSS
Short Description	Method to Describe DB Objects
Super Class	CL_SQL_METADATA	Method to Describe DB Objects
Instantiability of a Class	2	Public
Final	☑

General Data

Message Class
Program status
Category	0
Package	STUN_MSS	Package for new SQL Server monitoring objects
Created	20010628	SAP
Last change	20130531	SAP
Shared Memory-enabled	☐
Fixed point arithmetic	☑
Unicode checks active	☑

Forward declarations

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

Interfaces

Class CL_SQL_METADATA_MSS has no interface implemented.

Friends

Class CL_SQL_METADATA_MSS has no friend class.

Attributes

#	Attribute	Level	Visibility	Read only	Typing	Associated Type	Initial Value	Description	Created on
1	BUILD_VERSION	Instance attribute	Public	☑	Type reference (TYPE)	I			20020522
2	MAJOR_VERSION	Instance attribute	Public	☑	Type reference (TYPE)	I			20020522
3	MINOR_VERSION	Instance attribute	Public	☑	Type reference (TYPE)	I			20020522

Methods

#	Method	Level	Visibility	Method type	Description	Created on
1	CONSTRUCTOR	Instance method	Public	Constructor	Constructor	20020522
2	GET_COLUMNS_0708	Instance method	Public	Method		20020522
3	GET_COLUMNS_09	Instance method	Public	Method		20070627
4	GET_INDEX_INFO_0708	Instance method	Public	Method		20020522
5	GET_INDEX_INFO_09	Instance method	Public	Method		20070627
6	GET_PRIMARY_KEYS_0708	Instance method	Public	Method		20020522
7	GET_PRIMARY_KEYS_09	Instance method	Public	Method		20070627
8	GET_SCHEMAS_0708	Instance method	Public	Method		20020522
9	GET_SCHEMAS_09	Instance method	Public	Method		20070627
10	GET_TABLES_0708	Instance method	Public	Method		20020522
11	GET_TABLES_09	Instance method	Public	Method		20070627
12	GET_VERSION	Instance method	Public	Method		20020522
13	GET_VIEWTEXT_0708	Instance method	Public	Method		20020522
14	GET_VIEWTEXT_09	Instance method	Public	Method		20070628
15	MAP_DB_TO_DDIC_TYPE	Instance method	Private	Method		20020522
16	MAP_DB_TO_DDIC_TYPE_0708	Instance method	Private	Method		20020522

Events

Class CL_SQL_METADATA_MSS has no event.

Types

Class CL_SQL_METADATA_MSS 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	CON_REF	Call by reference	☑	Object reference (TYPE REF TO)	CL_SQL_CONNECTION		Database Connection	20020522

#	Exception	Resumable	Description	Created on
1	CX_SQL_EXCEPTION	☐	Ausnahmeklasse für SQL Fehler	20020522

Method GET_COLUMNS_0708 Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	COLUMN_TAB	Call by reference	☐	Type reference (TYPE)	ADBC_TABCOL_DESCR_TAB			20020522
2	Importing	SCHEMA_NAME	Call by reference	☐	Type reference (TYPE)	ADBC_NAME			20020522
3	Importing	TABLE_NAME	Call by reference	☐	Type reference (TYPE)	ADBC_NAME			20020522

#	Exception	Resumable	Description	Created on
1	CX_SQL_EXCEPTION	☐	Ausnahmeklasse für SQL Fehler	20020522

Method GET_COLUMNS_09 Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	COLUMN_TAB	Call by reference	☐	Type reference (TYPE)	ADBC_TABCOL_DESCR_TAB			20070627
2	Importing	SCHEMA_NAME	Call by reference	☐	Type reference (TYPE)	ADBC_NAME			20070627
3	Importing	TABLE_NAME	Call by reference	☐	Type reference (TYPE)	ADBC_NAME			20070627

#	Exception	Resumable	Description	Created on
1	CX_SQL_EXCEPTION	☐	Ausnahmeklasse für SQL Fehler	20070627

Method GET_INDEX_INFO_0708 Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	INDEX_INFO_TAB	Call by reference	☐	Type reference (TYPE)	ADBC_INDEX_DESCR_TAB			20020522
2	Importing	INDEX_NAME	Call by reference	☑	Type reference (TYPE)	ADBC_NAME			20020522
3	Importing	SCHEMA_NAME	Call by reference	☐	Type reference (TYPE)	ADBC_NAME			20020522
4	Importing	TABLE_NAME	Call by reference	☐	Type reference (TYPE)	ADBC_NAME			20020522

#	Exception	Resumable	Description	Created on
1	CX_SQL_EXCEPTION	☐	Ausnahmeklasse für SQL Fehler	20020522

Method GET_INDEX_INFO_09 Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	INDEX_INFO_TAB	Call by reference	☐	Type reference (TYPE)	ADBC_INDEX_DESCR_TAB			20070627
2	Importing	INDEX_NAME	Call by reference	☑	Type reference (TYPE)	ADBC_NAME			20070627
3	Importing	SCHEMA_NAME	Call by reference	☐	Type reference (TYPE)	ADBC_NAME			20070627
4	Importing	TABLE_NAME	Call by reference	☐	Type reference (TYPE)	ADBC_NAME			20070627

#	Exception	Resumable	Description	Created on
1	CX_SQL_EXCEPTION	☐	Ausnahmeklasse für SQL Fehler	20070627

Method GET_PRIMARY_KEYS_0708 Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	PRIMARY_KEY_NAME	Call by reference	☐	Type reference (TYPE)	ADBC_NAME		Name des Primärschlüssels	20020522
2	Exporting	PRIMARY_KEY_TAB	Call by reference	☐	Type reference (TYPE)	ADBC_COLUMN_TAB		Tabelle mit Sclüsselfeldern	20020522
3	Importing	SCHEMA_NAME	Call by reference	☐	Type reference (TYPE)	ADBC_NAME		Datenbankschema	20020522
4	Importing	TABLE_NAME	Call by reference	☐	Type reference (TYPE)	ADBC_NAME		Tabellenname	20020522

#	Exception	Resumable	Description	Created on
1	CX_SQL_EXCEPTION	☐	Ausnahmeklasse für SQL Fehler	20020522

Method GET_PRIMARY_KEYS_09 Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	PRIMARY_KEY_NAME	Call by reference	☐	Type reference (TYPE)	ADBC_NAME			20070627
2	Exporting	PRIMARY_KEY_TAB	Call by reference	☐	Type reference (TYPE)	ADBC_COLUMN_TAB			20070627
3	Importing	SCHEMA_NAME	Call by reference	☐	Type reference (TYPE)	ADBC_NAME			20070627
4	Importing	TABLE_NAME	Call by reference	☐	Type reference (TYPE)	ADBC_NAME			20070627

#	Exception	Resumable	Description	Created on
1	CX_SQL_EXCEPTION	☐	Ausnahmeklasse für SQL Fehler	20070627

Method GET_SCHEMAS_0708 Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	SCHEMA_RGTAB	Call by reference	☑	Type reference (TYPE)	ADBC_NAME_RGTAB			20020522
2	Exporting	SCHEMA_TAB	Call by reference	☐	Type reference (TYPE)	ADBC_SCHEMA_TAB			20020522

#	Exception	Resumable	Description	Created on
1	CX_SQL_EXCEPTION	☐	Ausnahmeklasse für SQL Fehler	20020522

Method GET_SCHEMAS_09 Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	SCHEMA_RGTAB	Call by reference	☑	Type reference (TYPE)	ADBC_NAME_RGTAB			20070627
2	Exporting	SCHEMA_TAB	Call by reference	☐	Type reference (TYPE)	ADBC_SCHEMA_TAB			20070627

#	Exception	Resumable	Description	Created on
1	CX_SQL_EXCEPTION	☐	Ausnahmeklasse für SQL Fehler	20070627

Method GET_TABLES_0708 Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	SCHEMA_RGTAB	Call by reference	☑	Type reference (TYPE)	ADBC_NAME_RGTAB		Database Schema	20020522
2	Exporting	TABLE_DESCR_TAB	Call by reference	☐	Type reference (TYPE)	ADBC_TABLE_DESCR_TAB		Internal Table with Selected Tables	20020522
3	Importing	TABLE_RGTAB	Call by reference	☑	Type reference (TYPE)	ADBC_NAME_RGTAB		Range Table To Delimit Tables	20020522
4	Importing	TABLE_TYPES	Call by reference	☑	Type reference (TYPE)	STRING		List of Table Types	20020522

#	Exception	Resumable	Description	Created on
1	CX_SQL_EXCEPTION	☐	Ausnahmeklasse für SQL Fehler	20020522

Method GET_TABLES_09 Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	SCHEMA_RGTAB	Call by reference	☑	Type reference (TYPE)	ADBC_NAME_RGTAB			20070627
2	Exporting	TABLE_DESCR_TAB	Call by reference	☐	Type reference (TYPE)	ADBC_TABLE_DESCR_TAB			20070627
3	Importing	TABLE_RGTAB	Call by reference	☑	Type reference (TYPE)	ADBC_NAME_RGTAB			20070627
4	Importing	TABLE_TYPES	Call by reference	☑	Type reference (TYPE)	STRING			20070627

#	Exception	Resumable	Description	Created on
1	CX_SQL_EXCEPTION	☐	Ausnahmeklasse für SQL Fehler	20070627

Method GET_VERSION Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	BUILD	Call by reference	☐	Type reference (TYPE)	I			20020522
2	Exporting	MAJOR	Call by reference	☐	Type reference (TYPE)	I			20020522
3	Exporting	MINOR	Call by reference	☐	Type reference (TYPE)	I			20020522

#	Exception	Resumable	Description	Created on
1	CX_SQL_EXCEPTION	☐	Ausnahmeklasse für SQL Fehler	20020522

Method GET_VIEWTEXT_0708 Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	SCHEMA_NAME	Call by reference	☐	Type reference (TYPE)	ADBC_NAME			20020522
2	Returning	TEXT	Value transfer	☐	Type reference (TYPE)	STRING			20020522
3	Importing	VIEW_NAME	Call by reference	☐	Type reference (TYPE)	ADBC_NAME			20020522

#	Exception	Resumable	Description	Created on
1	CX_SQL_EXCEPTION	☐	Ausnahmeklasse für SQL Fehler	20020522

Method GET_VIEWTEXT_09 Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	SCHEMA_NAME	Call by reference	☐	Type reference (TYPE)	ADBC_NAME			20070628
2	Returning	TEXT	Value transfer	☐	Type reference (TYPE)	STRING			20070628
3	Importing	VIEW_NAME	Call by reference	☐	Type reference (TYPE)	ADBC_NAME			20070628

#	Exception	Resumable	Description	Created on
1	CX_SQL_EXCEPTION	☐	Ausnahmeklasse für SQL Fehler	20070628

Method MAP_DB_TO_DDIC_TYPE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Changing	COLUMN_DESCR	Call by reference	☐	Type reference (TYPE)	ADBC_TABCOL_DESCR			20020522

#	Exception	Resumable	Description	Created on
1	CX_SQL_EXCEPTION	☐	Ausnahmeklasse für SQL Fehler	20020522

Method MAP_DB_TO_DDIC_TYPE_0708 Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Changing	COLUMN_DESCR	Call by reference	☐	Type reference (TYPE)	ADBC_TABCOL_DESCR			20020522

#	Exception	Resumable	Description	Created on
1	CX_SQL_EXCEPTION	☐	Ausnahmeklasse für SQL Fehler	20020522

History

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