SAP ABAP Class CL_TREX_SQL_UTILITY (Tools for generating SQL statements)

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-TRX-API (Application Component) TREX ABAP + JAVA API
     ⤷ STREX (Package) TREX ABAP client

Properties

Class	CL_TREX_SQL_UTILITY
Short Description	Tools for generating SQL statements
Super Class
Instantiability of a Class	2	Public
Final	☑

General Data

Message Class
Program status
Category	0
Package	STREX	TREX ABAP client
Created	20100305	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)
3	CL_TREX_STRUCTURE	Forward declaration class (CLASS c DEFINITION DEFERRED)	Forward declaration class (CLASS c DEFINITION DEFERRED)
4	CL_TREX_USER_MANAGER	Forward declaration class (CLASS c DEFINITION DEFERRED)	Forward declaration class (CLASS c DEFINITION DEFERRED)

Interfaces

Class CL_TREX_SQL_UTILITY has no interface implemented.

Friends

Class CL_TREX_SQL_UTILITY has no friend class.

Attributes

Class CL_TREX_SQL_UTILITY has no attribute.

Methods

#	Method	Level	Visibility	Method type	Description	Created on
1	GET_BUILD_VERSION	Static method	Public	Method	Get build version	20130320
2	GET_BUILD_VERSION_FROM_DB	Static method	Private	Method	Get build version from database	20130320
3	GET_COLUMN_META	Static method	Private	Method	generate "col1 type1(length)"	20100428
4	GET_COLUMN_META_FOR_CREATE	Static method	Public	Method	generate "( col1 type1, col2 type2, ... )"	20100428
5	GET_COLUMN_ORDER_FOR_UPDATE	Static method	Public	Method	generate ("F1", "F2", ...) from component description	20101209
6	GET_FEATURE_VERSION	Static method	Public	Method	Get feature version from shared memory	20121008
7	GET_FEATURE_VERSION_FROM_DB	Static method	Private	Method	Get feature version from database	20121008
8	GET_FROM_TO	Static method	Public	Method	generate "LIMIT ... OFFSET ..."	20100312
9	GET_GROUP_BY	Static method	Public	Method		20101104
10	GET_HAVING	Static method	Public	Method	generate "HAVING..."	20101108
11	GET_HDB_DBSL_VERSION	Static method	Public	Method		20121129
12	GET_KEY_FIGURE	Static method	Public	Method		20101104
13	GET_NUMBER_OF_TABLE_KEYS	Static method	Public	Method	Get number of key fields of table.	20100714
14	GET_NUM_OF_DIFF_HOSTS_FROM_DB	Static method	Private	Method	Get number of different hosts from database	20121009
15	GET_ORDER_BY	Static method	Public	Method	generate "ORDER BY..."	20100309
16	GET_PTIME_TABLE_META	Static method	Public	Method	Get table meta information	20100609
17	GET_REQUESTED_COLUMNS	Static method	Public	Method	generate requested columns	20100309
18	GET_REQUESTED_COLUMNS2	Static method	Public	Method	generate requested columns from column meta	20100515
19	GET_SCHEMA_AND_TABLE_FROM_USER	Static method	Public	Method	Get schema and table/view names from user input	20120521
20	GET_SCHEMA_NAME	Static method	Public	Method	Get schema name from shared memory	20101104
21	GET_SCHEMA_NAME_FROM_DB	Static method	Private	Method	Get schema name from database	20101104
22	GET_SCHEMA_NAME_FROM_STRING	Static method	Private	Method	Get schema name from string value	20120520
23	GET_SCHEMA_NAME_FROM_USR_INPUT	Static method	Private	Method	Get schema name from table/view name enterd by user	20120520
24	GET_TABLE	Static method	Public	Method	generate table name	20100305
25	GET_TABLE_GROUP	Static method	Public	Method	Get table group	20130506
26	GET_TABLE_KEYS	Static method	Public	Method	Get key fields of table	20100609
27	GET_UPDATESET_FOR_PREPARE	Static method	Public	Method	generate "SET = ?, = ?, ..."	20100714
28	GET_VALUES_FOR_PREPARE	Static method	Public	Method	generate "VALUES ( ?, ?, ....)"	20100326
29	GET_VALUES_FROM_WA	Static method	Public	Method	generate "VALUES ( val1, val2, ....)"	20100406
30	GET_WHERE_CLAUSE	Static method	Public	Method	generate where clause ("WHERE" is not set)	20100305
31	GET_WHERE_CLAUSE_BETWEEN	Static method	Private	Method	generate where clause for BETWEEN	20100308
32	GET_WHERE_CLAUSE_FOR_PREPARE	Static method	Public	Method	genetate "where = ? and field2 = ? or ..."	20100328
33	GET_WHERE_CLAUSE_IN	Static method	Public	Method	generate where in (v1, v2,...)	20110207
34	GET_WHERE_CLAUSE_PATTERN	Static method	Public	Method	generate where in (v1, v2,..) or like 'V3%'	20120322
35	GET_WHERE_FROM_QUERY_ENTRY	Static method	Public	Method	generate where clause from query entry ("WHERE" is set)	20100308
36	GET_WITH_PARAMETERS	Static method	Public	Method	generate "WITH PARAMETERS..."	20100320
37	IS_SCALE_OUT	Static method	Public	Method	True: HANA is scale-out.	20121005
38	TEST_DB_CON	Static method	Public	Method		20101104

Events

Class CL_TREX_SQL_UTILITY has no event.

Types

Class CL_TREX_SQL_UTILITY has no local type.

Method Signatures

Method GET_BUILD_VERSION Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	BUILD_VERSION	Call by reference	☐	Type reference (TYPE)	HDBS_BUILD_VERSION		HANA: Build version	20130320
2	Importing	BYPASSING_BUFFER	Call by reference	☐	Type reference (TYPE)	ABAP_BOOL	ABAP_FALSE	X: ignore to look at shared memory	20130320
3	Importing	CON_NAME	Call by reference	☐	Type reference (TYPE)	CLIKE	CL_TREX_USER_MANAGER=>HDB_DBSL_CON		20130320
4	Exporting	RESULT_FROM_MEMORY	Call by reference	☐	Type reference (TYPE)	ABAP_BOOL		X: result came from shared memory	20130320

#	Exception	Resumable	Description	Created on
1	CX_HDB_ABAP_CLIENT_SHM_ERROR	☐	Shared memory error for HDB ABAP Client	20130403
2	CX_TREX_REMOTE_COMMUNICATION	☐	Remote Communication Exception	20130403

Method GET_BUILD_VERSION_FROM_DB Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	AS_STRING	Call by reference	☐	Type reference (TYPE)	ABAP_BOOL	ABAP_FALSE	True: set value also to BUILD_VERSION_STRING as string	20130402
2	Exporting	BUILD_VERSION	Call by reference	☐	Type reference (TYPE)	HDBS_BUILD_VERSION		HANA: Build version	20130320
3	Exporting	BUILD_VERSION_STRING	Call by reference	☐	Type reference (TYPE)	STRING		Build version as string	20130402
4	Importing	CON_NAME	Call by reference	☑	Type reference (TYPE)	CLIKE			20130320

#	Exception	Resumable	Description	Created on
1	CX_TREX_BAD_REQUEST	☐	Unexpected data received from application.	20130320
2	CX_TREX_REMOTE_INITIALIZATION	☐	Failed to Initialize Remote Communication	20130320
3	CX_TREX_SQL_EXCEPTION	☐	TREX SQL exception	20130320

Method GET_COLUMN_META Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	META_DATA	Call by reference	☐	Type reference (TYPE)	TREXS_TABLE_METADATA		PTIME table meta data	20100428
2	Returning	RVAL	Value transfer	☐	Type reference (TYPE)	STRING			20100428

#	Exception	Resumable	Description	Created on
1	CX_TREX_UNEXPECTED_DATA_TYPE	☐	Unexpected data type received.	20100428

Method GET_COLUMN_META_FOR_CREATE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	METADATA_TABLE	Call by reference	☐	Type reference (TYPE)	TREXT_TABLE_METADATA		Table type for PTIME table meta data	20100428
2	Returning	RVAL	Value transfer	☐	Type reference (TYPE)	STRING			20100428

#	Exception	Resumable	Description	Created on
1	CX_TREX_UNEXPECTED_DATA_TYPE	☐	Unexpected data type received.	20100428

Method GET_COLUMN_ORDER_FOR_UPDATE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	COMP_DESCRS	Call by reference	☐	Type reference (TYPE)	TREXT_COMP_DESCR		Description of the components	20101209
2	Returning	RVAL	Value transfer	☐	Type reference (TYPE)	STRING			20101209

Method GET_COLUMN_ORDER_FOR_UPDATE on class CL_TREX_SQL_UTILITY has no exception.

Method GET_FEATURE_VERSION Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	BYPASSING_BUFFER	Call by reference	☐	Type reference (TYPE)	ABAP_BOOL	ABAP_FALSE	X: ignore to look at shared memory	20121008
2	Importing	COMPONENT_NAME	Call by reference	☐	Type reference (TYPE)	CSEQUENCE			20121008
3	Importing	CON_NAME	Call by reference	☐	Type reference (TYPE)	CLIKE	CL_TREX_USER_MANAGER=>HDB_DBSL_CON		20121008
4	Importing	FEATURE_NAME	Call by reference	☐	Type reference (TYPE)	CSEQUENCE			20121008
5	Exporting	RESULT_FROM_MEMORY	Call by reference	☐	Type reference (TYPE)	ABAP_BOOL		X: result came from shared memory	20121008
6	Exporting	VERSION	Call by reference	☐	Type reference (TYPE)	I			20121008

#	Exception	Resumable	Description	Created on
1	CX_HDB_ABAP_CLIENT_SHM_ERROR	☐	Shared memory error for HDB ABAP Client	20121008
2	CX_TREX_REMOTE_COMMUNICATION	☐	Remote Communication Exception	20121008

Method GET_FEATURE_VERSION_FROM_DB Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	COMPONENT_NAME	Call by reference	☐	Type reference (TYPE)	CSEQUENCE			20121008
2	Importing	CON_NAME	Call by reference	☑	Type reference (TYPE)	CLIKE			20121008
3	Importing	FEATURE_NAME	Call by reference	☐	Type reference (TYPE)	CSEQUENCE			20121008
4	Returning	VERSION	Value transfer	☐	Type reference (TYPE)	I			20121008

#	Exception	Resumable	Description	Created on
1	CX_TREX_BAD_REQUEST	☐	Unexpected data received from application.	20121008
2	CX_TREX_REMOTE_INITIALIZATION	☐	Failed to Initialize Remote Communication	20121008
3	CX_TREX_SQL_EXCEPTION	☐	TREX SQL exception	20121008

Method GET_FROM_TO Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	RESULT_FROM	Call by reference	☐	Type reference (TYPE)	I			20100312
2	Importing	RESULT_TO	Call by reference	☐	Type reference (TYPE)	I			20100312
3	Returning	RVAL	Value transfer	☐	Type reference (TYPE)	STRING			20100312

Method GET_FROM_TO on class CL_TREX_SQL_UTILITY has no exception.

Method GET_GROUP_BY Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	GROUP_COLUMNS	Call by reference	☐	Type reference (TYPE)	CLIKE		columns separated by space	20101104
2	Returning	RVAL	Value transfer	☐	Type reference (TYPE)	STRING			20101104

Method GET_GROUP_BY on class CL_TREX_SQL_UTILITY has no exception.

Method GET_HAVING Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	HAVING_FILTER	Call by reference	☐	Type reference (TYPE)	CLIKE			20101108
2	Returning	RVAL	Value transfer	☐	Type reference (TYPE)	STRING			20101108

Method GET_HAVING on class CL_TREX_SQL_UTILITY has no exception.

Method GET_HDB_DBSL_VERSION Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	CON_NAME	Call by reference	☑	Type reference (TYPE)	DBCON_NAME		Logical name for a database connection	20121130
2	Exporting	PATCH	Call by reference	☐	Type reference (TYPE)	INT2		HDB DBSL Patch Level	20121129
3	Exporting	VERSION	Call by reference	☐	Type reference (TYPE)	INT2		HDB DBSL Version	20121129

#	Exception	Resumable	Description	Created on
1	CX_HDB_CONNECTION_NOT_FOUND	☐	DB connection does not exist.	20121129

Method GET_KEY_FIGURE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	KEY_FIGURE	Call by reference	☐	Type reference (TYPE)	TREXS_KEY_FIGURE			20101104
2	Returning	RVAL	Value transfer	☐	Type reference (TYPE)	STRING			20101104

#	Exception	Resumable	Description	Created on
1	CX_TREX_BAD_REQUEST	☐		20101104

Method GET_NUMBER_OF_TABLE_KEYS Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Returning	NUM_OF_KEYS	Value transfer	☐	Type reference (TYPE)	INT4		Natural number	20100714
2	Importing	TABLE_NAME	Call by reference	☐	Type reference (TYPE)	CLIKE			20100714

#	Exception	Resumable	Description	Created on
1	CX_TREX_BAD_REQUEST	☐	Unexpected data received from application.	20100714
2	CX_TREX_REMOTE_INITIALIZATION	☐	Failed to Initialize Remote Communication	20100714
3	CX_TREX_SQL_EXCEPTION	☐	TREX SQL exception	20100714

Method GET_NUM_OF_DIFF_HOSTS_FROM_DB Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	CON_NAME	Call by reference	☑	Type reference (TYPE)	CLIKE			20121009
2	Returning	RVAL	Value transfer	☐	Type reference (TYPE)	I			20121009

#	Exception	Resumable	Description	Created on
1	CX_TREX_BAD_REQUEST	☐	Unexpected data received from application.	20121009
2	CX_TREX_REMOTE_INITIALIZATION	☐	Failed to Initialize Remote Communication	20121009
3	CX_TREX_SQL_EXCEPTION	☐	TREX SQL exception	20121009

Method GET_ORDER_BY Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Returning	RVAL	Value transfer	☐	Type reference (TYPE)	STRING			20100309
2	Importing	SORT_COLUMNS	Call by reference	☐	Type reference (TYPE)	TREXT_SORT_ATTRIBUTES			20101104

Method GET_ORDER_BY on class CL_TREX_SQL_UTILITY has no exception.

Method GET_PTIME_TABLE_META Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Returning	RVAL	Value transfer	☐	Type reference (TYPE)	TREXT_TABLE_METADATA		Table type for PTIME table meta data	20100609
2	Importing	SCHEMA_NAME	Call by reference	☑	Type reference (TYPE)	CLIKE			20131024
3	Importing	TABLE_NAME	Call by reference	☐	Type reference (TYPE)	CLIKE			20100609

#	Exception	Resumable	Description	Created on
1	CX_TREX_BAD_REQUEST	☐	Unexpected data received from application.	20100609
2	CX_TREX_REMOTE_INITIALIZATION	☐	Failed to Initialize Remote Communication	20100609
3	CX_TREX_SQL_EXCEPTION	☐	Exception Class for SQL Error	20100622

Method GET_REQUESTED_COLUMNS Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	ATTRIBUTE_MAP	Call by reference	☑	Type reference (TYPE)	CL_TREX_STRUCTURE=>T_ATTRIBUTE_MAP			20101104
2	Importing	COLUMN_METAS	Call by reference	☑	Type reference (TYPE)	CL_TREX_STRUCTURE=>T_COLUMN_METAS			20100514
3	Importing	REQUESTED_COLUMNS	Call by reference	☐	Type reference (TYPE)	TREXT_JOIN_ATTRIBUTES		Attributes with indexId and join path	20100309
4	Returning	RVAL	Value transfer	☐	Type reference (TYPE)	STRING			20100309

Method GET_REQUESTED_COLUMNS on class CL_TREX_SQL_UTILITY has no exception.

Method GET_REQUESTED_COLUMNS2 Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	ATTRIBUTE_MAP	Call by reference	☑	Type reference (TYPE)	CL_TREX_STRUCTURE=>T_ATTRIBUTE_MAP			20101104
2	Importing	COLUMN_METAS	Call by reference	☐	Type reference (TYPE)	CL_TREX_STRUCTURE=>T_COLUMN_METAS			20100515
3	Returning	RVAL	Value transfer	☐	Type reference (TYPE)	STRING			20100515
4	Importing	TABLE_META	Call by reference	☑	Type reference (TYPE)	TREXT_TABLE_METADATA			20101209

Method GET_REQUESTED_COLUMNS2 on class CL_TREX_SQL_UTILITY has no exception.

Method GET_SCHEMA_AND_TABLE_FROM_USER Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	CON_NAME	Call by reference	☐	Type reference (TYPE)	CLIKE	CL_TREX_USER_MANAGER=>HDB_DBSL_CON		20120521
2	Importing	DATA	Call by reference	☐	Type reference (TYPE)	CSEQUENCE			20120521
3	Exporting	OBJECT_NAME	Call by reference	☐	Type reference (TYPE)	STRING		table or view name	20120521
4	Exporting	SCHEMA_NAME	Call by reference	☐	Type reference (TYPE)	STRING		schema name	20120521

#	Exception	Resumable	Description	Created on
1	CX_HDB_ABAP_CLIENT_SHM_ERROR	☐	Shared memory error for HDB ABAP Client	20120521
2	CX_TREX_REMOTE_COMMUNICATION	☐	Remote Communication Exception	20120521

Method GET_SCHEMA_NAME Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	BYPASSING_BUFFER	Call by reference	☐	Type reference (TYPE)	ABAP_BOOL	ABAP_FALSE	X: ignore to look at shared memory	20101104
2	Importing	CON_NAME	Call by reference	☐	Type reference (TYPE)	CLIKE	CL_TREX_USER_MANAGER=>HDB_DBSL_CON		20101104
3	Exporting	RESULT_FROM_MEMORY	Call by reference	☐	Type reference (TYPE)	ABAP_BOOL		X: result came from shared memory	20101104
4	Exporting	SCHEMA_NAME	Call by reference	☐	Type reference (TYPE)	STRING			20101104

#	Exception	Resumable	Description	Created on
1	CX_HDB_ABAP_CLIENT_SHM_ERROR	☐	Shared memory error for HDB ABAP Client	20101104
2	CX_TREX_REMOTE_COMMUNICATION	☐	Remote Communication Exception	20110711

Method GET_SCHEMA_NAME_FROM_DB Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	CON_NAME	Call by reference	☑	Type reference (TYPE)	CLIKE		Logical name for a database connection	20101104
2	Returning	RVAL	Value transfer	☐	Type reference (TYPE)	STRING			20101104

#	Exception	Resumable	Description	Created on
1	CX_TREX_BAD_REQUEST	☐	Unexpected data received from application.	20101104
2	CX_TREX_REMOTE_INITIALIZATION	☐	Failed to Initialize Remote Communication	20101104
3	CX_TREX_SQL_EXCEPTION	☐	TREX SQL exception	20101104

Method GET_SCHEMA_NAME_FROM_STRING Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	DATA	Call by reference	☐	Type reference (TYPE)	CSEQUENCE			20120520
2	Returning	SCHEMA_NAME	Value transfer	☐	Type reference (TYPE)	STRING			20120520

Method GET_SCHEMA_NAME_FROM_STRING on class CL_TREX_SQL_UTILITY has no exception.

Method GET_SCHEMA_NAME_FROM_USR_INPUT Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	CON_NAME	Call by reference	☐	Type reference (TYPE)	CLIKE	CL_TREX_USER_MANAGER=>HDB_DBSL_CON	connection name	20120520
2	Importing	OBJECT_NAME	Call by reference	☐	Type reference (TYPE)	CSEQUENCE		table or view name	20120521
3	Returning	SCHEMA_NAME	Value transfer	☐	Type reference (TYPE)	STRING			20120520

#	Exception	Resumable	Description	Created on
1	CX_HDB_ABAP_CLIENT_SHM_ERROR	☐	Shared memory error for HDB ABAP Client	20120520
2	CX_TREX_REMOTE_COMMUNICATION	☐	Remote Communication Exception	20120520

Method GET_TABLE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Returning	RVAL	Value transfer	☐	Type reference (TYPE)	STRING			20100305
2	Importing	SCHEMA_NAME	Call by reference	☑	Type reference (TYPE)	CSEQUENCE		schema name	20130313
3	Importing	TABLE_NAME	Call by reference	☐	Type reference (TYPE)	CLIKE		table name (index id)	20100305

Method GET_TABLE on class CL_TREX_SQL_UTILITY has no exception.

Method GET_TABLE_GROUP Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	SCHEMA_NAME	Call by reference	☑	Type reference (TYPE)	CSEQUENCE			20130506
2	Returning	TABLE_GROUP	Value transfer	☐	Type reference (TYPE)	HDBS_TABLE_GROUP		HANA: table group	20130506
3	Importing	TABLE_NAME	Call by reference	☐	Type reference (TYPE)	CSEQUENCE			20130506

#	Exception	Resumable	Description	Created on
1	CX_HDB_ABAP_CLIENT_SHM_ERROR	☐	Shared memory error for HDB ABAP Client	20130506
2	CX_TREX_BAD_REQUEST	☐	Unexpected data received from application.	20130506
3	CX_TREX_REMOTE_COMMUNICATION	☐	Remote Communication Exception	20130506
4	CX_TREX_REMOTE_INITIALIZATION	☐	Failed to Initialize Remote Communication	20130506
5	CX_TREX_SQL_EXCEPTION	☐	TREX SQL exception	20130506

Method GET_TABLE_KEYS Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Returning	KEYS	Value transfer	☐	Type reference (TYPE)	TREXT_ATTRIBUTES		Attributes	20100609
2	Importing	TABLE_NAME	Call by reference	☐	Type reference (TYPE)	CLIKE			20100609

#	Exception	Resumable	Description	Created on
1	CX_HDB_ABAP_CLIENT_SHM_ERROR	☐	Shared memory error for HDB ABAP Client	20101108
2	CX_TREX_BAD_REQUEST	☐	Unexpected data received from application.	20100609
3	CX_TREX_REMOTE_COMMUNICATION	☐	Remote Communication Exception	20110711
4	CX_TREX_SQL_EXCEPTION	☐	Exception Class for SQL Error	20100622

Method GET_UPDATESET_FOR_PREPARE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	COLUMN_LIST	Call by reference	☐	Type reference (TYPE)	TREXT_ATTRIBUTES		Attributes	20100714
2	Returning	RVAL	Value transfer	☐	Type reference (TYPE)	STRING			20100714

#	Exception	Resumable	Description	Created on
1	CX_TREX_BAD_REQUEST	☐	Unexpected data received from application.	20100714

Method GET_VALUES_FOR_PREPARE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	NUMBER_OF_VALUES	Call by reference	☐	Type reference (TYPE)	I			20100326
2	Returning	RVAL	Value transfer	☐	Type reference (TYPE)	STRING			20100326
3	Importing	SQL_OPTIONS	Call by reference	☑	Type reference (TYPE)	TREXT_SQL_OPTION		List of SQL options	20100624

Method GET_VALUES_FOR_PREPARE on class CL_TREX_SQL_UTILITY has no exception.

Method GET_VALUES_FROM_WA Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Returning	RVAL	Value transfer	☐	Type reference (TYPE)	STRING			20100406
2	Importing	WA	Call by reference	☐	Type reference (TYPE)	ANY			20100406

#	Exception	Resumable	Description	Created on
1	CX_TREX_UNEXPECTED_DATA_TYPE	☐	Unexpected data type received.	20100406

Method GET_WHERE_CLAUSE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	COLUMN_NAME	Call by reference	☐	Type reference (TYPE)	CLIKE			20100305
2	Importing	CONTENT_TYPE	Call by reference	☑	Type reference (TYPE)	TREXD_CONTENT_TYPE		Content type	20110207
3	Importing	IS_PREDICATE	Call by reference	☐	Type reference (TYPE)	NUM1	0		20101104
4	Importing	OPERATOR	Call by reference	☐	Type reference (TYPE)	CLIKE	'='		20100305
5	Returning	RVAL	Value transfer	☐	Type reference (TYPE)	STRING			20100305
6	Importing	VALUE	Call by reference	☐	Type reference (TYPE)	CLIKE			20100305
7	Importing	VALUE2	Call by reference	☑	Type reference (TYPE)	CLIKE		only for BETWEEN operator	20100616

Method GET_WHERE_CLAUSE on class CL_TREX_SQL_UTILITY has no exception.

Method GET_WHERE_CLAUSE_BETWEEN Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	COLUMN_NAME	Call by reference	☐	Type reference (TYPE)	CLIKE			20100308
2	Importing	NOT_BETWEEN	Call by reference	☐	Type reference (TYPE)	ABAP_BOOL	ABAP_FALSE		20100308
3	Returning	RVAL	Value transfer	☐	Type reference (TYPE)	STRING			20100308
4	Importing	VALUE1	Call by reference	☐	Type reference (TYPE)	CLIKE			20100308
5	Importing	VALUE2	Call by reference	☐	Type reference (TYPE)	CLIKE			20100308

Method GET_WHERE_CLAUSE_BETWEEN on class CL_TREX_SQL_UTILITY has no exception.

Method GET_WHERE_CLAUSE_FOR_PREPARE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	QUERY_ENTRY	Call by reference	☐	Type reference (TYPE)	TREXT_QUERY_ENTRIES		Search query	20130712
2	Returning	RVAL	Value transfer	☐	Type reference (TYPE)	STRING			20100328

#	Exception	Resumable	Description	Created on
1	CX_TREX_BAD_REQUEST	☐	Unexpected data received from application.	20130712

Method GET_WHERE_CLAUSE_IN Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	COLUMN_NAME	Call by reference	☐	Type reference (TYPE)	CLIKE			20110207
2	Returning	RVAL	Value transfer	☐	Type reference (TYPE)	STRING			20110207
3	Importing	VALUE1	Call by reference	☐	Type reference (TYPE)	CLIKE			20110207

Method GET_WHERE_CLAUSE_IN on class CL_TREX_SQL_UTILITY has no exception.

Method GET_WHERE_CLAUSE_PATTERN Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	COLUMN_NAME	Call by reference	☐	Type reference (TYPE)	CLIKE			20120322
2	Importing	DELIMITER	Call by reference	☐	Type reference (TYPE)	CHAR1	' '	Single-Character Flag	20120322
3	Importing	PATTERN	Call by reference	☐	Type reference (TYPE)	CLIKE	'*'		20120322
4	Returning	RVAL	Value transfer	☐	Type reference (TYPE)	STRING			20120322

Method GET_WHERE_CLAUSE_PATTERN on class CL_TREX_SQL_UTILITY has no exception.

Method GET_WHERE_FROM_QUERY_ENTRY Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	QUERY_ENTRY	Call by reference	☐	Type reference (TYPE)	TREXT_QUERY_ENTRIES		Search query	20100308
2	Returning	RVAL	Value transfer	☐	Type reference (TYPE)	STRING			20100308

#	Exception	Resumable	Description	Created on
1	CX_TREX_BAD_REQUEST	☐	Unexpected data received from application.	20100318

Method GET_WITH_PARAMETERS Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	PARAMETER_VALUE_TABLE	Call by reference	☐	Type reference (TYPE)	TREXT_PARAMETER_VALUE		Parameters and its values	20100920
2	Returning	RVAL	Value transfer	☐	Type reference (TYPE)	STRING			20100320

Method GET_WITH_PARAMETERS on class CL_TREX_SQL_UTILITY has no exception.

Method IS_SCALE_OUT Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	BYPASSING_BUFFER	Call by reference	☐	Type reference (TYPE)	ABAP_BOOL	ABAP_FALSE		20121009
2	Importing	CON_NAME	Call by reference	☐	Type reference (TYPE)	CLIKE	CL_TREX_USER_MANAGER=>HDB_DBSL_CON		20121005
3	Exporting	IS_SCALEOUT	Call by reference	☐	Type reference (TYPE)	ABAP_BOOL		X: HANA is scale-out	20121009
4	Exporting	RESULT_FROM_MEMORY	Call by reference	☐	Type reference (TYPE)	ABAP_BOOL		X: result came from shared memory	20121009

#	Exception	Resumable	Description	Created on
1	CX_HDB_ABAP_CLIENT_SHM_ERROR	☐	Shared memory error for HDB ABAP Client	20121009
2	CX_TREX_REMOTE_COMMUNICATION	☐	Remote Communication Exception	20121009

Method TEST_DB_CON Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	CONNECTION_NAME	Call by reference	☑	Type reference (TYPE)	CLIKE			20101104
2	Returning	RVAL	Value transfer	☐	Type reference (TYPE)	ABAP_BOOL			20101104

#	Exception	Resumable	Description	Created on
1	CX_TREX_BAD_REQUEST	☐		20101104

History

Last changed by/on	SAP	20141121
SAP Release Created in	72L