SAP Function STU3_ADMIN_SELECT_SQL_REMOTE - Execute a select statement for a remote connection

Parameter Reference Type Length Default Optional Text
CON_NAME DBCON-CON_NAME C 30 X Logical name for a database connection
DISTINCT ABAP_BOOL 0 X Specify DISTINCT in SELECT clause
DO_NOT_CLOSE_CON FLAG C 1 X General Flag
SCHEMA DB2CREATOR C 8 X Schema
TABNAME TABNAME C 30 Table Name for Select
TABSTRUC DD02L-TABNAME C 30 DDIC Definition of select table
UPTO_ROWS I I 4 X Number of rows to fetch
WHERE_CLAUSE DB2WHERE_T h 80 X Lines for WHERE Clause

Parameter Reference Type Length Text
RESULT REF TO DATA 0 Reference to Result itab

Parameter Reference Type Length Default Optional Text
CON_REF REF TO CL_SQL_CONNECTION 0 X Database Connection

Parameter Reference Length Optional Text
SELECT_LIST ADBC_TABCOL_DESCR_TAB 0 X Set of columns for SELECT clause with DISTINCT

Exception Text
ADBC_SQL_ERROR
DB_CON_NOT_ESTABLISHED Could not establish a DB connection