SAP ABAP Function Module STU3_ADMIN_SELECT_SQL_REMOTE (Execute a select statement for a remote connection)

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-DB-DB2 (Application Component) DB2 for z/OS
     ⤷ STU3 (Package) Development Class for Database Monitor

Basic Data

Function Module	STU3_ADMIN_SELECT_SQL_REMOTE	Execute a select statement for a remote connection
Function Group	STU3_ADMIN	SAP Collector administration functions
Program Name	SAPLSTU3_ADMIN
INCLUDE Name	LSTU3_ADMINU26

Parameters

Type	Parameter Name	Typing	Associated Type	Default value	Optional	Pass Value	Short text
Changing	CON_REF	TYPE REF TO	CL_SQL_CONNECTION		☑	☐	Database Connection
Exporting	RESULT	TYPE REF TO	DATA		☐	☐	Reference to Result itab
Exporting	SQLERR_REF	TYPE REF TO	CX_SQL_EXCEPTION		☐	☐	Exception Class for SQL Error
Importing	CON_NAME	TYPE	DBCON-CON_NAME		☑	☐	Logical name for a database connection
Importing	SCHEMA	TYPE	DB2CREATOR		☑	☑	Schema
Importing	TABNAME	TYPE	TABNAME		☐	☐	Table Name for Select
Importing	TABSTRUC	TYPE	DD02L-TABNAME		☐	☐	DDIC Definition of select table
Importing	WHERE_CLAUSE	TYPE	DB2WHERE_T		☑	☐	Lines for WHERE Clause
Importing	DO_NOT_CLOSE_CON	TYPE	FLAG		☑	☐	General Flag
Importing	UPTO_ROWS	TYPE	I		☑	☐	Number of rows to fetch
Importing	DISTINCT	TYPE	ABAP_BOOL		☑	☑	Specify DISTINCT in SELECT clause
Importing	REPORT_ERROR_TO_SYSLOG	TYPE	ABAP_BOOL	ABAP_TRUE	☑	☐
Tables	SELECT_LIST	TYPE	ADBC_TABCOL_DESCR_TAB		☑	☐	Set of columns for SELECT clause with DISTINCT
Exception	ADBC_SQL_ERROR	TYPE			☐	☐
Exception	DB_CON_NOT_ESTABLISHED	TYPE			☐	☐	Could not establish a DB connection
Exception	INTERNAL_ERROR	TYPE			☐	☐

Processing Type

☑ Normal Function Module
☐ Remote-Enabled Module	☐ BaseXML supported
☐ Update Module	☑ Start immediately
	☐ Immediate Start, No Restart
	☐ Start Delayed
	☐ Coll.run
☐ JAVA Module Callable from ABAP
☐ Remote-Enabled JAVA Module
☐ Module Callable from JAVA

History

Last changed by/on	SAP	20041219
SAP Release Created in	620