SAP ABAP Class /IWHDB/CL_HAI_RT_QUERY_ADP (Runtime query execution for HANA data)

Hierarchy

☛ SAP_GWFND (Software Component) SAP Gateway Foundation
   ⤷ OPU-BSE-SDE (Application Component) Gateway SAP Data Enablement
     ⤷ /IWHDB/HAI_RT (Package) Gateway - HANA Analytics Integration - Runtime

Properties

Class	/IWHDB/CL_HAI_RT_QUERY_ADP
Short Description	Runtime query execution for HANA data
Super Class
Instantiability of a Class	2	Public
Final	☑

General Data

Message Class
Program status
Category	0
Package	/IWHDB/HAI_RT	Gateway - HANA Analytics Integration - Runtime
Created	20120223	SAP
Last change	20130531	SAP
Shared Memory-enabled	☐
Fixed point arithmetic	☑
Unicode checks active	☑

Forward declarations

#	Type group / Object type	Type	Type Description
1	/IWBEP/IF_MGW_APPL_SRV_RUNTIME	Forward declaration interface (INTERFACE i DEFINITION DEF...	Forward declaration interface (INTERFACE i DEFINITION DEF...
2	/IWBEP/IF_MGW_CORE_SRV_RUNTIME	Forward declaration interface (INTERFACE i DEFINITION DEF...	Forward declaration interface (INTERFACE i DEFINITION DEF...

Interfaces

Class /IWHDB/CL_HAI_RT_QUERY_ADP has no interface implemented.

Friends

Class /IWHDB/CL_HAI_RT_QUERY_ADP has no friend class.

Attributes

#	Attribute	Level	Visibility	Read only	Typing	Associated Type	Initial Value	Description	Created on
1	GC_RESULT_COUNT_FIELD	Instance attribute	Private	☐	Type reference (TYPE)	STRING	'RESULT_COUNT'		20120417
2	MO_HANA_MD_READER	Instance attribute	Private	☐	Object reference (TYPE REF TO)	/IWHDB/CL_HAI_RT_MD_READER		Retrieves data from HANA database	20120228
3	MO_SQL_WRAPPER	Instance attribute	Private	☐	Object reference (TYPE REF TO)	/IWHDB/CL_HAI_RT_SQL_WRAPPER		Wrapper for HANA (ADBC) SQL Statements	20120228

Methods

#	Method	Level	Visibility	Method type	Description	Created on
1	CHECK_SQL_FILTER_STRING	Instance method	Private	Method	Checks SQL filter sting for not supported expressions	20120419
2	CLOSE_DB_CONNECTION	Instance method	Public	Method	Close Database Connection	20120430
3	CONSTRUCTOR	Instance method	Public	Constructor		20120228
4	GET_COLUMNS	Instance method	Private	Method	Builds string for column definition in SELECT statement	20120228
5	GET_GROUPING	Instance method	Private	Method	Builds string with grouping definition for SELECT statement	20120228
6	GET_KEY_GRP_FROM_KEY_SRC	Instance method	Private	Method	Get key and grouping info from constructed KeyTab and RowID	20120404
7	GET_ORDERBY	Instance method	Private	Method	Builds string for orderby part of SELECT statement	20120228
8	GET_SELECT_STMNT	Instance method	Private	Method	Builds string for SELECT statement	20120412
9	GET_SELECT_STMNT_QUERY_CNT	Instance method	Private	Method	Builds string for SELECT statement for row count of query	20120413
10	GET_WHERE	Instance method	Private	Method	Builds string with where-clauses for SELECT statement	20120228
11	HANDLE_SQL_EXCEPTION	Instance method	Private	Method	Log and ... SQL Exception	20120228
12	QUERY_VIEW	Instance method	Public	Method	Queries multiple view items from HANA (EntitySet)	20120228
13	QUERY_VIEW_ITEM	Instance method	Public	Method	Queries single view items from HANA (Entity)	20120228
14	SET_QUERY_ROW_ID	Instance method	Private	Method	Construct RowID as Unique Identifier	20120404

Events

Class /IWHDB/CL_HAI_RT_QUERY_ADP has no event.

Types

Class /IWHDB/CL_HAI_RT_QUERY_ADP has no local type.

Method Signatures

Method CHECK_SQL_FILTER_STRING Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IS_VIEW	Call by reference	☐	Type reference (TYPE)	/IWHDB/S_HAI_RT_VIEW		HANA View	20120419
2	Importing	IT_PROPERTIES	Call by reference	☐	Type reference (TYPE)	/IWHDB/T_HAI_RT_VCOL_TYPES		HANA View Column Types	20120419
3	Importing	IV_FILTER_STRING	Call by reference	☐	Type reference (TYPE)	STRING			20120419

#	Exception	Resumable	Description	Created on
1	/IWBEP/CX_MGW_TECH_EXCEPTION	☐	Technical Exception	20120419

Method CLOSE_DB_CONNECTION Signature

Method CLOSE_DB_CONNECTION on class /IWHDB/CL_HAI_RT_QUERY_ADP has no parameter.

#	Exception	Resumable	Description	Created on
1	/IWBEP/CX_MGW_TECH_EXCEPTION	☐	Technical Exception	20120430

Method CONSTRUCTOR Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IV_CON_NAME	Call by reference	☐	Type reference (TYPE)	/IWHDB/DEFI_HANA_DB_CON		Database connection name - Points to HANA system	20120228

#	Exception	Resumable	Description	Created on
1	/IWBEP/CX_MGW_TECH_EXCEPTION	☐	Technical Exception	20120229

Method GET_COLUMNS Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IS_VIEW	Call by reference	☐	Type reference (TYPE)	/IWHDB/S_HAI_RT_VIEW		HANA View	20120228
2	Importing	IT_PROPERTIES	Call by reference	☐	Type reference (TYPE)	/IWHDB/T_HAI_RT_VCOL_TYPES		HANA View Column Types	20120228
3	Importing	IT_SEL_COLUMNS	Call by reference	☑	Type reference (TYPE)	STRING_TABLE			20120330
4	Returning	RV_COLUMNS	Value transfer	☐	Type reference (TYPE)	STRING			20120228

Method GET_COLUMNS on class /IWHDB/CL_HAI_RT_QUERY_ADP has no exception.

Method GET_GROUPING Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IS_VIEW	Call by reference	☐	Type reference (TYPE)	/IWHDB/S_HAI_RT_VIEW		HANA View	20120228
2	Importing	IT_PROPERTIES	Call by reference	☐	Type reference (TYPE)	/IWHDB/T_HAI_RT_VCOL_TYPES		HANA View Column Types	20120228
3	Importing	IT_SEL_COLUMNS	Call by reference	☑	Type reference (TYPE)	STRING_TABLE		Table of Strings	20120330
4	Returning	RV_GROUPING	Value transfer	☐	Type reference (TYPE)	STRING			20120228

Method GET_GROUPING on class /IWHDB/CL_HAI_RT_QUERY_ADP has no exception.

Method GET_KEY_GRP_FROM_KEY_SRC Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	ET_KEY_TAB	Call by reference	☐	Type reference (TYPE)	/IWBEP/T_MGW_TECH_PAIRS		Technical name-value pairs	20120404
2	Exporting	ET_SEL_TAB	Call by reference	☐	Type reference (TYPE)	STRING_TABLE		Table of Strings	20120404
3	Importing	IT_KEY_TAB_ID	Call by reference	☐	Type reference (TYPE)	/IWBEP/T_MGW_TECH_PAIRS		Technical name-value pairs	20120410
4	Importing	IV_VIEW_NAME	Call by reference	☐	Type reference (TYPE)	STRING			20120920

Method GET_KEY_GRP_FROM_KEY_SRC on class /IWHDB/CL_HAI_RT_QUERY_ADP has no exception.

Method GET_ORDERBY Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IT_ORDERBY	Call by reference	☐	Type reference (TYPE)	/IWBEP/T_MGW_TECH_ORDER		the sorting order	20120412
2	Returning	RV_ORDERBY	Value transfer	☐	Type reference (TYPE)	STRING			20120229

Method GET_ORDERBY on class /IWHDB/CL_HAI_RT_QUERY_ADP has no exception.

Method GET_SELECT_STMNT Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IV_COLUMNS_STRING	Call by reference	☐	Type reference (TYPE)	STRING			20120412
2	Importing	IV_GROUPING_STRING	Call by reference	☐	Type reference (TYPE)	STRING			20120412
3	Importing	IV_ORDERBY_STRING	Call by reference	☑	Type reference (TYPE)	STRING			20120412
4	Importing	IV_TABLE_NAME	Call by reference	☐	Type reference (TYPE)	STRING			20120412
5	Importing	IV_TOP	Call by reference	☑	Type reference (TYPE)	I			20120412
6	Importing	IV_WHERE_STRING	Call by reference	☑	Type reference (TYPE)	STRING			20120412
7	Returning	RV_SELECT_STMNT	Value transfer	☐	Type reference (TYPE)	STRING			20120412

Method GET_SELECT_STMNT on class /IWHDB/CL_HAI_RT_QUERY_ADP has no exception.

Method GET_SELECT_STMNT_QUERY_CNT Signature

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

Method GET_SELECT_STMNT_QUERY_CNT on class /IWHDB/CL_HAI_RT_QUERY_ADP has no exception.

Method GET_WHERE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	ET_ADBC_STMNT_PARAM	Call by reference	☐	Type reference (TYPE)	/IWHDB/CL_HAI_RT_SQL_WRAPPER=>TT_ADBC_STMNT_PARAM			20131107
2	Exporting	EV_WHERE	Call by reference	☐	Type reference (TYPE)	STRING			20131107
3	Importing	IT_KEY_TAB	Call by reference	☑	Type reference (TYPE)	/IWBEP/T_MGW_TECH_PAIRS		table for name value pairs	20120229
4	Importing	IV_FILTER_STRING	Call by reference	☑	Type reference (TYPE)	STRING			20120229

Method GET_WHERE on class /IWHDB/CL_HAI_RT_QUERY_ADP has no exception.

Method HANDLE_SQL_EXCEPTION Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IO_SQL_EXCEPTION	Call by reference	☐	Object reference (TYPE REF TO)	CX_SQL_EXCEPTION		Exception Class for SQL Error	20120430

#	Exception	Resumable	Description	Created on
1	/IWBEP/CX_MGW_TECH_EXCEPTION	☐	Technical Exception	20120229

Method QUERY_VIEW Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	ER_RESULT_TAB	Call by reference	☐	Object reference (TYPE REF TO)	DATA			20120430
2	Exporting	ES_RESPONSE_CONTEXT	Call by reference	☐	Type reference (TYPE)	/IWBEP/IF_MGW_APPL_SRV_RUNTIME=>TY_S_MGW_RESPONSE_CONTEXT			20120330
3	Importing	IO_TECH_REQUEST_CONTEXT	Call by reference	☐	Object reference (TYPE REF TO)	/IWBEP/IF_MGW_REQ_ENTITYSET		Request Details for Read Feed	20120322
4	Importing	IR_RESULT_ROW	Call by reference	☐	Object reference (TYPE REF TO)	DATA			20120228
5	Importing	IV_CATALOG_NAME	Call by reference	☐	Type reference (TYPE)	STRING			20120228
6	Importing	IV_SKIPTOKEN_REC_NUM	Call by reference	☑	Type reference (TYPE)	I			20120412
7	Importing	IV_VIEW_NAME	Call by reference	☐	Type reference (TYPE)	STRING			20120228

#	Exception	Resumable	Description	Created on
1	/IWBEP/CX_MGW_TECH_EXCEPTION	☐	Technical Exception	20120229

Method QUERY_VIEW_ITEM Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	ER_RESULT_ROW	Call by reference	☐	Object reference (TYPE REF TO)	DATA			20120430
2	Importing	IO_TECH_REQUEST_CONTEXT	Call by reference	☐	Object reference (TYPE REF TO)	/IWBEP/IF_MGW_REQ_ENTITY		Request Details for Read Feed	20120404
3	Importing	IV_CATALOG_NAME	Call by reference	☐	Type reference (TYPE)	STRING			20120228
4	Importing	IV_VIEW_NAME	Call by reference	☐	Type reference (TYPE)	STRING			20120228

#	Exception	Resumable	Description	Created on
1	/IWBEP/CX_MGW_TECH_EXCEPTION	☐	Technical Exception	20120229

Method SET_QUERY_ROW_ID Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Changing	CS_RESULT_ROW	Call by reference	☐	Type reference (TYPE)	ANY			20120404
2	Importing	IT_SEL_TAB	Call by reference	☐	Type reference (TYPE)	STRING_TABLE		Table of Strings	20120404
3	Importing	IT_VIEW_PROPERTY	Call by reference	☐	Type reference (TYPE)	/IWHDB/T_HAI_RT_VCOL_TYPES		HANA View Column Types	20120404
4	Importing	IV_VIEW_NAME	Call by reference	☐	Type reference (TYPE)	STRING			20120919

Method SET_QUERY_ROW_ID on class /IWHDB/CL_HAI_RT_QUERY_ADP has no exception.

History

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