SAP ABAP Class CL_SYB_SYSTABLES (SYB: System Tables Proxy)
Hierarchy
SAP_BASIS (Software Component) SAP Basis Component
   BC-DB-SYB (Application Component) Sybase ASE Database Platform
     SMSYB (Package) SYBASE Database Monitor
Properties
Class CL_SYB_SYSTABLES  
Short Description SYB: System Tables Proxy    
Super Class    
Instantiability of a Class 2  Public 
Final    
General Data
Message Class    
Program status     
Category 0   
Package SMSYB   SYBASE Database Monitor 
Created 20100722   SAP 
Last change 20141121    
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)
Interfaces
Class CL_SYB_SYSTABLES has no interface implemented.
Friends
Class CL_SYB_SYSTABLES has no friend class.
Attributes
Class CL_SYB_SYSTABLES has no attribute.
Methods
# Method Level Visibility Method type Description Created on
1 CALL_DERIVED_STAT Static method Private Method 20101122
2 CON_HAS_ROLE Static method Public Method 20110105
3 DETERMINE_APPL_DBNAME Static method Public Method 20121119
4 GET_DATABASES Static method Public Method 20110302
5 GET_DATABASES_DETAILED Static method Public Method 20130108
6 GET_DATABASE_USERS Static method Public Method 20111201
7 GET_DATACHANGE Static method Public Method 20101122
8 GET_DEVICES_DETAILED Static method Public Method 20130115
9 GET_DPAGE_CL_RATIO Static method Public Method 20101122
10 GET_DROW_CL_RATIO Static method Public Method 20101122
11 GET_IPAGE_CL_RATIO Static method Public Method 20101122
12 GET_LARGE_IO_EFF Static method Public Method 20101122
13 GET_NUM_TABLE_PARTITIONS Static method Public Method 20101119
14 GET_PROCEDURE_TEXT Static method Public Method 20100818
15 GET_SAP_CLIENTS Static method Public Method get list of existing SAP clients 20120320
16 GET_SEGMENTS_DETAILED Static method Public Method 20130304
17 GET_TABLE_COLUMNS Static method Public Method 20120803
18 IS_COMPRESSED_TABLE Static method Public Method 20120221
19 IS_EXISTING_DB Static method Public Method 20100726
20 IS_EXISTING_INDEX Static method Public Method 20100726
21 IS_EXISTING_PARTITION Static method Public Method 20130823
22 IS_EXISTING_PROCEDURE Static method Public Method 20100818
23 IS_EXISTING_ROLE Static method Public Method 20120131
24 IS_EXISTING_TABLE Static method Public Method 20100722
25 IS_EXISTING_VIEW Static method Public Method 20101102
Events
Class CL_SYB_SYSTABLES has no event.
Types
Class CL_SYB_SYSTABLES has no local type.
Method Signatures

Method CALL_DERIVED_STAT Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Importing DBNAME Call by reference Type reference (TYPE) SYBDBNAME SYB: DB Name 20101122
2 Importing INDEXNAME Call by reference Type reference (TYPE) CLIKE SYB: Object Name (Index, Table, Partition, ...) 20101122
3 Importing PARTITIONID Call by reference Type reference (TYPE) SYBOBJID SYB: Object ID (Index, Table, DB, Partition, ...) 20101122
4 Returning RATIO Value transfer Type reference (TYPE) SYB_SYSTABSTATS-PAGECLRATIO 20101122
5 Importing STATISTIC Call by reference Type reference (TYPE) STRING 20101122
6 Importing SYS_REF Call by reference Object reference (TYPE REF TO) CL_DB6_SYS DB6: Remote System Administration 20101122
7 Importing TABNAME Call by reference Type reference (TYPE) CLIKE SYB: Object Name (Index, Table, Partition, ...) 20101122
8 Importing TABOWNER Call by reference Type reference (TYPE) CLIKE SYB: Object Owner (Index, Table, DB, Partition, ...) 20101122
# Exception Resumable Description Created on
1 CX_DBA_ADBC DBA Cockpit: ADBC Errors 20101122

Method CON_HAS_ROLE 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_SYB_DBCON SYB: Connection Administration 20110314
2 Returning HAS_ROLE Value transfer Type reference (TYPE) ABAP_BOOL 20110105
3 Importing ROLE Call by reference Type reference (TYPE) CLIKE 20110105
4 Importing SYS_REF Call by reference Object reference (TYPE REF TO) CL_DB6_SYS 20110105
# Exception Resumable Description Created on
1 CX_DBA_ADBC DBA Cockpit: ADBC Errors 20110105

Method DETERMINE_APPL_DBNAME Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Importing DATABASES Call by reference Type reference (TYPE) DBAIKEYVAL_TAB DBA: Table of DBAIKEYVAL 20121119
2 Returning DBNAME Value transfer Type reference (TYPE) SYBDBNAME SYB: DB Name 20121119

Method DETERMINE_APPL_DBNAME on class CL_SYB_SYSTABLES has no exception.

Method GET_DATABASES Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Returning DATABASES Value transfer Type reference (TYPE) DBAIKEYVAL_TAB DBA: Table of DBAIKEYVAL 20110302
2 Importing EXCL_MIXEDLOG Call by reference Type reference (TYPE) ABAP_BOOL ABAP_FALSE 20131031
3 Importing EXCL_NONREPLICATED Call by reference Type reference (TYPE) ABAP_BOOL ABAP_FALSE 20130613
4 Importing EXCL_SYSTEMDBS Call by reference Type reference (TYPE) ABAP_BOOL ABAP_FALSE 20120313
5 Importing EXCL_TEMPDBS Call by reference Type reference (TYPE) ABAP_BOOL ABAP_FALSE 20120313
6 Importing SYS_REF Call by reference Object reference (TYPE REF TO) CL_DB6_SYS DB6: Remote System Administration 20110302
# Exception Resumable Description Created on
1 CX_DBA_ADBC DBA Cockpit: ADBC Errors 20110302

Method GET_DATABASES_DETAILED Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Exporting DATABASES Value transfer Type reference (TYPE) SYB_SYSDATABASES_TAB SYB: Table of SYB_SYSDATABASES 20130108
2 Importing INCL_AEXP_DEFDB Call by reference Type reference (TYPE) ABAP_BOOL ABAP_FALSE 20130110
3 Exporting MESSAGES Call by reference Type reference (TYPE) DBA_MSG_LIST DBA Cockpit: Message List 20130108
4 Importing SYS_REF Call by reference Object reference (TYPE REF TO) CL_DB6_SYS DB6: Remote System Administration 20130108
# Exception Resumable Description Created on
1 CX_DBA_ADBC DBA Cockpit: ADBC Errors 20130108
2 CX_DBA_RDI DBA-RDI: General Back-end Error 20130108

Method GET_DATABASE_USERS Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Importing DBNAME Call by reference Type reference (TYPE) SYBDBNAME SYB: DB Name 20111201
2 Importing SYS_REF Call by reference Object reference (TYPE REF TO) CL_DB6_SYS DB6: Remote System Administration 20111201
3 Returning USERS Value transfer Type reference (TYPE) DBAIKEYVAL_TAB DBA: Table of DBAIKEYVAL 20111201
# Exception Resumable Description Created on
1 CX_DBA_ADBC DBA Cockpit: ADBC Errors 20111201

Method GET_DATACHANGE Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Importing COLUMN Call by reference Type reference (TYPE) CLIKE SYB: Object Name (Index, Table, Partition, ...) 20101122
2 Returning DATACHANGE Value transfer Type reference (TYPE) SYB_SYSTABSTATS-DATACHANGE 20101122
3 Importing DBNAME Call by reference Type reference (TYPE) SYBDBNAME SYB: DB Name 20101122
4 Importing PARTITION Call by reference Type reference (TYPE) CLIKE SYB: Object ID (Index, Table, DB, Partition, ...) 20101122
5 Importing SYS_REF Call by reference Object reference (TYPE REF TO) CL_DB6_SYS DB6: Remote System Administration 20101122
6 Importing TABNAME Call by reference Type reference (TYPE) CLIKE SYB: Object Name (Index, Table, Partition, ...) 20101122
7 Importing TABOWNER Call by reference Type reference (TYPE) CLIKE SYB: Object Owner (Index, Table, DB, Partition, ...) 20101122
# Exception Resumable Description Created on
1 CX_DBA_ADBC DBA Cockpit: ADBC Errors 20101122

Method GET_DEVICES_DETAILED Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Importing DBNAME Call by reference Type reference (TYPE) SYBDBNAME DB filter 20130115
2 Exporting DEVICES Value transfer Type reference (TYPE) SYB_SYSDEVICES_TAB 20130115
3 Importing DEVTYPE Call by reference Type reference (TYPE) CLIKE device type filter 20130115
4 Importing INCL_AEXP_DEFDEV Call by reference Type reference (TYPE) ABAP_BOOL ABAP_FALSE 20130218
5 Exporting MESSAGES Call by reference Type reference (TYPE) DBA_MSG_LIST DBA Cockpit: Message List 20130115
6 Importing SEGBIT Call by reference Type reference (TYPE) SYB_SYSSEGMENTS-SEGBIT 20130131
7 Importing SYS_REF Call by reference Object reference (TYPE REF TO) CL_DB6_SYS DB6: Remote System Administration 20130115
# Exception Resumable Description Created on
1 CX_DBA_ADBC DBA Cockpit: ADBC Errors 20130115
2 CX_DBA_RDI DBA-RDI: General Back-end Error 20130115

Method GET_DPAGE_CL_RATIO Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Importing DBNAME Call by reference Type reference (TYPE) SYBDBNAME SYB: DB Name 20101122
2 Importing INDEXNAME Call by reference Type reference (TYPE) CLIKE 20101122
3 Importing PARTITIONID Call by reference Type reference (TYPE) SYBOBJID 20101122
4 Returning RATIO Value transfer Type reference (TYPE) SYB_SYSTABSTATS-PAGECLRATIO 20101122
5 Importing SYS_REF Call by reference Object reference (TYPE REF TO) CL_DB6_SYS DB6: Remote System Administration 20101122
6 Importing TABNAME Call by reference Type reference (TYPE) CLIKE 20101122
7 Importing TABOWNER Call by reference Type reference (TYPE) CLIKE 20101122
# Exception Resumable Description Created on
1 CX_DBA_ADBC DBA Cockpit: ADBC Errors 20101122

Method GET_DROW_CL_RATIO Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Importing DBNAME Call by reference Type reference (TYPE) SYBDBNAME SYB: DB Name 20101122
2 Importing INDEXNAME Call by reference Type reference (TYPE) CLIKE 20101122
3 Importing PARTITIONID Call by reference Type reference (TYPE) SYBOBJID 20101122
4 Returning RATIO Value transfer Type reference (TYPE) SYB_SYSTABSTATS-PAGECLRATIO 20101122
5 Importing SYS_REF Call by reference Object reference (TYPE REF TO) CL_DB6_SYS DB6: Remote System Administration 20101122
6 Importing TABNAME Call by reference Type reference (TYPE) CLIKE 20101122
7 Importing TABOWNER Call by reference Type reference (TYPE) CLIKE 20101122
# Exception Resumable Description Created on
1 CX_DBA_ADBC DBA Cockpit: ADBC Errors 20101122

Method GET_IPAGE_CL_RATIO Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Importing DBNAME Call by reference Type reference (TYPE) SYBDBNAME SYB: DB Name 20101122
2 Importing INDEXNAME Call by reference Type reference (TYPE) CLIKE 20101122
3 Importing PARTITIONID Call by reference Type reference (TYPE) SYBOBJID 20101122
4 Returning RATIO Value transfer Type reference (TYPE) SYB_SYSTABSTATS-PAGECLRATIO 20101122
5 Importing SYS_REF Call by reference Object reference (TYPE REF TO) CL_DB6_SYS DB6: Remote System Administration 20101122
6 Importing TABNAME Call by reference Type reference (TYPE) CLIKE 20101122
7 Importing TABOWNER Call by reference Type reference (TYPE) CLIKE 20101122
# Exception Resumable Description Created on
1 CX_DBA_ADBC DBA Cockpit: ADBC Errors 20101122

Method GET_LARGE_IO_EFF Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Importing DBNAME Call by reference Type reference (TYPE) SYBDBNAME SYB: DB Name 20101122
2 Importing INDEXNAME Call by reference Type reference (TYPE) CLIKE 20101122
3 Returning LIOEFF Value transfer Type reference (TYPE) SYB_SYSTABSTATS-PAGECLRATIO 20101130
4 Importing PARTITIONID Call by reference Type reference (TYPE) SYBOBJID 20101122
5 Importing SYS_REF Call by reference Object reference (TYPE REF TO) CL_DB6_SYS DB6: Remote System Administration 20101122
6 Importing TABNAME Call by reference Type reference (TYPE) CLIKE 20101122
7 Importing TABOWNER Call by reference Type reference (TYPE) CLIKE 20101122
# Exception Resumable Description Created on
1 CX_DBA_ADBC DBA Cockpit: ADBC Errors 20101122

Method GET_NUM_TABLE_PARTITIONS Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Importing DBNAME Call by reference Type reference (TYPE) CLIKE 20101119
2 Returning PARTITIONS Value transfer Type reference (TYPE) I 20101119
3 Importing SYS_REF Call by reference Object reference (TYPE REF TO) CL_DB6_SYS 20101119
4 Importing TABNAME Call by reference Type reference (TYPE) CLIKE 20101119
5 Importing TABOWNER Call by reference Type reference (TYPE) CLIKE 20101119
# Exception Resumable Description Created on
1 CX_DBA_ADBC DBA Cockpit: ADBC Errors 20101119

Method GET_PROCEDURE_TEXT Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Importing DBNAME Call by reference Type reference (TYPE) CLIKE 20100818
2 Importing PROCNAME Call by reference Type reference (TYPE) CLIKE 20100818
3 Importing PROCOWNER Call by reference Type reference (TYPE) CLIKE 20100818
4 Importing SYS_REF Call by reference Object reference (TYPE REF TO) CL_DB6_SYS DB6: Remote System Administration 20100818
5 Returning TEXT Value transfer Type reference (TYPE) STRING 20100818
# Exception Resumable Description Created on
1 CX_DBA_ADBC DBA Cockpit: ADBC Errors 20100818

Method GET_SAP_CLIENTS Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Returning CLIENTS Value transfer Type reference (TYPE) DBAKEYVAL_TAB 20120320
2 Importing DBNAME Call by reference Type reference (TYPE) SYBDBNAME 20120320
3 Importing EXCL_ANY Call by reference Type reference (TYPE) ABAP_BOOL ABAP_FALSE 20120320
4 Importing SYS_REF Call by reference Object reference (TYPE REF TO) CL_DB6_SYS 20120320
# Exception Resumable Description Created on
1 CX_DBA_ADBC DBA Cockpit: ADBC Errors 20120320

Method GET_SEGMENTS_DETAILED Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Importing DBNAME Call by reference Type reference (TYPE) SYBDBNAME DB filter 20130304
2 Exporting MESSAGES Call by reference Type reference (TYPE) DBA_MSG_LIST DBA Cockpit: Message List 20130304
3 Exporting SEGMENTS Value transfer Type reference (TYPE) SYB_SYSSEGMENTS_TAB 20130304
4 Importing SYS_REF Call by reference Object reference (TYPE REF TO) CL_DB6_SYS DB6: Remote System Administration 20130304
# Exception Resumable Description Created on
1 CX_DBA_ADBC DBA Cockpit: ADBC Errors 20130304
2 CX_DBA_RDI DBA-RDI: General Back-end Error 20130304

Method GET_TABLE_COLUMNS Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Returning ADBC_COLS Value transfer Type reference (TYPE) ADBC_TABCOL_DESCR_TAB 20120803
2 Importing DBNAME Call by reference Type reference (TYPE) CLIKE 20120803
3 Importing SYS_REF Call by reference Object reference (TYPE REF TO) CL_DB6_SYS DB6: Remote System Administration 20120803
4 Importing TABNAME Call by reference Type reference (TYPE) CLIKE 20120803
5 Importing TABOWNER Call by reference Type reference (TYPE) CLIKE 20120803
# Exception Resumable Description Created on
1 CX_DBA_ADBC DBA Cockpit: ADBC Errors 20120803

Method IS_COMPRESSED_TABLE Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Returning COMPRESSED Value transfer Type reference (TYPE) ABAP_BOOL 20120221
2 Importing DBNAME Call by reference Type reference (TYPE) CLIKE 20120221
3 Importing SYS_REF Call by reference Object reference (TYPE REF TO) CL_DB6_SYS 20120221
4 Importing TABNAME Call by reference Type reference (TYPE) CLIKE 20120221
5 Importing TABOWNER Call by reference Type reference (TYPE) CLIKE 20120221
# Exception Resumable Description Created on
1 CX_DBA_ADBC DBA Cockpit: ADBC Errors 20120221

Method IS_EXISTING_DB 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 20120507
2 Importing DBNAME Call by reference Type reference (TYPE) CLIKE 20100726
3 Returning EXISTING Value transfer Type reference (TYPE) ABAP_BOOL 20100726
4 Importing SYS_REF Call by reference Object reference (TYPE REF TO) CL_DB6_SYS DB6: Remote System Administration 20100726
# Exception Resumable Description Created on
1 CX_DBA_ADBC DBA Cockpit: ADBC Errors 20100726

Method IS_EXISTING_INDEX Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Importing DBNAME Call by reference Type reference (TYPE) CLIKE 20100726
2 Importing INDNAME Call by reference Type reference (TYPE) CLIKE 20100726
3 Importing INDOWNER Call by reference Type reference (TYPE) CLIKE 20100726
4 Returning RESULT Value transfer Type reference (TYPE) ABAP_BOOL 20100726
5 Importing SYS_REF Call by reference Object reference (TYPE REF TO) CL_DB6_SYS 20100726
# Exception Resumable Description Created on
1 CX_DBA_ADBC DBA Cockpit: ADBC Errors 20100726

Method IS_EXISTING_PARTITION Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Importing DBNAME Call by reference Type reference (TYPE) CLIKE 20130823
2 Importing PARTIDX Call by reference Type reference (TYPE) ABAP_BOOL 20130823
3 Importing PARTNAME Call by reference Type reference (TYPE) CLIKE 20130823
4 Returning RESULT Value transfer Type reference (TYPE) ABAP_BOOL 20130823
5 Importing SYS_REF Call by reference Object reference (TYPE REF TO) CL_DB6_SYS 20130823
6 Importing TABOWNER Call by reference Type reference (TYPE) CLIKE 20130823
# Exception Resumable Description Created on
1 CX_DBA_ADBC DBA Cockpit: ADBC Errors 20130823

Method IS_EXISTING_PROCEDURE Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Importing DBNAME Call by reference Type reference (TYPE) CLIKE 20100818
2 Returning EXISTING Value transfer Type reference (TYPE) ABAP_BOOL 20100818
3 Importing PROCNAME Call by reference Type reference (TYPE) CLIKE 20100818
4 Importing PROCOWNER Call by reference Type reference (TYPE) CLIKE 20100818
5 Importing SYS_REF Call by reference Object reference (TYPE REF TO) CL_DB6_SYS 20100818
# Exception Resumable Description Created on
1 CX_DBA_ADBC DBA Cockpit: ADBC Errors 20100818

Method IS_EXISTING_ROLE Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Returning EXISTING Value transfer Type reference (TYPE) ABAP_BOOL 20120131
2 Importing ROLE Call by reference Type reference (TYPE) CLIKE 20120131
3 Importing SYS_REF Call by reference Object reference (TYPE REF TO) CL_DB6_SYS DB6: Remote System Administration 20120131
# Exception Resumable Description Created on
1 CX_DBA_ADBC DBA Cockpit: ADBC Errors 20120131

Method IS_EXISTING_TABLE Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Importing DBNAME Call by reference Type reference (TYPE) CLIKE 20100722
2 Returning EXISTING Value transfer Type reference (TYPE) ABAP_BOOL 20100722
3 Importing SYS_REF Call by reference Object reference (TYPE REF TO) CL_DB6_SYS 20100722
4 Importing TABNAME Call by reference Type reference (TYPE) CLIKE 20100722
5 Importing TABOWNER Call by reference Type reference (TYPE) CLIKE 20100722
# Exception Resumable Description Created on
1 CX_DBA_ADBC DBA Cockpit: ADBC Errors 20100722

Method IS_EXISTING_VIEW Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Importing DBNAME Call by reference Type reference (TYPE) CLIKE 20101102
2 Returning EXISTING Value transfer Type reference (TYPE) ABAP_BOOL 20101102
3 Importing SYS_REF Call by reference Object reference (TYPE REF TO) CL_DB6_SYS 20101102
4 Importing VIEWNAME Call by reference Type reference (TYPE) CLIKE 20101102
5 Importing VIEWOWNER Call by reference Type reference (TYPE) CLIKE 20101102
# Exception Resumable Description Created on
1 CX_DBA_ADBC DBA Cockpit: ADBC Errors 20101102
History
Last changed by/on SAP  20141121 
SAP Release Created in 703