SAP ABAP Class CL_SHDB_PARTSPEC (SAP HANA Partition Specs)
Hierarchy
☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ HAN-DB (Application Component) SAP HANA Database
     ⤷ SHDB (Package) Basis Package for HDB
Meta Relationship - Using
# Relationship type Using Short Description Created on
1 Inheritance (c INHERITING FROM c_ref)  CL_SHDB_BASE base class for HANA DB objects 20111107
2 Interface implementation (CLASS c. INTERFACES i_ref)  IF_SERIALIZABLE_OBJECT Serializable Object 20130312
Properties
Class CL_SHDB_PARTSPEC  
Short Description SAP HANA Partition Specs    
Super Class CL_SHDB_BASE base class for HANA DB objects 
Instantiability of a Class 0  Private 
Final    
General Data
Message Class    
Program status     
Category 0   
Package SHDB   Basis Package for HDB 
Created 20111104   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 ADBC Type group use (TYPE-POOLS tp)  Type group use (TYPE-POOLS tp)
3 CL_SHDB_PARTSPEC Forward declaration class (CLASS c DEFINITION DEFERRED)  Forward declaration class (CLASS c DEFINITION DEFERRED)
Interfaces
# Interface Abstract Final Description Created on
1 IF_SERIALIZABLE_OBJECT Serializable Object 20130312
Friends
Class CL_SHDB_PARTSPEC has no friend class.
Attributes
# Attribute Level Visibility Read only Typing Associated Type Initial Value Description Created on
1 MC_HASH Constant Public Type reference (TYPE) TV_PARTTYPE 'HASH' 20111104
2 MC_NUM_SERVERS Constant Public Type reference (TYPE) STRING '%NUM_SERVERS%' 20120724
3 MC_RANGE Constant Public Type reference (TYPE) TV_PARTTYPE 'RANGE' 20111104
4 MC_ROUNDROBIN Constant Public Type reference (TYPE) TV_PARTTYPE 'ROUNDROBIN' 20111104
5 _MC_ERR_CONVERSION Constant Private Type reference (TYPE) INT1 8 Int1 20131203
6 _MC_ERR_DATALOSS Constant Private Type reference (TYPE) INT1 7 Int1 20131203
7 _MC_ERR_PRECONDITION Constant Private Type reference (TYPE) INT1 6 Int1 20131203
8 _MC_ERR_SECURITY Constant Private Type reference (TYPE) INT1 3 Int1 20131203
9 _MC_ERR_SQL Constant Private Type reference (TYPE) INT1 1 Int1 20131203
10 _MC_ERR_SYNTAX Constant Private Type reference (TYPE) INT1 2 Int1 20131203
11 _MC_ERR_UNKNOWN_COLUMN Constant Private Type reference (TYPE) INT1 5 Int1 20131203
12 _MC_ERR_UNKNOWN_TYPE Constant Private Type reference (TYPE) INT1 4 Int1 20131203
13 _MC_LINES_SEP Constant Private Type reference (TYPE) CHAR1 ',' 20111104
14 _MC_RANGE_SEP Constant Private Type reference (TYPE) CHAR1 '-' Single-Character Flag 20111108
15 _MC_SPEC_SEP Constant Private Type reference (TYPE) CHAR1 ';' 20111104
16 _MC_TOKEN_SEP Constant Private Type reference (TYPE) CHAR1 ' ' 20111104
17 _MR_HOSTS Instance attribute Private Object reference (TYPE REF TO) CL_SHDB_HOSTS Provides information about HANA servers 20121127
18 _MT_SPEC Instance attribute Private Type reference (TYPE) TT_PSPEC 20111104
19 _MV_NEW_SINGLE_HOST_LOGIC Instance attribute Private Type reference (TYPE) ABAP_BOOL ABAP_TRUE New logic: HASH and ROUNDROBIN on single host always visible 20130122
20 _MV_SPEC Instance attribute Private Type reference (TYPE) STRING 20120109
21 _MV_TAB Instance attribute Private Type reference (TYPE) ADBC_NAME Table Name 20111107
Methods
# Method Level Visibility Method type Description Created on
1 COL_TYPE Instance method Public Method get the data type of a column if the table name was provided 20111107
2 CONSTRUCTOR Instance method Private Constructor use static factory new_by_spec() or new_by_tab() instead! 20111104
3 DEPTH Instance method Public Method get the number of partition levels 20111104
4 GET_FIELDS Instance method Public Method get the partition fields at a certain level (hash only) 20111107
5 GET_NUM_PARTITIONS Instance method Public Method Returns the number of used partitions (hash or roundrobin) 20120724
6 GET_RANGES Instance method Public Method get the partition ranges at a certain level (range only) 20111107
7 GET_SPEC Instance method Public Method returns a partition spec string 20120109
8 GET_TYPE Instance method Public Method get the partition type at a certain level 20111104
9 HAS_ZERO_RANGE Instance method Public Method Returns true if there is a zero value in the range partition 20130814
10 MERGE Instance method Public Method Merges the partitions in a HANA table 20130814
11 NEW_BY_SPEC Static method Public Method creates a new instance by given partition spec 20111114
12 NEW_BY_TAB Static method Public Method creates a new instance by given table name 20111115
13 OPERATOR_EQ Instance method Public Method returns true if two instances are identical 20111114
14 PARTITIONS Instance method Public Method number of partitions for hash and round robin (0 for range) 20111104
15 READ_PARTSPEC_DB Static method Public Method reads the partition spec from HANA DB 20111109
16 SET_NUM_PARTITIONS Instance method Public Method Changes NUM_SERVERS in hash and round robin partitions 20130122
17 USES_RANGE_REST_PARTITION Instance method Public Method True, if table occupies more range partitions than defined 20120724
18 WRITE_PARTSPEC_DB Instance method Public Method writes the partition spec to HANA DB 20120109
19 ZZ_TEST Static method Public Method -- local test only -- 20111104
20 _CREATE_SPEC_TABLE Instance method Private Method creates a table from partition spec string 20111104
21 _GET_COL_TYPE Instance method Private Method Determine the SQL data type of a certain column of table 20120724
22 _GET_ERRID_STATIC Static method Protected Method 20131203
23 _HAS_RANGE_REST_PARTITION Instance method Private Method True, if the partition spec contains a range partition '*' 20120724
24 _SET_TABNAME Instance method Private Method Set the Table Name 20111114
25 _SYNC_SPEC_STRING Instance method Private Method Update attribute _mv_spec according _mt_spec 20130122
26 _USES_RANGE_REST_PARTITION Instance method Private Method True, if table occupies more range partitions than defined 20120724
Events
Class CL_SHDB_PARTSPEC has no event.
Types
# Type Visibility Typing Associated Type Description Created on Type Source
1 TS_PSPEC Public See coding 20111104 BEGIN OF ts_pspec, num TYPE i, ptype TYPE tv_parttype, arg1 TYPE REF TO data, tab1 TYPE ref to data, END OF ts_pspec
2 TT_PSPEC Public See coding 20111104 tt_pspec TYPE STANDARD TABLE OF ts_pspec WITH KEY num
3 TV_PARTTYPE Public Type reference (TYPE) SHDBOBJECTNAME Name of an HDB Object 20111104
Method Signatures

Method COL_TYPE Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Importing IV_COL Call by reference Type reference (TYPE) DBFLDNAM nur Name einer DB-Tabellenfeldes 20111107
2 Returning RV_TYPE Value transfer Type reference (TYPE) DBTYPE Datenbank-Typ 20111107
# Exception Resumable Description Created on
1 CX_SHDB_EXCEPTION Ausnahmeklasse für SQL Fehler 20111115

Method CONSTRUCTOR Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Importing IV_NEW_SINGLE_HOST_LOGIC Call by reference Type reference (TYPE) ABAP_BOOL ABAP_TRUE 20130122
2 Importing IV_SPEC Call by reference Type reference (TYPE) STRING 20111104
# Exception Resumable Description Created on
1 CX_SHDB_EXCEPTION exceptions of HANA DB objects 20111107

Method DEPTH Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Returning RV_DEPTH Value transfer Type reference (TYPE) I 20111104

Method DEPTH on class CL_SHDB_PARTSPEC has no exception.

Method GET_FIELDS Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Importing IV_LEVEL Call by reference Type reference (TYPE) I partition level 20111107
2 Returning RT_FIELDS Value transfer Type reference (TYPE) SHDBFIELDNAMES table of partition field names 20111107

Method GET_FIELDS on class CL_SHDB_PARTSPEC has no exception.

Method GET_NUM_PARTITIONS Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Importing IV_LEVEL Call by reference Type reference (TYPE) I 20120724
2 Returning RV_NUM Value transfer Type reference (TYPE) I 20120724
# Exception Resumable Description Created on
1 CX_SHDB_EXCEPTION exceptions of HANA DB objects 20120724

Method GET_RANGES Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Importing IV_LEVEL Call by reference Type reference (TYPE) I partition level 20111107
2 Returning RT_RANGES Value transfer Type reference (TYPE) SHDB_VAL_RANGES table of partition ranges 20111107

Method GET_RANGES on class CL_SHDB_PARTSPEC has no exception.

Method GET_SPEC Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Returning RV_PSPEC Value transfer Type reference (TYPE) STRING 20120109

Method GET_SPEC on class CL_SHDB_PARTSPEC has no exception.

Method GET_TYPE Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Importing IV_LEVEL Call by reference Type reference (TYPE) I partition level 20111104
2 Returning RV_SPEC Value transfer Type reference (TYPE) CL_SHDB_PARTSPEC=>TV_PARTTYPE partition type 20111104

Method GET_TYPE on class CL_SHDB_PARTSPEC has no exception.

Method HAS_ZERO_RANGE Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Returning RV_ZERO Value transfer Type reference (TYPE) ABAP_BOOL 20130814

Method HAS_ZERO_RANGE on class CL_SHDB_PARTSPEC has no exception.

Method MERGE Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Importing IV_TABNAME Call by reference Type reference (TYPE) TABNAME Tabellenname 20130814
# Exception Resumable Description Created on
1 CX_SHDB_EXCEPTION exceptions of HANA DB objects 20130814

Method NEW_BY_SPEC Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Importing IV_SPEC Call by reference Type reference (TYPE) STRING 20111114
2 Importing IV_TAB Call by reference Type reference (TYPE) SHDBOBJECTNAME Name eines HDB-Objekts 20111114
3 Returning RR_REF Value transfer Object reference (TYPE REF TO) CL_SHDB_PARTSPEC HANA Partition Specs 20111114
# Exception Resumable Description Created on
1 CX_SHDB_EXCEPTION exceptions of HANA DB objects 20111115

Method NEW_BY_TAB Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Importing IV_TAB Call by reference Type reference (TYPE) SHDBOBJECTNAME Name eines HDB-Objekts 20111115
2 Returning RR_REF Value transfer Object reference (TYPE REF TO) CL_SHDB_PARTSPEC 20111115
# Exception Resumable Description Created on
1 CX_SHDB_EXCEPTION exceptions of HANA DB objects 20111115

Method OPERATOR_EQ Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Importing IR_OTHER Call by reference Object reference (TYPE REF TO) CL_SHDB_PARTSPEC HANA Partition Specs 20111114
2 Importing IV_TOLERANCE Call by reference Type reference (TYPE) ABAP_BOOL 20120724
3 Returning RV_RESULT Value transfer Type reference (TYPE) ABAP_BOOL 20111114
# Exception Resumable Description Created on
1 CX_SHDB_EXCEPTION exceptions of HANA DB objects 20120724

Method PARTITIONS Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Returning RV_PART Value transfer Type reference (TYPE) I Number of partitions 20111107

Method PARTITIONS on class CL_SHDB_PARTSPEC has no exception.

Method READ_PARTSPEC_DB Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Importing IV_TABNAME Call by reference Type reference (TYPE) SHDBOBJECTNAME 20111109
2 Returning RV_PSPEC Value transfer Type reference (TYPE) STRING 20111109
# Exception Resumable Description Created on
1 CX_SHDB_EXCEPTION 20111115

Method SET_NUM_PARTITIONS Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Importing IV_LEVEL Call by reference Type reference (TYPE) I partition level 20130122
2 Importing IV_NUM Call by reference Type reference (TYPE) STRING accepts string, since "%NUM_SERVERS%" is allowed 20130122

Method SET_NUM_PARTITIONS on class CL_SHDB_PARTSPEC has no exception.

Method USES_RANGE_REST_PARTITION Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Returning RV_RESULT Value transfer Type reference (TYPE) ABAP_BOOL 20120724
# Exception Resumable Description Created on
1 CX_SHDB_EXCEPTION 20120724

Method WRITE_PARTSPEC_DB Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Importing IV_TABNAME Call by reference Type reference (TYPE) STRING Tabellenname 20120109
# Exception Resumable Description Created on
1 CX_SHDB_EXCEPTION exceptions of HANA DB objects 20120109

Method ZZ_TEST Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Importing IV_PSPEC Call by reference Type reference (TYPE) STRING 20111107

Method ZZ_TEST on class CL_SHDB_PARTSPEC has no exception.

Method _CREATE_SPEC_TABLE Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Importing IV_SPEC Call by reference Type reference (TYPE) STRING 20111104
# Exception Resumable Description Created on
1 CX_SHDB_EXCEPTION exceptions of HANA DB objects 20131203

Method _GET_COL_TYPE Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Importing IV_COL Call by reference Type reference (TYPE) STRING 20120724
2 Returning RV_TYPE Value transfer Type reference (TYPE) STRING 20120724
# Exception Resumable Description Created on
1 CX_SHDB_EXCEPTION 20120724

Method _GET_ERRID_STATIC Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Importing IV_ERR Call by reference Type reference (TYPE) INT1 detailed error 0..99 20131203
2 Returning RV_ERRID Value transfer Type reference (TYPE) TEXTID Text-Id 20131203

Method _GET_ERRID_STATIC on class CL_SHDB_PARTSPEC has no exception.

Method _HAS_RANGE_REST_PARTITION Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Returning RV_RESULT Value transfer Type reference (TYPE) ABAP_BOOL 20120724

Method _HAS_RANGE_REST_PARTITION on class CL_SHDB_PARTSPEC has no exception.

Method _SET_TABNAME Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Importing IV_TAB Call by reference Type reference (TYPE) SHDBOBJECTNAME Name eines HDB-Objekts 20111114

Method _SET_TABNAME on class CL_SHDB_PARTSPEC has no exception.

Method _SYNC_SPEC_STRING Signature

Method _SYNC_SPEC_STRING on class CL_SHDB_PARTSPEC has no parameter.
Method _SYNC_SPEC_STRING on class CL_SHDB_PARTSPEC has no exception.

Method _USES_RANGE_REST_PARTITION Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Returning RV_RESULT Value transfer Type reference (TYPE) ABAP_BOOL 20120724
# Exception Resumable Description Created on
1 CX_SHDB_EXCEPTION 20120724
History
Last changed by/on SAP  20130531 
SAP Release Created in 730