SAP ABAP Class CL_DB2_CONVTOOL (DB2 z/OS: Conversions recommended for objects (table/index))
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
SAP_BASIS (Software Component) SAP Basis Component⤷
BC-DB-DB2 (Application Component) DB2 for z/OS⤷
STU2 (Package) CCMS for DB2 for OS/390Properties
| Class | CL_DB2_CONVTOOL | |
| Short Description | DB2 z/OS: Conversions recommended for objects (table/index) | |
| 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 | 20110628 | 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_CONVTOOL has no interface implemented.
Friends
Class CL_DB2_CONVTOOL has no friend class.
Attributes
| # | Attribute | Level | Visibility | Read only | Typing | Associated Type | Initial Value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 | C_ANALYSIS_TIME |
Constant | Public | Type reference (TYPE) | DB2SUBKEY | 'ANA_TIME' | DB2 z/OS: subkey of an object | 20110705 | |
| 2 | C_AT |
Constant | Public | Type reference (TYPE) | DB2OBJECTTYPE | 'AT' | Type of object e.g. TS, IS, TB, IX | 20110705 | |
| 3 | C_BITCHAR |
Constant | Public | Type reference (TYPE) | DB2COLTYPE | 'BITCHAR' | Column type specified in the column definition | 20111223 | |
| 4 | C_BITVARCHAR |
Constant | Public | Type reference (TYPE) | DB2COLTYPE | 'BITVARC' | Column type specified in the column definition | 20111223 | |
| 5 | C_BLOB |
Constant | Public | Type reference (TYPE) | DB2COLTYPE | 'BLOB' | Column type specified in the column definition | 20110713 | |
| 6 | C_BPOOL_ACTUAL |
Constant | Public | Type reference (TYPE) | DB2SUBKEY | 'BPOOL_ACTUAL' | DB2 z/OS: subkey of an object | 20110701 | |
| 7 | C_BPOOL_TARGET |
Constant | Public | Type reference (TYPE) | DB2SUBKEY | 'BPOOL_TARGET' | DB2 z/OS: subkey of an object | 20110701 | |
| 8 | C_BRF |
Constant | Public | Type reference (TYPE) | DB2VALUE128 | 'BRF' | DB2 Type of Conversion | 20110705 | |
| 9 | C_CHAR |
Constant | Public | Type reference (TYPE) | DB2COLTYPE | 'CHAR' | Column type specified in the column definition | 20111011 | |
| 10 | C_CLOB |
Constant | Public | Type reference (TYPE) | DB2COLTYPE | 'CLOB' | Column type specified in the column definition | 20110713 | |
| 11 | C_DATABASE |
Constant | Public | Type reference (TYPE) | DB2SUBKEY | 'DATABASE' | DB2 z/OS: subkey of an object | 20110629 | |
| 12 | C_DATATYPE_ACTUAL |
Constant | Public | Type reference (TYPE) | DB2SUBKEY | 'DATATYPE_ACTUAL' | DB2 z/OS: subkey of an object | 20110629 | |
| 13 | C_DATATYPE_TARGET |
Constant | Public | Type reference (TYPE) | DB2SUBKEY | 'DATATYPE_TARGET' | DB2 z/OS: subkey of an object | 20110629 | |
| 14 | C_DBCLOB |
Constant | Public | Type reference (TYPE) | DB2COLTYPE | 'DBCLOB' | Column type specified in the column definition | 20110713 | |
| 15 | C_DB_TABLENAME |
Constant | Public | Type reference (TYPE) | DB2TABNAML | 'DB2CONVTOOL' | Name of transparent table for conversion tool | 20110712 | |
| 16 | C_FIXCHAR |
Constant | Public | Type reference (TYPE) | DB2CONVERTTYPE | 'FIXCHAR' | DB2 Type of Conversion | 20110629 | |
| 17 | C_GRAPHIC |
Constant | Public | Type reference (TYPE) | DB2COLTYPE | 'GRAPHIC' | Column type specified in the column definition | 20111011 | |
| 18 | C_INDEXSPACE |
Constant | Public | Type reference (TYPE) | DB2SUBKEY | 'INDEXSPACE' | DB2 z/OS: subkey of an object | 20110629 | |
| 19 | C_INLINELEN_ACTUAL |
Constant | Public | Type reference (TYPE) | DB2SUBKEY | 'INLINELEN_ACTUAL' | DB2 z/OS: subkey of an object | 20110629 | |
| 20 | C_INLINELEN_TARGET |
Constant | Public | Type reference (TYPE) | DB2SUBKEY | 'INLINELEN_TARGET' | DB2 z/OS: subkey of an object | 20110629 | |
| 21 | C_INL_LOB |
Constant | Public | Type reference (TYPE) | DB2CONVERTTYPE | 'INL_LOB' | DB2 Type of Conversion | 20110629 | |
| 22 | C_IX |
Constant | Public | Type reference (TYPE) | DB2OBJECTTYPE | 'IX' | Type of object e.g. TS, IS, TB, IX | 20110629 | |
| 23 | C_LENGTH_ACTUAL |
Constant | Public | Type reference (TYPE) | DB2SUBKEY | 'LENGTH_ACTUAL' | DB2 z/OS: subkey of an object | 20110629 | |
| 24 | C_LENGTH_TARGET |
Constant | Public | Type reference (TYPE) | DB2SUBKEY | 'LENGTH_TARGET' | DB2 z/OS: subkey of an object | 20110629 | |
| 25 | C_MULTITS |
Constant | Public | Type reference (TYPE) | DB2VALUE128 | 'MULTI' | DB2 z/OS: Value of a certain key in random format | 20110714 | |
| 26 | C_PBG |
Constant | Public | Type reference (TYPE) | DB2VALUE128 | 'PBGUTS' | DB2 Type of Conversion | 20110630 | |
| 27 | C_PBR |
Constant | Public | Type reference (TYPE) | DB2VALUE128 | 'PBR' | DB2 z/OS: Value of a certain key in random format | 20110707 | |
| 28 | C_PGSIZE_ACTUAL |
Constant | Public | Type reference (TYPE) | DB2SUBKEY | 'PGSIZE_ACTUAL' | DB2 z/OS: subkey of an object | 20110629 | |
| 29 | C_PGSIZE_TARGET |
Constant | Public | Type reference (TYPE) | DB2SUBKEY | 'PGSIZE_TARGET' | DB2 z/OS: subkey of an object | 20110629 | |
| 30 | C_ROWFORMAT |
Constant | Public | Type reference (TYPE) | STRING | 'ROWFORMAT RRF' | 20111114 | ||
| 31 | C_ROWFORMAT_ACTUAL |
Constant | Public | Type reference (TYPE) | DB2SUBKEY | 'ROWFORMAT_ACTUAL' | DB2 z/OS: subkey of an object | 20110629 | |
| 32 | C_ROWFORMAT_TARGET |
Constant | Public | Type reference (TYPE) | DB2SUBKEY | 'ROWFORMAT_TARGET' | DB2 z/OS: subkey of an object | 20110629 | |
| 33 | C_RPUTS |
Constant | Public | Type reference (TYPE) | DB2VALUE128 | 'RPUTS' | DB2 Type of Conversion | 20110701 | |
| 34 | C_RRF |
Constant | Public | Type reference (TYPE) | DB2VALUE128 | 'RRF' | DB2 Type of Conversion | 20110705 | |
| 35 | C_SEGM |
Constant | Public | Type reference (TYPE) | DB2VALUE128 | 'SEGM' | DB2 Type of Conversion | 20110701 | |
| 36 | C_SIMPLE |
Constant | Public | Type reference (TYPE) | DB2VALUE128 | 'SIMPLE' | DB2 z/OS: Value of a certain key in random format | 20110707 | |
| 37 | C_SPACETYPE_ACTUAL |
Constant | Public | Type reference (TYPE) | DB2SUBKEY | 'SPACETYPE_ACTUAL' | DB2 z/OS: subkey of an object | 20110630 | |
| 38 | C_SPACETYPE_TARGET |
Constant | Public | Type reference (TYPE) | DB2SUBKEY | 'SPACETYPE_TARGET' | DB2 z/OS: subkey of an object | 20110630 | |
| 39 | C_TABLESPACE |
Constant | Public | Type reference (TYPE) | DB2SUBKEY | 'TABLESPACE' | DB2 z/OS: subkey of an object | 20110629 | |
| 40 | C_TB |
Constant | Public | Type reference (TYPE) | DB2OBJECTTYPE | 'TB' | Type of object e.g. TS, IS, TB, IX | 20110629 | |
| 41 | C_VARCHAR |
Constant | Public | Type reference (TYPE) | DB2COLTYPE | 'VARCHAR' | Column type specified in the column definition | 20111011 | |
| 42 | C_VARGRAPHIC |
Constant | Public | Type reference (TYPE) | DB2COLTYPE | 'VARG' | Column type specified in the column definition | 20111011 | |
| 43 | C_ZPARM_BPOOL_16K |
Constant | Public | Type reference (TYPE) | STRING | 'TBSBP16K' | 20110707 | ||
| 44 | C_ZPARM_BPOOL_32K |
Constant | Public | Type reference (TYPE) | STRING | 'TBSBP32K' | 20110707 | ||
| 45 | C_ZPARM_BPOOL_4K |
Constant | Public | Type reference (TYPE) | STRING | 'TBSBPOOL' | 20110707 | ||
| 46 | C_ZPARM_BPOOL_8K |
Constant | Public | Type reference (TYPE) | STRING | 'TBSBP8K' | 20110707 | ||
| 47 | C_ZPARM_DSSIZE |
Constant | Public | Type reference (TYPE) | STRING | 'IMPDSSIZE' | 20130307 | ||
| 48 | C_ZPARM_INLINE_LENGTH |
Constant | Public | Type reference (TYPE) | STRING | 'LOB_INLINE_LENGTH' | 20110707 | ||
| 49 | C_ZPARM_SEGSIZE |
Constant | Public | Type reference (TYPE) | STRING | 'DPSEGSZ' | 20111114 |
Methods
| # | Method | Level | Visibility | Method type | Description | Created on |
|---|---|---|---|---|---|---|
| 1 | ADD_REASON |
Static method | Private | Method | Add a reason for non-convertible | 20110715 |
| 2 | ANALYSIS_FIXCHAR |
Static method | Public | Method | Run analysis for Inline LOB length | 20111010 |
| 3 | ANALYSIS_INL_LOB |
Static method | Public | Method | Run analysis for Inline LOB length | 20110629 |
| 4 | DECODE_OBJECT |
Static method | Private | Method | Transposes DB object into WORK object | 20110628 |
| 5 | DELETE_ANALYSIS |
Static method | Public | Method | Delete the complete analysis from table db2convtool | 20110705 |
| 6 | ENCODE_OBJECT |
Static method | Private | Method | Transposes WORK object into DB object | 20110628 |
| 7 | GET_ALL_OBJECTS |
Static method | Private | Method | Read all objects from db2convtool | 20110628 |
| 8 | GET_ALTER_STATEMENTS |
Static method | Public | Method | Provide statement which updates the current table | 20110628 |
| 9 | GET_ANALYSIS_TIME |
Static method | Public | Method | Get date and time of last analysis | 20110705 |
| 10 | GET_DSSIZE |
Static method | Private | Method | Returns DSSIZE to convert from Seg. Tbs to PBG UTS | 20130307 |
| 11 | GET_INLINE_LOBS |
Static method | Private | Method | Get target LOB inline length for a specified LOB column | 20110712 |
| 12 | GET_MAXPARTITIONS |
Static method | Private | Method | Returns MAX_PARTITIONS to convert from Seg. Tbs to PBG UTS | 20111114 |
| 13 | GET_OBJECTS |
Static method | Public | Method | Read all objects from db2convtool including exceptions | 20111115 |
| 14 | GET_PAGESIZE |
Static method | Private | Method | Get target LOB inline length for a specified LOB column | 20110713 |
| 15 | GET_SEGSIZE |
Static method | Private | Method | Returns SEGSIZE to convert from PBR to RP UTS | 20111114 |
| 16 | GET_SUPPORTED_ACTIONS |
Static method | Public | Method | Get supported Actions | 20111010 |
| 17 | GET_TABLESPACE_TYPE |
Static method | Private | Method | Get type of tablespace e.g. Segmented, PBG etc | 20110707 |
| 18 | GET_ZPARM_VALUES |
Static method | Private | Method | Get default values for buffer pool and inline length | 20111114 |
| 19 | INVALIDATE_ANALYSIS_TIME |
Static method | Private | Method | Get date and time of last analysis | 20111010 |
| 20 | IS_RRF |
Static method | Private | Method | Does Object lives in a tablespace with RRF | 20110705 |
| 21 | LOAD_OBJECT |
Static method | Public | Method | Read all details per object from the db2convtool | 20110628 |
| 22 | SAVE_OBJECT |
Static method | Private | Method | Store an analyzed object in db2convtool | 20110628 |
| 23 | SET_ANALYSIS_TIME |
Static method | Private | Method | Set data and time of last analysis | 20110705 |
| 24 | SET_CONVERT_FLAGS |
Static method | Private | Method | Set convert flags depending on various checks | 20110708 |
Events
Class CL_DB2_CONVTOOL has no event.
Types
Class CL_DB2_CONVTOOL has no local type.
Method Signatures
Method ADD_REASON Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 |  Importing |
ADD | Call by reference | Type reference (TYPE) | DB2NONCONVREASON | Reason for non-convertible | 20110715 | ||
| 2 |  Changing |
REASONS | Call by reference | Type reference (TYPE) | DB2NONCONVREASON | Reason for non-convertible | 20110715 |
Method ADD_REASON on class CL_DB2_CONVTOOL has no exception.
Method ANALYSIS_FIXCHAR Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Importing |
MAX_OBJECTS | Call by reference | Type reference (TYPE) | INT4 | Natural number | 20111104 | ||
| 2 | Importing |
OBJECTNAME_FILTER | Value transfer | Type reference (TYPE) | DB2OBJECTNAME | '*' | Filter can contains "*" as wildcard | 20111110 | |
| 3 | Importing |
REMOTE_DBCON | Call by reference | Type reference (TYPE) | DBCON_NAME | Logical name for a database connection | 20111010 |
| # | Exception | Resumable | Description | Created on |
|---|---|---|---|---|
| 1 |  CX_DB2_ROOT |
DB2: root class regarding exceptions | 20111010 | |
| 2 | CX_SQL_EXCEPTION |
Exception Class for SQL Error | 20111010 |
Method ANALYSIS_INL_LOB Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Importing |
MAX_OBJECTS | Call by reference | Type reference (TYPE) | INT4 | Natural number | 20111104 | ||
| 2 | Importing |
OBJECTNAME_FILTER | Value transfer | Type reference (TYPE) | DB2OBJECTNAME | '*' | Filter can contains "*" as wildcard | 20111110 | |
| 3 | Importing |
REMOTE_DBCON | Call by reference | Type reference (TYPE) | DBCON_NAME | Logical name for a database connection | 20110629 |
| # | Exception | Resumable | Description | Created on |
|---|---|---|---|---|
| 1 | CX_DB2_ROOT |
DB2: root class regarding exceptions | 20110629 | |
| 2 | CX_SQL_EXCEPTION |
Exception Class for SQL Error | 20110629 |
Method DECODE_OBJECT Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Changing |
DB_OBJECT | Call by reference | Type reference (TYPE) | DB2_CONVTOOL_DB_TAB | DB2 creator name | 20110628 | ||
| 2 |  Exporting |
OBJECT | Call by reference | Type reference (TYPE) | DB2_CONVTOOL_ALL | Recommendations for conversions per object | 20110628 |
| # | Exception | Resumable | Description | Created on |
|---|---|---|---|---|
| 1 | CX_DB2_ROOT |
DB2: root class regarding exceptions | 20110629 |
Method DELETE_ANALYSIS 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_NAME | Logical name for a database connection | 20110705 |
| # | Exception | Resumable | Description | Created on |
|---|---|---|---|---|
| 1 | CX_SQL_EXCEPTION |
Exception Class for SQL Error | 20110705 |
Method ENCODE_OBJECT Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Importing |
CONVERTTYPE | Call by reference | Type reference (TYPE) | DB2CONVERTTYPE | DB2 Type of Conversion | 20110629 | ||
| 2 | Exporting |
DB_OBJECT | Call by reference | Type reference (TYPE) | DB2_CONVTOOL_DB_TAB | DB2 creator name | 20110628 | ||
| 3 | Importing |
OBJECT | Call by reference | Type reference (TYPE) | DB2_CONVTOOL_ALL | Recommendations for conversions per object | 20110628 |
| # | Exception | Resumable | Description | Created on |
|---|---|---|---|---|
| 1 | CX_DB2_ROOT |
20110629 | ||
| 2 | CX_SY_RANGE_OUT_OF_BOUNDS |
System Exceptions Accessing Subfields Beyond Boundary | 20130522 |
Method GET_ALL_OBJECTS Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Exporting |
OBJECTS | Call by reference | Type reference (TYPE) | DB2_CONVTOOL_BASE_TAB | DB2 z/OS Structure for Conversions (incl. Target vs. Actual) | 20110628 | ||
| 2 | Importing |
REMOTE_DBCON | Call by reference | Type reference (TYPE) | DBCON_NAME | Logical name for a database connection | 20110628 |
| # | Exception | Resumable | Description | Created on |
|---|---|---|---|---|
| 1 | CX_DB2_ROOT |
DB2: root class regarding exceptions | 20111117 | |
| 2 | CX_SQL_EXCEPTION |
Exception Class for SQL Error | 20110628 |
Method GET_ALTER_STATEMENTS Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Importing |
OBJECTNAME | Call by reference | Type reference (TYPE) | DB2OBJECTNAME | Object name (table, index, column) | 20111114 | ||
| 2 | Importing |
QUALIFIER | Call by reference | Type reference (TYPE) | DB2CCSCHEM | Schema name to qualify tables (statistics, catalog, created) | 20111114 | ||
| 3 | Importing |
REMOTE_DBCON | Call by reference | Type reference (TYPE) | DBCON_NAME | Recommendations for conversions per object base+detail | 20111114 | ||
| 4 | Exporting |
STATEMENTS | Value transfer | Type reference (TYPE) | DB2_T_STRING | Table of Strings | 20111114 |
| # | Exception | Resumable | Description | Created on |
|---|---|---|---|---|
| 1 | CX_DB2_ROOT |
DB2: root class regarding exceptions | 20111114 | |
| 2 | CX_SQL_EXCEPTION |
Exception Class for SQL Error | 20110628 |
Method GET_ANALYSIS_TIME Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Exporting |
ANALYSIS_DATE | Call by reference | Type reference (TYPE) | SYDATUM | Current Date of Application Server | 20110705 | ||
| 2 | Exporting |
ANALYSIS_TIME | Call by reference | Type reference (TYPE) | SYUZEIT | Current Time of Application Server | 20110705 | ||
| 3 | Importing |
REMOTE_DBCON | Call by reference | Type reference (TYPE) | DBCON_NAME | Logical name for a database connection | 20110705 |
| # | Exception | Resumable | Description | Created on |
|---|---|---|---|---|
| 1 | CX_SQL_EXCEPTION |
Exception Class for SQL Error | 20110705 |
Method GET_DSSIZE Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 |  Returning |
DSSIZE | Value transfer | Type reference (TYPE) | STRING | 20130307 | |||
| 2 | Importing |
REMOTE_DBCON | Call by reference | Type reference (TYPE) | DBCON_NAME | 20130307 |
| # | Exception | Resumable | Description | Created on |
|---|---|---|---|---|
| 1 | CX_DB2_ROOT |
20130307 |
Method GET_INLINE_LOBS Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Exporting |
INLINE_LOBS | Call by reference | Type reference (TYPE) | DB2_T_INLINE_LOB | DB2-z/OS: LOB inline length | 20110712 | ||
| 2 | Importing |
OBJECTNAME | Call by reference | Type reference (TYPE) | DB2OBJECTNAME | Obejct name (table, index, column) | 20110712 | ||
| 3 | Exporting |
PAGESIZE | Call by reference | Type reference (TYPE) | DB2PGSIZE | DB2 for OS/390 page size in KBytes | 20110713 | ||
| 4 | Importing |
QUALIFIER | Call by reference | Type reference (TYPE) | DB2CCSCHEM | Schema name to qualify tables (statistics, catalog, created) | 20110712 | ||
| 5 | Importing |
REMOTE_DBCON | Call by reference | Type reference (TYPE) | DBCON_NAME | Logical name for a database connection | 20110712 |
| # | Exception | Resumable | Description | Created on |
|---|---|---|---|---|
| 1 | CX_DB2_ROOT |
DB2: root class regarding exceptions | 20110712 |
Method GET_MAXPARTITIONS Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Returning |
MAXPARTITIONS | Value transfer | Type reference (TYPE) | STRING | Natural number | 20111114 |
Method GET_MAXPARTITIONS on class CL_DB2_CONVTOOL has no exception.
Method GET_OBJECTS Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Exporting |
COUNT_ALL_OBJECTS | Call by reference | Type reference (TYPE) | INT4 | Natural number | 20111115 | ||
| 2 | Exporting |
COUNT_TO_BE_PROCESSED | Call by reference | Type reference (TYPE) | INT4 | Natural number | 20111115 | ||
| 3 | Importing |
OBJECTNAME_FILTER | Value transfer | Type reference (TYPE) | DB2OBJECTNAME | '*' | Recommendations for conversion of objects excl+base itab | 20111115 | |
| 4 | Exporting |
OBJECTS | Call by reference | Type reference (TYPE) | DB2_CONVTOOL_ALV_TAB | Recommendations for conversions per object excluded+base | 20111115 | ||
| 5 | Importing |
REMOTE_DBCON | Call by reference | Type reference (TYPE) | DBCON_NAME | Logical name for a database connection | 20111115 | ||
| 6 | Importing |
TO_BE_PROCESSED | Call by reference | Type reference (TYPE) | ABAP_BOOL | ABAP_FALSE | Only objects, which will be converted | 20111115 |
| # | Exception | Resumable | Description | Created on |
|---|---|---|---|---|
| 1 | CX_DB2_ROOT |
DB2: root class regarding exceptions | 20111117 | |
| 2 | CX_SQL_EXCEPTION |
Exception Class for SQL Error | 20111115 |
Method GET_PAGESIZE Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Importing |
INLINE_LENGTH | Call by reference | Type reference (TYPE) | INT4 | Natural number | 20110713 | ||
| 2 | Importing |
OBJECTNAME | Call by reference | Type reference (TYPE) | DB2OBJECTNAME | Obejct name (table, index, column) | 20110713 | ||
| 3 | Exporting |
PAGESIZE | Call by reference | Type reference (TYPE) | DB2PGSIZE | DB2 for OS/390 page size in KBytes | 20110713 | ||
| 4 | Importing |
QUALIFIER | Call by reference | Type reference (TYPE) | DB2CCSCHEM | Schema name to qualify tables (statistics, catalog, created) | 20110713 | ||
| 5 | Importing |
REMOTE_DBCON | Call by reference | Type reference (TYPE) | DBCON_NAME | Logical name for a database connection | 20110713 |
| # | Exception | Resumable | Description | Created on |
|---|---|---|---|---|
| 1 | CX_DB2_ROOT |
DB2: root class regarding exceptions | 20110713 | |
| 2 | CX_SQL_EXCEPTION |
Exception Class for SQL Error | 20110718 |
Method GET_SEGSIZE 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_NAME | Logical name for a database connection | 20111114 | ||
| 2 | Returning |
SEGSIZE | Value transfer | Type reference (TYPE) | STRING | Natural number | 20111114 |
| # | Exception | Resumable | Description | Created on |
|---|---|---|---|---|
| 1 | CX_DB2_ROOT |
DB2: root class regarding exceptions | 20111114 |
Method GET_SUPPORTED_ACTIONS Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Exporting |
FIXCHAR | Call by reference | Type reference (TYPE) | ABAP_BOOL | 20111010 | |||
| 2 | Exporting |
INLINE_LOB | Call by reference | Type reference (TYPE) | ABAP_BOOL | 20111010 | |||
| 3 | Importing |
REMOTE_DBCON | Call by reference | Type reference (TYPE) | DBCON_NAME | Logical Name for a Database Connection | 20111010 |
Method GET_SUPPORTED_ACTIONS on class CL_DB2_CONVTOOL has no exception.
Method GET_TABLESPACE_TYPE Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Importing |
CAT_NTABLES | Call by reference | Type reference (TYPE) | INT2 | 2 byte integer (signed) | 20110714 | ||
| 2 | Importing |
CAT_PARTITIONS | Call by reference | Type reference (TYPE) | INT2 | 2 byte integer (signed) | 20110707 | ||
| 3 | Importing |
CAT_SEGSIZE | Call by reference | Type reference (TYPE) | INT2 | 2 byte integer (signed) | 20110707 | ||
| 4 | Importing |
CAT_TYPE | Call by reference | Type reference (TYPE) | DB2CHAR01 | Field type char, length 1 | 20110707 | ||
| 5 | Returning |
TYPE | Value transfer | Type reference (TYPE) | DB2VALUE128 | DB2 z/OS: Value of a certain key in random format | 20110707 |
Method GET_TABLESPACE_TYPE on class CL_DB2_CONVTOOL has no exception.
Method GET_ZPARM_VALUES Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Exporting |
BPOOL_16K | Call by reference | Type reference (TYPE) | DB2BPOOL | Buffer pool name e.g. BP2, BP8K1 | 20111114 | ||
| 2 | Exporting |
BPOOL_32K | Call by reference | Type reference (TYPE) | DB2BPOOL | Buffer pool name e.g. BP2, BP8K1 | 20111114 | ||
| 3 | Exporting |
BPOOL_4K | Call by reference | Type reference (TYPE) | DB2BPOOL | Buffer pool name e.g. BP2, BP8K1 | 20111114 | ||
| 4 | Exporting |
BPOOL_8K | Call by reference | Type reference (TYPE) | DB2BPOOL | Buffer pool name e.g. BP2, BP8K1 | 20111114 | ||
| 5 | Exporting |
DSSIZE | Call by reference | Type reference (TYPE) | STRING | Value of ZPARM IMPDSSIZE | 20130307 | ||
| 6 | Exporting |
INLINE_LENGTH | Call by reference | Type reference (TYPE) | INT4 | Natural number | 20111114 | ||
| 7 | Importing |
REMOTE_DBCON | Call by reference | Type reference (TYPE) | DBCON_NAME | Logical name for a database connection | 20111114 | ||
| 8 | Exporting |
SEGSIZE | Call by reference | Type reference (TYPE) | STRING | Value of ZPARM DPSEGSZ | 20111114 |
| # | Exception | Resumable | Description | Created on |
|---|---|---|---|---|
| 1 | CX_DB2_ROOT |
DB2: root class regarding exceptions | 20111114 |
Method INVALIDATE_ANALYSIS_TIME 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_NAME | Logical name for a database connection | 20111010 |
| # | Exception | Resumable | Description | Created on |
|---|---|---|---|---|
| 1 | CX_SQL_EXCEPTION |
Exception Class for SQL Error | 20111010 |
Method IS_RRF Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Importing |
DBNAME | Call by reference | Type reference (TYPE) | DB2DBNAME | Schema name to qualify tables (statistics, catalog, created) | 20110705 | ||
| 2 | Returning |
IS_RRF | Value transfer | Type reference (TYPE) | ABAP_BOOL | 20110705 | |||
| 3 | Importing |
REMOTE_DBCON | Call by reference | Type reference (TYPE) | DBCON_NAME | Logical name for a database connection | 20110705 | ||
| 4 | Importing |
TSNAME | Call by reference | Type reference (TYPE) | DB2TSIXNM | Tablespace/indexspace name | 20110705 |
| # | Exception | Resumable | Description | Created on |
|---|---|---|---|---|
| 1 | CX_DB2_ROOT |
DB2: root class regarding exceptions | 20110705 | |
| 2 | CX_SQL_EXCEPTION |
Exception Class for SQL Error | 20110705 |
Method LOAD_OBJECT Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Exporting |
OBJECT | Call by reference | Type reference (TYPE) | DB2_CONVTOOL_ALL | DB2 z/OS Structure for Conversions (incl. Target vs. Actual) | 20110628 | ||
| 2 | Importing |
OBJECTNAME | Call by reference | Type reference (TYPE) | DB2OBJECTNAME | DB2 long table or database name | 20110628 | ||
| 3 | Importing |
QUALIFIER | Call by reference | Type reference (TYPE) | DB2CCSCHEM | Schema name to qualify tables (statistics, catalog, created) | 20110628 | ||
| 4 | Importing |
REMOTE_DBCON | Call by reference | Type reference (TYPE) | DBCON_NAME | Logical name for a database connection | 20110628 |
| # | Exception | Resumable | Description | Created on |
|---|---|---|---|---|
| 1 | CX_DB2_ROOT |
DBA Cockpit: Root exception class | 20111114 | |
| 2 | CX_SQL_EXCEPTION |
Exception Class for SQL Error | 20110628 |
Method SAVE_OBJECT Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Importing |
CONVERTTYPE | Call by reference | Type reference (TYPE) | DB2CONVERTTYPE | DB2 Type of Conversion | 20110629 | ||
| 2 | Importing |
OBJECT | Call by reference | Type reference (TYPE) | DB2_CONVTOOL_ALL | Recommendations for conversions per object | 20110628 | ||
| 3 | Importing |
REMOTE_DBCON | Call by reference | Type reference (TYPE) | DBCON_NAME | Logical name for a database connection | 20110628 |
| # | Exception | Resumable | Description | Created on |
|---|---|---|---|---|
| 1 | CX_DB2_ROOT |
DB2: root class regarding exceptions | 20110629 | |
| 2 | CX_SQL_EXCEPTION |
Exception Class for SQL Error | 20110628 |
Method SET_ANALYSIS_TIME 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_NAME | Logical name for a database connection | 20110705 |
| # | Exception | Resumable | Description | Created on |
|---|---|---|---|---|
| 1 | CX_SQL_EXCEPTION |
Exception Class for SQL Error | 20110705 |
Method SET_CONVERT_FLAGS Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Importing |
CONVERTTYPE | Call by reference | Type reference (TYPE) | DB2CONVERTTYPE | DB2 Type of Conversion | 20110708 | ||
| 2 | Changing |
OBJECT | Call by reference | Type reference (TYPE) | DB2_CONVTOOL_ALL | Recommendations for conversions per object base data | 20110708 |
Method SET_CONVERT_FLAGS on class CL_DB2_CONVTOOL has no exception.
History
| Last changed by/on | SAP | 20140121 |
| SAP Release Created in | 732 |
