SAP ABAP Class CL_SYB_RDI_QUERY (SYB: Backend Interface)

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-DB-SYB (Application Component) Sybase ASE Database Platform
     ⤷ SMSYB (Package) SYBASE Database Monitor

Meta Relationship - Using

#	Relationship type	Using	Short Description	Created on
1	Inheritance (c INHERITING FROM c_ref)	CL_DBA_RDI_QUERY	DBA-RDI-QRY: Query Facade	20100723

Properties

Class	CL_SYB_RDI_QUERY
Short Description	SYB: Backend Interface
Super Class	CL_DBA_RDI_QUERY	DBA-RDI-QRY: Query Facade
Instantiability of a Class	2	Public
Final	☑

General Data

Message Class
Program status
Category	0
Package	SMSYB	SYBASE Database Monitor
Created	20100723	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	CL_SYB_RDI_QUERY	Forward declaration class (CLASS c DEFINITION DEFERRED)	Forward declaration class (CLASS c DEFINITION DEFERRED)

Interfaces

Class CL_SYB_RDI_QUERY has no interface implemented.

Friends

Class CL_SYB_RDI_QUERY has no friend class.

Attributes

#	Attribute	Level	Visibility	Read only	Typing	Associated Type	Initial Value	Description	Created on
1	SET_WORKLOAD	Instance attribute	Private	☐	Type reference (TYPE)	ABAP_BOOL			20111024

Methods

#	Method	Level	Visibility	Method type	Description	Created on
1	CAST_DB6TSTAMP_TO_SYB_DATETIME	Static method	Public	Method		20121022
2	CAST_SYB_DATETIME_TO_DATS	Static method	Public	Method		20100806
3	CAST_SYB_DATETIME_TO_DB6TSTAMP	Static method	Public	Method		20101220
4	CAST_SYB_DATETIME_TO_TIMS	Static method	Public	Method		20100806
5	CONSTRUCTOR	Instance method	Public	Constructor	CONSTRUCTOR	20100723
6	CREATE_SNAP_PHASE	Instance method	Private	Method		20100909
7	EXECUTE_DDL	Static method	Public	Method	sets WL attributes, commits and executes the query	20100816
8	EXECUTE_PROC	Static method	Public	Method	sets WL attributes, commits and executes the query	20100909
9	EXECUTE_QUERY	Static method	Public	Method	sets WL attributes, commits and executes the query	20100816
10	EXECUTE_UPDATE	Static method	Public	Method	sets WL attributes, commits and executes the query	20100816
11	GEN_GET_CURR_SNAP_TIME	Static method	Public	Method		20130626
12	GEN_GET_LAST_SNAP_TIME	Static method	Public	Method		20130626
13	GEN_SP_STAGING_PHASE_INTERNAL	Instance method	Private	Method		20100909
14	GET_STMTCACHE_META	Instance method	Public	Method		20120705
15	GET_STMTCACHE_PERF	Instance method	Public	Method		20120619
16	GET_TABLES_PERF	Instance method	Public	Method		20110530
17	GET_TABLES_SPACE	Instance method	Public	Method		20110530
18	SET_FILTER_FROM_WD_INST_SEL	Instance method	Public	Method		20100723
19	SET_FILTER_FROM_WD_METRIC_SEL	Instance method	Public	Method		20100723

Events

Class CL_SYB_RDI_QUERY has no event.

Types

Class CL_SYB_RDI_QUERY has no local type.

Method Signatures

Method CAST_DB6TSTAMP_TO_SYB_DATETIME Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Returning	CAST	Value transfer	☐	Type reference (TYPE)	STRING			20121022
2	Importing	FIELD	Call by reference	☐	Type reference (TYPE)	STRING			20121022

Method CAST_DB6TSTAMP_TO_SYB_DATETIME on class CL_SYB_RDI_QUERY has no exception.

Method CAST_SYB_DATETIME_TO_DATS Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Returning	CAST	Value transfer	☐	Type reference (TYPE)	STRING			20100806
2	Importing	FIELD	Call by reference	☐	Type reference (TYPE)	STRING			20100806

Method CAST_SYB_DATETIME_TO_DATS on class CL_SYB_RDI_QUERY has no exception.

Method CAST_SYB_DATETIME_TO_DB6TSTAMP Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Returning	CAST	Value transfer	☐	Type reference (TYPE)	STRING			20101220
2	Importing	FIELD	Call by reference	☐	Type reference (TYPE)	STRING			20101220

Method CAST_SYB_DATETIME_TO_DB6TSTAMP on class CL_SYB_RDI_QUERY has no exception.

Method CAST_SYB_DATETIME_TO_TIMS Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Returning	CAST	Value transfer	☐	Type reference (TYPE)	STRING			20100806
2	Importing	FIELD	Call by reference	☐	Type reference (TYPE)	STRING			20100806

Method CAST_SYB_DATETIME_TO_TIMS on class CL_SYB_RDI_QUERY has no exception.

Method CONSTRUCTOR Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	RDI_META	Call by reference	☐	Object reference (TYPE REF TO)	CL_DBA_RDI_META		DBA: Back-end Meta Data	20100723

#	Exception	Resumable	Description	Created on
1	CX_DBA_RDI	☐	DBA-RDI: General Back-end Error	20100723

Method CREATE_SNAP_PHASE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	HAS_INC_MODE	Call by reference	☐	Type reference (TYPE)	ABAP_BOOL	ABAP_FALSE		20100909
2	Importing	INDENT	Call by reference	☐	Type reference (TYPE)	STRING	''		20100909
3	Importing	SP	Call by reference	☐	Object reference (TYPE REF TO)	CL_SYB_DBH_STORED_PROCEDURE			20100909

#	Exception	Resumable	Description	Created on
1	CX_DBA_RDI	☐	DBA-RDI: General Back-end Error	20100909

Method EXECUTE_DDL Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	NO_REPLICATION	Call by reference	☐	Type reference (TYPE)	ABAP_BOOL	ABAP_FALSE		20130726
2	Importing	RUN_IN_DB	Call by reference	☑	Type reference (TYPE)	CLIKE			20100816
3	Importing	RUN_IN_DB_STMT_REF	Call by reference	☑	Object reference (TYPE REF TO)	CL_SQL_STATEMENT		SQL statement	20101217
4	Importing	STMT_REF	Call by reference	☐	Object reference (TYPE REF TO)	CL_SQL_STATEMENT		SQL statement	20100816
5	Importing	STMT_TXT	Call by reference	☐	Type reference (TYPE)	STRING			20100816

#	Exception	Resumable	Description	Created on
1	CX_SQL_EXCEPTION	☐	Exception Class for SQL Error	20100816

Method EXECUTE_PROC Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	PROC_NAME	Call by reference	☐	Type reference (TYPE)	CLIKE			20100909
2	Importing	RUN_IN_DB	Call by reference	☑	Type reference (TYPE)	CLIKE			20100909
3	Importing	RUN_IN_DB_STMT_REF	Call by reference	☑	Object reference (TYPE REF TO)	CL_SQL_STATEMENT		SQL statement	20101217
4	Importing	STMT_REF	Call by reference	☐	Object reference (TYPE REF TO)	CL_SQL_STATEMENT		SQL statement	20100909

#	Exception	Resumable	Description	Created on
1	CX_SQL_EXCEPTION	☐	Exception Class for SQL Error	20100909

Method EXECUTE_QUERY Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Returning	RS_REF	Value transfer	☐	Object reference (TYPE REF TO)	CL_SQL_RESULT_SET		Resulting Set of an SQL Query	20100816
2	Importing	STMT_REF	Call by reference	☐	Object reference (TYPE REF TO)	CL_SQL_STATEMENT		SQL statement	20100816
3	Importing	STMT_TXT	Call by reference	☐	Type reference (TYPE)	STRING			20100816

#	Exception	Resumable	Description	Created on
1	CX_SQL_EXCEPTION	☐	Exception Class for SQL Error	20100816

Method EXECUTE_UPDATE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Returning	PROC_CNT	Value transfer	☐	Type reference (TYPE)	I			20100816
2	Importing	RUN_IN_DB	Call by reference	☑	Type reference (TYPE)	CLIKE			20130726
3	Importing	RUN_IN_DB_STMT_REF	Call by reference	☑	Object reference (TYPE REF TO)	CL_SQL_STATEMENT		SQL statement	20130726
4	Importing	STMT_REF	Call by reference	☐	Object reference (TYPE REF TO)	CL_SQL_STATEMENT		SQL statement	20100816
5	Importing	STMT_TXT	Call by reference	☐	Type reference (TYPE)	STRING			20100816

#	Exception	Resumable	Description	Created on
1	CX_SQL_EXCEPTION	☐	Exception Class for SQL Error	20100816

Method GEN_GET_CURR_SNAP_TIME Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	SNAPSHOT_TABLE	Call by reference	☐	Type reference (TYPE)	STRING			20130626
2	Importing	SP	Call by reference	☐	Object reference (TYPE REF TO)	CL_DBA_STORED_PROCEDURE		DBA-DBH: Stored Procedure Helper	20130626

Method GEN_GET_CURR_SNAP_TIME on class CL_SYB_RDI_QUERY has no exception.

Method GEN_GET_LAST_SNAP_TIME Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	HAS_SOURCE_HOSTNAME	Call by reference	☐	Type reference (TYPE)	ABAP_BOOL	ABAP_TRUE		20130626
2	Importing	SNAPSHOT_TABLE	Call by reference	☐	Type reference (TYPE)	STRING			20130626
3	Importing	SP	Call by reference	☐	Object reference (TYPE REF TO)	CL_DBA_STORED_PROCEDURE		DBA-DBH: Stored Procedure Helper	20130626

Method GEN_GET_LAST_SNAP_TIME on class CL_SYB_RDI_QUERY has no exception.

Method GEN_SP_STAGING_PHASE_INTERNAL Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	CALC_DELTA	Call by reference	☐	Type reference (TYPE)	ABAP_BOOL			20100909
2	Importing	HANDLE_OVERFLOWS	Call by reference	☐	Type reference (TYPE)	ABAP_BOOL	ABAP_TRUE		20110228
3	Importing	PHASE	Call by reference	☐	Type reference (TYPE)	I			20110224
4	Importing	SP	Call by reference	☐	Object reference (TYPE REF TO)	CL_SYB_DBH_STORED_PROCEDURE			20100909
5	Importing	STG_COMPARE_OP	Call by reference	☐	Type reference (TYPE)	STRING			20110224
6	Importing	STG_COMPARE_TIME	Call by reference	☐	Type reference (TYPE)	STRING			20110224

Method GEN_SP_STAGING_PHASE_INTERNAL on class CL_SYB_RDI_QUERY has no exception.

Method GET_STMTCACHE_META Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Changing	STMT_META	Call by reference	☐	Type reference (TYPE)	SYBMON_CACHEDSTMT_META			20120705

#	Exception	Resumable	Description	Created on
1	CX_DBA_ADBC	☐	DBA Cockpit: ADBC Errors	20120705

Method GET_STMTCACHE_PERF Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	BI_TOP_ONLY	Call by reference	☐	Type reference (TYPE)	ABAP_BOOL	ABAP_FALSE		20120705
2	Importing	CACHEDDATE	Call by reference	☑	Type reference (TYPE)	DB6TSTAMP			20120619
3	Importing	CUSTOM_SELECTION	Call by reference	☑	Type reference (TYPE)	SYB_STMT_CUSTOM_SELECTION			20120705
4	Importing	GRANULARITY	Call by reference	☑	Type reference (TYPE)	I			20120903
5	Importing	SSQLID	Call by reference	☑	Type reference (TYPE)	SYBMON_CACHEDSTMT-SSQLID			20120619
6	Returning	STATEMENTS	Value transfer	☐	Type reference (TYPE)	SYBMON_CACHEDSTMT_TAB			20120619
7	Importing	STMT_TEXT	Call by reference	☑	Type reference (TYPE)	SYBMON_CACHEDSTMT-STMT_TEXT			20120704
8	Importing	TIME_SELECTION	Call by reference	☐	Type reference (TYPE)	DBA_WD_TIMESLIDER			20120619
9	Importing	TOP_BY	Call by reference	☑	Type reference (TYPE)	STRING			20120619
10	Importing	TOP_BY_ORDER	Call by reference	☐	Type reference (TYPE)	DBA_OPERATOR	CL_SYB_RDI_QUERY=>CO_DESCENDING		20120619
11	Importing	TOP_N	Call by reference	☑	Type reference (TYPE)	I			20120619

#	Exception	Resumable	Description	Created on
1	CX_DBA_ADBC	☐	DBA Cockpit: ADBC Errors	20120619
2	CX_DBA_DBH_COLLECTOR	☐	DBA-DBH: Collector Exception	20120620
3	CX_DBA_RDI	☐	DBA-RDI: General Back-end Error	20120620

Method GET_TABLES_PERF 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	20110530
2	Importing	KEEP_PARTITIONS	Call by reference	☐	Type reference (TYPE)	ABAP_BOOL	ABAP_FALSE		20110601
3	Returning	TABLES	Value transfer	☐	Type reference (TYPE)	SYBMON_TABLE_PERF_TAB		SYB: Table of SYBMON_TABLE_PERF	20110530
4	Importing	TABNAME	Call by reference	☑	Type reference (TYPE)	SYBOBJNAME		SYB: Object Name (Index, Table, Partition, ...)	20110530
5	Importing	TABOWNER	Call by reference	☑	Type reference (TYPE)	SYBOBJOWNER		SYB: Object Owner (Index, Table, DB, Partition, ...)	20110530
6	Importing	TIME_SELECTION	Call by reference	☑	Type reference (TYPE)	DBA_WD_TIMESLIDER		DBA Cockpit: Description of Time Slider UI Element	20110530
7	Importing	TOP_BY	Call by reference	☑	Type reference (TYPE)	STRING			20110530
8	Importing	TOP_BY_ORDER	Call by reference	☐	Type reference (TYPE)	DBA_OPERATOR	CL_SYB_RDI_QUERY=>CO_DESCENDING	DBA Cockpit: Operator String	20110531
9	Importing	TOP_N	Call by reference	☑	Type reference (TYPE)	I			20110530

#	Exception	Resumable	Description	Created on
1	CX_DBA_ADBC	☐	DBA Cockpit: ADBC Errors	20110530
2	CX_DBA_DBH_COLLECTOR	☐	DBA-DBH: Collector Exception	20120703
3	CX_DBA_RDI	☐	DBA-RDI: General Back-end Error	20120703

Method GET_TABLES_SPACE 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	20110530
2	Importing	KEEP_PARTITIONS	Call by reference	☐	Type reference (TYPE)	ABAP_BOOL	ABAP_FALSE		20110601
3	Returning	TABLES	Value transfer	☐	Type reference (TYPE)	SYBMON_TABLE_SPACE_TAB		SYB: Table of SYBMON_TABLE_SPACE	20110530
4	Importing	TABNAME	Call by reference	☑	Type reference (TYPE)	SYBOBJNAME		SYB: Object Name (Index, Table, Partition, ...)	20110530
5	Importing	TABOWNER	Call by reference	☑	Type reference (TYPE)	SYBOBJOWNER		SYB: Object Owner (Index, Table, DB, Partition, ...)	20110530
6	Importing	TIME_SELECTION	Call by reference	☑	Type reference (TYPE)	DBA_WD_TIMESLIDER		DBA Cockpit: Description of Time Slider UI Element	20110530
7	Importing	TOP_BY	Call by reference	☑	Type reference (TYPE)	STRING			20110530
8	Importing	TOP_BY_ORDER	Call by reference	☐	Type reference (TYPE)	DBA_OPERATOR	CL_SYB_RDI_QUERY=>CO_DESCENDING	DBA Cockpit: Operator String	20110531
9	Importing	TOP_N	Call by reference	☑	Type reference (TYPE)	I			20110530

#	Exception	Resumable	Description	Created on
1	CX_DBA_ADBC	☐	DBA Cockpit: ADBC Errors	20110530

Method SET_FILTER_FROM_WD_INST_SEL Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	DDIC_FIELD	Call by reference	☐	Type reference (TYPE)	STRING			20100723
2	Importing	MEMBER_SELECTION	Call by reference	☐	Type reference (TYPE)	DB6_WD_MEMBER_SELECTION		DB6: WD Member Selection	20100723

Method SET_FILTER_FROM_WD_INST_SEL on class CL_SYB_RDI_QUERY has no exception.

Method SET_FILTER_FROM_WD_METRIC_SEL Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	DDIC_FIELD	Call by reference	☐	Type reference (TYPE)	STRING			20100723
2	Importing	METRIC_SELECTION	Call by reference	☐	Type reference (TYPE)	DB6_WD_METRIC_SELECTION			20100723
3	Importing	TYPE_DDIC_FIELD	Call by reference	☐	Type reference (TYPE)	STRING			20100723

Method SET_FILTER_FROM_WD_METRIC_SEL on class CL_SYB_RDI_QUERY has no exception.

History

Last changed by/on	SAP	20141121
SAP Release Created in	703