SAP ABAP Class CL_DB6_SQL_GENERATOR (DB6: Generator for SQL Commands)

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-DB-DB6 (Application Component) DB2 Universal Database for UNIX / NT
     ⤷ STU6 (Package) DB6: Performance-Monitor (UNIX/Windows)

Properties

Class	CL_DB6_SQL_GENERATOR
Short Description	DB6: Generator for SQL Commands
Super Class
Instantiability of a Class	0	Private
Final	☐

General Data

Message Class
Program status
Category	0
Package	STU6	DB6: Performance-Monitor (UNIX/Windows)
Created	20080626	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)
2	DB6CC	Type group use (TYPE-POOLS tp)	Type group use (TYPE-POOLS tp)

Interfaces

Class CL_DB6_SQL_GENERATOR has no interface implemented.

Friends

Class CL_DB6_SQL_GENERATOR has no friend class.

Attributes

#	Attribute	Level	Visibility	Read only	Typing	Associated Type	Initial Value	Description	Created on
1	CO_VALUETYPE_GB	Constant	Public	☐	Type reference (TYPE)	STRING	'GB'		20090528
2	CO_VALUETYPE_KB	Constant	Public	☐	Type reference (TYPE)	STRING	'KB'		20090528
3	CO_VALUETYPE_MB	Constant	Public	☐	Type reference (TYPE)	STRING	'MB'		20090528
4	CO_VALUETYPE_PERCENT	Constant	Public	☐	Type reference (TYPE)	STRING	'%'		20090528
5	KEYWORD	Instance attribute	Private	☐	Type reference (TYPE)	DB6_KEYWORD		DB6: Keyword (DB2 UDB release dependend naming conventions)	20080626
6	SYS_REF	Instance attribute	Private	☐	Object reference (TYPE REF TO)	CL_DB6_SYS		DB6: Remote System Administration	20080626

Methods

#	Method	Level	Visibility	Method type	Description	Created on
1	ALTER_DATABASE	Instance method	Public	Method		20111228
2	ALTER_STOGROUP	Instance method	Public	Method		20111205
3	ALTER_TABLESPACE	Instance method	Public	Method		20120102
4	BUILD_ALL_CLAUSE	Instance method	Private	Method	build ALL clause	20080626
5	BUILD_AUTORESIZE	Instance method	Private	Method	add autoresize option	20080626
6	BUILD_BUFFERPOOL	Instance method	Private	Method	build bufferpool clause	20080626
7	BUILD_CONTAINER_STRING	Instance method	Private	Method	build container string for ALTER/CREATE	20080626
8	BUILD_DROPPED	Instance method	Private	Method	build dropped option	20080626
9	BUILD_EXTENTSIZE	Instance method	Private	Method	add extentsize option	20080626
10	BUILD_FS_CACHING	Instance method	Private	Method		20091116
11	BUILD_GRANT	Instance method	Private	Method	build grant option	20080626
12	BUILD_INCREASESIZE	Instance method	Private	Method	add increasesize option	20080626
13	BUILD_INITIALSIZE	Instance method	Private	Method	add initialsize option	20080626
14	BUILD_MAXSIZE	Instance method	Private	Method	add maxsize option	20080626
15	BUILD_OVERHEAD	Instance method	Private	Method	add overhead option	20080626
16	BUILD_PART_CLAUSE	Instance method	Private	Method	build partitions clause	20080626
17	BUILD_PREFETCHSIZE	Instance method	Private	Method	add prefetchsize option	20080626
18	BUILD_STOGROUP_DATA_TAG	Instance method	Private	Method		20111228
19	BUILD_STOGROUP_DEVICE_READ_RAT	Instance method	Private	Method		20111228
20	BUILD_STOGROUP_IS_DEFAULT	Instance method	Private	Method		20111228
21	BUILD_STOGROUP_OVERHEAD	Instance method	Private	Method		20111228
22	BUILD_STOGROUP_PATH_LIST	Instance method	Private	Method		20111228
23	BUILD_TRANSFERRATE	Instance method	Private	Method	build transferrate clause	20080626
24	CHECK_FOR_ALL_CLAUSE	Instance method	Private	Method	check for ALL clause (only resized containers)	20120102
25	CONSTRUCTOR	Instance method	Public	Constructor	CONSTRUCTOR	20080626
26	CREATE_STOGROUP	Instance method	Public	Method		20111205
27	CREATE_TABLESPACE	Instance method	Public	Method		20080626
28	DROP_STOGROUP	Instance method	Public	Method		20111208
29	DROP_TABLESPACE	Instance method	Public	Method		20090319
30	GET_GENERATOR_REF	Static method	Public	Method		20080626
31	REBALANCE_TABLESPACE	Instance method	Public	Method		20090520
32	REDUCE_TABLESPACE_HWM	Instance method	Public	Method		20090528
33	STOP_REDUCE_TABLESPACE	Instance method	Public	Method		20090528

Events

Class CL_DB6_SQL_GENERATOR has no event.

Types

Class CL_DB6_SQL_GENERATOR has no local type.

Method Signatures

Method ALTER_DATABASE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	ADD_PATH_LIST	Call by reference	☐	Type reference (TYPE)	DB6_STRING_TAB		DB6: Table of DB6_EDITOR_LINE	20111228
2	Importing	DROP_PATH_LIST	Call by reference	☐	Type reference (TYPE)	DB6_STRING_TAB		DBA: Simple List of Strings	20111228
3	Returning	SQL_STATEMENT_TAB	Value transfer	☐	Type reference (TYPE)	DB6_EDITOR_LIST		DB6: Table of DB6_EDITOR_LINE	20111228

Method ALTER_DATABASE on class CL_DB6_SQL_GENERATOR has no exception.

Method ALTER_STOGROUP Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	ADD_PATH_LIST	Call by reference	☐	Type reference (TYPE)	DB6_STRING_TAB		DBA: Simple List of Strings	20111205
2	Importing	DATA_TAG	Call by reference	☐	Type reference (TYPE)	I			20111205
3	Importing	DEVICE_READ_RATE	Call by reference	☐	Type reference (TYPE)	P			20111205
4	Importing	DROP_PATH_LIST	Call by reference	☐	Type reference (TYPE)	DB6_STRING_TAB		DBA: Simple List of Strings	20111205
5	Importing	IS_DEFAULT	Call by reference	☐	Type reference (TYPE)	ABAP_BOOL			20111205
6	Importing	OVERHEAD	Call by reference	☐	Type reference (TYPE)	P			20111205
7	Importing	SGNAME	Call by reference	☐	Type reference (TYPE)	STRING			20111205
8	Returning	SQL_STATEMENT_TAB	Value transfer	☐	Type reference (TYPE)	DB6_EDITOR_LIST		DB6: Table of DB6_EDITOR_LINE	20111205

Method ALTER_STOGROUP on class CL_DB6_SQL_GENERATOR has no exception.

Method ALTER_TABLESPACE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	AUTORESIZ	Call by reference	☐	Type reference (TYPE)	DB6PMCTBS-AUTORESIZ			20120102
2	Importing	BUFFERPOOL	Call by reference	☐	Type reference (TYPE)	DB6CATTSP-BUFFERPOOL		DB6: General identifier	20120102
3	Importing	CUR_CONTAINERS	Call by reference	☐	Type reference (TYPE)	DB6ADMCTR_LIST		DB6: List of Containers	20120102
4	Importing	CUR_TSP	Call by reference	☐	Type reference (TYPE)	DB6PMCTBS		DB6: Tablespace Configuration Data (Calculated)	20120102
5	Importing	CUR_TSP_CAT	Call by reference	☐	Type reference (TYPE)	DB6CATTSP		DB6: System Catalog Information of Tablespaces	20120102
6	Importing	DROPPED_TABLE_ON	Call by reference	☐	Type reference (TYPE)	DB6CATTSP-DROPRECOV		Dropped table recovery: on ='X',off= ' '	20120102
7	Importing	ENABLE_AUTOSTORAGE	Call by reference	☐	Type reference (TYPE)	ABAP_BOOL			20120102
8	Importing	FS_CACHING	Call by reference	☐	Type reference (TYPE)	ABAP_BOOL			20120102
9	Importing	INCRSIZABS	Call by reference	☐	Type reference (TYPE)	DB6PMCTBS-INCRSIZABS			20120102
10	Importing	INCRSIZPCT	Call by reference	☐	Type reference (TYPE)	DB6PMCTBS-INCRSIZPCT			20120102
11	Importing	MAX_SIZE	Call by reference	☐	Type reference (TYPE)	DB6PMCTBS-MAX_SIZE			20120102
12	Importing	ORI_CONTAINERS	Call by reference	☐	Type reference (TYPE)	DB6ADMCTR_LIST		DB6: List of Containers	20120102
13	Importing	ORI_TSP	Call by reference	☐	Type reference (TYPE)	DB6PMCTBS		DB6: Tablespace Configuration Data (Calculated)	20120102
14	Importing	ORI_TSP_CAT	Call by reference	☐	Type reference (TYPE)	DB6CATTSP		DB6: System Catalog Information of Tablespaces	20120102
15	Importing	OVERHEAD	Call by reference	☐	Type reference (TYPE)	DB6CATTSP-OVERHEAD		Aufwand der Steuereinheit, Plattensuche und Latenzzeit in ms	20120102
16	Importing	PREFETCHSIZE	Call by reference	☐	Type reference (TYPE)	CLIKE			20120102
17	Returning	SQL_STATEMENT_TAB	Value transfer	☐	Type reference (TYPE)	DB6_EDITOR_LIST		DB6: Table of DB6_EDITOR_LINE	20120102
18	Importing	STORAGE_GROUP_NAME	Call by reference	☐	Type reference (TYPE)	STRING		DB6: long table name	20120102
19	Importing	TBS_NAME	Call by reference	☐	Type reference (TYPE)	DB6CATTSP-TBS_NAME		DB6: Tablespace Name	20120102
20	Importing	TBS_TYPE	Call by reference	☐	Type reference (TYPE)	DB6CATTSP-TBS_TYPE		Mgmt Type (DMS, SMS)	20120102
21	Importing	TRANSFER	Call by reference	☐	Type reference (TYPE)	DB6CATTSP-TRANSFER		Zeit für das Lesen einer Seite mit Größe PAGESIZE in Puffer	20120102
22	Importing	TSP_PARTITIONS	Call by reference	☐	Type reference (TYPE)	DB6PARTLST		DB6: Partition List For Listbox	20120102

Method ALTER_TABLESPACE on class CL_DB6_SQL_GENERATOR has no exception.

Method BUILD_ALL_CLAUSE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	SIZE	Call by reference	☐	Type reference (TYPE)	P			20080626
2	Changing	TEXT	Call by reference	☐	Type reference (TYPE)	DB6CC_EDITOR_LIST			20080626

Method BUILD_ALL_CLAUSE on class CL_DB6_SQL_GENERATOR has no exception.

Method BUILD_AUTORESIZE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	AUTORESIZE	Call by reference	☐	Type reference (TYPE)	C			20080626
2	Changing	TEXT	Call by reference	☐	Type reference (TYPE)	DB6CC_EDITOR_LIST			20080626

Method BUILD_AUTORESIZE on class CL_DB6_SQL_GENERATOR has no exception.

Method BUILD_BUFFERPOOL Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	BUFFERPOOL	Call by reference	☐	Type reference (TYPE)	C			20080626
2	Changing	TEXT	Call by reference	☐	Type reference (TYPE)	DB6CC_EDITOR_LIST			20080626

Method BUILD_BUFFERPOOL on class CL_DB6_SQL_GENERATOR has no exception.

Method BUILD_CONTAINER_STRING Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	ALL_CONTAINERS	Call by reference	☐	Type reference (TYPE)	DB6ADMCTR_LIST		DB6: List of Containers	20080626
2	Importing	CONTAINER	Call by reference	☐	Type reference (TYPE)	DB6ADMCTR		DB6: container maintenance grid	20080626
3	Changing	TEXT	Call by reference	☐	Type reference (TYPE)	DB6CC_EDITOR_LIST			20080626

Method BUILD_CONTAINER_STRING on class CL_DB6_SQL_GENERATOR has no exception.

Method BUILD_DROPPED Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	DROPPED_TABLE_ON	Call by reference	☐	Type reference (TYPE)	C			20080626
2	Changing	TEXT	Call by reference	☐	Type reference (TYPE)	DB6CC_EDITOR_LIST			20080626

Method BUILD_DROPPED on class CL_DB6_SQL_GENERATOR has no exception.

Method BUILD_EXTENTSIZE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	EXTENTSIZE	Call by reference	☐	Type reference (TYPE)	P			20080626
2	Changing	TEXT	Call by reference	☐	Type reference (TYPE)	DB6CC_EDITOR_LIST			20080626

Method BUILD_EXTENTSIZE on class CL_DB6_SQL_GENERATOR has no exception.

Method BUILD_FS_CACHING Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	FS_CACHING	Call by reference	☐	Type reference (TYPE)	ABAP_BOOL			20091116
2	Changing	TEXT	Call by reference	☐	Type reference (TYPE)	DB6CC_EDITOR_LIST			20091116

Method BUILD_FS_CACHING on class CL_DB6_SQL_GENERATOR has no exception.

Method BUILD_GRANT Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	GRANT_TO	Call by reference	☐	Type reference (TYPE)	STRING	'TO PUBLIC'		20111125
2	Importing	TBS_NAME	Call by reference	☐	Type reference (TYPE)	C			20080626
3	Changing	TEXT	Call by reference	☐	Type reference (TYPE)	DB6CC_EDITOR_LIST			20080626

Method BUILD_GRANT on class CL_DB6_SQL_GENERATOR has no exception.

Method BUILD_INCREASESIZE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	INCRSIZABS	Call by reference	☐	Type reference (TYPE)	P			20080626
2	Importing	INCRSIZREL	Call by reference	☐	Type reference (TYPE)	P			20080626
3	Changing	TEXT	Call by reference	☐	Type reference (TYPE)	DB6CC_EDITOR_LIST			20080626

Method BUILD_INCREASESIZE on class CL_DB6_SQL_GENERATOR has no exception.

Method BUILD_INITIALSIZE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	INITIALSIZE	Call by reference	☐	Type reference (TYPE)	P			20080626
2	Changing	TEXT	Call by reference	☐	Type reference (TYPE)	DB6CC_EDITOR_LIST			20080626

Method BUILD_INITIALSIZE on class CL_DB6_SQL_GENERATOR has no exception.

Method BUILD_MAXSIZE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	MAXSIZE	Call by reference	☐	Type reference (TYPE)	P			20080626
2	Changing	TEXT	Call by reference	☐	Type reference (TYPE)	DB6CC_EDITOR_LIST			20080626

Method BUILD_MAXSIZE on class CL_DB6_SQL_GENERATOR has no exception.

Method BUILD_OVERHEAD Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	OVERHEAD	Call by reference	☐	Type reference (TYPE)	P			20080626
2	Changing	TEXT	Call by reference	☐	Type reference (TYPE)	DB6CC_EDITOR_LIST			20080626

Method BUILD_OVERHEAD on class CL_DB6_SQL_GENERATOR has no exception.

Method BUILD_PART_CLAUSE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	PARTITN	Call by reference	☐	Type reference (TYPE)	DB6PARTNAM		DB6: Partition Name for Listbox Element	20080626
2	Changing	TEXT	Call by reference	☐	Type reference (TYPE)	DB6CC_EDITOR_LIST			20080626

Method BUILD_PART_CLAUSE on class CL_DB6_SQL_GENERATOR has no exception.

Method BUILD_PREFETCHSIZE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	PREFETCHSIZE	Call by reference	☐	Type reference (TYPE)	CLIKE			20080626
2	Changing	TEXT	Call by reference	☐	Type reference (TYPE)	DB6CC_EDITOR_LIST			20080626

Method BUILD_PREFETCHSIZE on class CL_DB6_SQL_GENERATOR has no exception.

Method BUILD_STOGROUP_DATA_TAG Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	DATA_TAG	Call by reference	☐	Type reference (TYPE)	I			20111228
2	Changing	SQL_STATEMENT_TAB	Call by reference	☐	Type reference (TYPE)	DB6_EDITOR_LIST		DB6: Table of DB6_EDITOR_LINE	20111228

Method BUILD_STOGROUP_DATA_TAG on class CL_DB6_SQL_GENERATOR has no exception.

Method BUILD_STOGROUP_DEVICE_READ_RAT Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	DEVICE_READ_RATE	Call by reference	☐	Type reference (TYPE)	P			20111228
2	Changing	SQL_STATEMENT_TAB	Call by reference	☐	Type reference (TYPE)	DB6_EDITOR_LIST		DB6: Table of DB6_EDITOR_LINE	20111228

Method BUILD_STOGROUP_DEVICE_READ_RAT on class CL_DB6_SQL_GENERATOR has no exception.

Method BUILD_STOGROUP_IS_DEFAULT Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IS_DEFAULT	Call by reference	☐	Type reference (TYPE)	ABAP_BOOL			20111228
2	Changing	SQL_STATEMENT_TAB	Call by reference	☐	Type reference (TYPE)	DB6_EDITOR_LIST		DB6: Table of DB6_EDITOR_LINE	20111228

Method BUILD_STOGROUP_IS_DEFAULT on class CL_DB6_SQL_GENERATOR has no exception.

Method BUILD_STOGROUP_OVERHEAD Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	OVERHEAD	Call by reference	☐	Type reference (TYPE)	P			20111228
2	Changing	SQL_STATEMENT_TAB	Call by reference	☐	Type reference (TYPE)	DB6_EDITOR_LIST		DB6: Table of DB6_EDITOR_LINE	20111228

Method BUILD_STOGROUP_OVERHEAD on class CL_DB6_SQL_GENERATOR has no exception.

Method BUILD_STOGROUP_PATH_LIST Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	PATH_LIST	Call by reference	☐	Type reference (TYPE)	DB6_STRING_TAB		DBA: Simple List of Strings	20111228
2	Changing	SQL_STATEMENT_TAB	Call by reference	☐	Type reference (TYPE)	DB6_EDITOR_LIST		DB6: Table of DB6_EDITOR_LINE	20111228

Method BUILD_STOGROUP_PATH_LIST on class CL_DB6_SQL_GENERATOR has no exception.

Method BUILD_TRANSFERRATE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Changing	TEXT	Call by reference	☐	Type reference (TYPE)	DB6CC_EDITOR_LIST			20080626
2	Importing	TRANSFERRATE	Call by reference	☐	Type reference (TYPE)	P			20080626

Method BUILD_TRANSFERRATE on class CL_DB6_SQL_GENERATOR has no exception.

Method CHECK_FOR_ALL_CLAUSE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	CUR_CONTAINERS	Call by reference	☐	Type reference (TYPE)	DB6ADMCTR_LIST		DB6: List of Containers	20120102
2	Changing	EXTEND	Call by reference	☐	Type reference (TYPE)	C			20120102
3	Importing	ORI_CONTAINERS	Call by reference	☐	Type reference (TYPE)	DB6ADMCTR_LIST		DB6: List of Containers	20120102
4	Importing	PARTITN	Call by reference	☐	Type reference (TYPE)	DB6PARTNAM		DB6: Partition Name for Listbox Element	20120102
5	Changing	SIZE	Call by reference	☐	Type reference (TYPE)	P			20120102

Method CHECK_FOR_ALL_CLAUSE on class CL_DB6_SQL_GENERATOR has no exception.

Method CONSTRUCTOR Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	SYS_REF	Call by reference	☐	Object reference (TYPE REF TO)	CL_DB6_SYS		DB6: Remote System Administration	20080626

Method CONSTRUCTOR on class CL_DB6_SQL_GENERATOR has no exception.

Method CREATE_STOGROUP Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	DATA_TAG	Call by reference	☐	Type reference (TYPE)	I			20111205
2	Importing	DEVICE_READ_RATE	Call by reference	☐	Type reference (TYPE)	P			20111205
3	Importing	IS_DEFAULT	Call by reference	☐	Type reference (TYPE)	ABAP_BOOL			20111205
4	Importing	OVERHEAD	Call by reference	☐	Type reference (TYPE)	P			20111205
5	Importing	PATH_LIST	Call by reference	☐	Type reference (TYPE)	DB6_STRING_TAB		DBA: Simple List of Strings	20111205
6	Importing	SGNAME	Call by reference	☐	Type reference (TYPE)	STRING			20111205
7	Returning	SQL_STATEMENT_TAB	Value transfer	☐	Type reference (TYPE)	DB6_EDITOR_LIST		DB6: Table of DB6_EDITOR_LINE	20111205

Method CREATE_STOGROUP on class CL_DB6_SQL_GENERATOR has no exception.

Method CREATE_TABLESPACE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	AUTORESIZ	Call by reference	☐	Type reference (TYPE)	DB6PMCTBS-AUTORESIZ			20080626
2	Importing	AUTOSTOR	Call by reference	☐	Type reference (TYPE)	DB6PMCTBS-AUTOSTOR			20080626
3	Importing	BUFFERPOOL	Call by reference	☐	Type reference (TYPE)	DB6CATTSP-BUFFERPOOL		DB6: General identifier	20080626
4	Importing	CONTAINERS	Call by reference	☐	Type reference (TYPE)	DB6ADMCTR_LIST		DB6: List of Containers	20080626
5	Importing	DATA_TYPE	Call by reference	☐	Type reference (TYPE)	DB6CATTSP-DATA_TYPE		Contents (Regular,Long, Usertemp,Systemp)	20080626
6	Importing	DROPPED_TABLE_ON	Call by reference	☐	Type reference (TYPE)	DB6CATTSP-DROPRECOV		Dropped table recovery: on ='X',off= ' '	20080626
7	Importing	EXTSIZE	Call by reference	☐	Type reference (TYPE)	DB6CATTSP-EXTSIZE		Extent size in pages	20080626
8	Importing	FS_CACHING	Call by reference	☐	Type reference (TYPE)	ABAP_BOOL			20091116
9	Importing	GRANT_TO	Call by reference	☐	Type reference (TYPE)	STRING			20111125
10	Importing	INCRSIZABS	Call by reference	☐	Type reference (TYPE)	DB6PMCTBS-INCRSIZABS			20080626
11	Importing	INCRSIZPCT	Call by reference	☐	Type reference (TYPE)	DB6PMCTBS-INCRSIZPCT			20080626
12	Importing	INITSIZ	Call by reference	☐	Type reference (TYPE)	DB6PMCTBS-INITSIZ			20080626
13	Importing	MAX_SIZE	Call by reference	☐	Type reference (TYPE)	DB6PMCTBS-MAX_SIZE			20080626
14	Importing	NGNAME	Call by reference	☐	Type reference (TYPE)	DB6CATTSP-NGNAME		DB6: General identifier	20080626
15	Importing	OVERHEAD	Call by reference	☐	Type reference (TYPE)	DB6CATTSP-OVERHEAD		Controller overhead and disk seek and latency time in msec	20080626
16	Importing	PAGESIZE	Call by reference	☐	Type reference (TYPE)	I		Pagesize in KB	20080626
17	Importing	PREFETCHSIZE	Call by reference	☐	Type reference (TYPE)	CLIKE		Prefetch size in pages or AUTOMATIC	20080626
18	Returning	SQL_STATEMENT_TAB	Value transfer	☐	Type reference (TYPE)	DB6_EDITOR_LIST		DB6: Table of DB6_EDITOR_LINE	20080626
19	Importing	STORAGE_GROUP_NAME	Call by reference	☐	Type reference (TYPE)	STRING		DB6: long table name	20120102
20	Importing	TBS_NAME	Call by reference	☐	Type reference (TYPE)	DB6CATTSP-TBS_NAME		DB6: Tablespace Name	20080626
21	Importing	TBS_TYPE	Call by reference	☐	Type reference (TYPE)	DB6CATTSP-TBS_TYPE		Mgmt Type (DMS, SMS)	20080626
22	Importing	TRANSFER	Call by reference	☐	Type reference (TYPE)	DB6CATTSP-TRANSFER		Time to read one page of size PAGESIZE into the buffer	20080626
23	Importing	TSP_PARTITIONS	Call by reference	☐	Type reference (TYPE)	DB6PARTLST		DB6: Partition List For Listbox	20080626

Method CREATE_TABLESPACE on class CL_DB6_SQL_GENERATOR has no exception.

Method DROP_STOGROUP Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	RESTRICT	Call by reference	☐	Type reference (TYPE)	ABAP_BOOL	ABAP_TRUE		20111208
2	Importing	SGNAME	Call by reference	☐	Type reference (TYPE)	STRING			20111208
3	Returning	SQL_STATEMENT_TAB	Value transfer	☐	Type reference (TYPE)	DB6_EDITOR_LIST		DB6: Table of DB6_EDITOR_LINE	20111208

Method DROP_STOGROUP on class CL_DB6_SQL_GENERATOR has no exception.

Method DROP_TABLESPACE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Returning	SQL_STATEMENT_TAB	Value transfer	☐	Type reference (TYPE)	DB6_EDITOR_LIST		DB6: Table of DB6_EDITOR_LINE	20090319
2	Importing	TBS_NAME	Call by reference	☐	Type reference (TYPE)	DB6CATTSP-TBS_NAME		DB6: Tablespace Name	20090319

Method DROP_TABLESPACE on class CL_DB6_SQL_GENERATOR has no exception.

Method GET_GENERATOR_REF Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Returning	GENERATOR_REF	Value transfer	☐	Object reference (TYPE REF TO)	CL_DB6_SQL_GENERATOR		DB6: Generator for SQL Commands	20080626
2	Importing	SYS_REF	Call by reference	☐	Object reference (TYPE REF TO)	CL_DB6_SYS		DB6: Remote System Administration	20080626

Method GET_GENERATOR_REF on class CL_DB6_SQL_GENERATOR has no exception.

Method REBALANCE_TABLESPACE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Returning	SQL_STATEMENT_TAB	Value transfer	☐	Type reference (TYPE)	DB6_EDITOR_LIST		DB6: Table of DB6_EDITOR_LINE	20090520
2	Importing	TBS_NAME	Call by reference	☐	Type reference (TYPE)	DB6CATTSP-TBS_NAME		DB6: Tablespace Name	20090520

Method REBALANCE_TABLESPACE on class CL_DB6_SQL_GENERATOR has no exception.

Method REDUCE_TABLESPACE_HWM Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	BY_VALUE	Call by reference	☑	Type reference (TYPE)	DB6CC_PACKED_INT64			20090528
2	Returning	SQL_STATEMENT_TAB	Value transfer	☐	Type reference (TYPE)	DB6_EDITOR_LIST		DB6: Table of DB6_EDITOR_LINE	20090528
3	Importing	TBS_NAME	Call by reference	☐	Type reference (TYPE)	DB6CATTSP-TBS_NAME		DB6: Tablespace Name	20090528
4	Importing	VALUE_TYPE	Call by reference	☑	Type reference (TYPE)	STRING		Natural number	20090528

Method REDUCE_TABLESPACE_HWM on class CL_DB6_SQL_GENERATOR has no exception.

Method STOP_REDUCE_TABLESPACE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Returning	SQL_STATEMENT_TAB	Value transfer	☐	Type reference (TYPE)	DB6_EDITOR_LIST		DB6: Table of DB6_EDITOR_LINE	20090528
2	Importing	TBS_NAME	Call by reference	☐	Type reference (TYPE)	DB6CATTSP-TBS_NAME		DB6: Tablespace Name	20090528

Method STOP_REDUCE_TABLESPACE on class CL_DB6_SQL_GENERATOR has no exception.

History

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