SAP ABAP Class IF_TREX_SQL (ADBC based SQL interface)
Meta Relationship - Used By
| # | Relationship type | Used by | Short Description | Created on |
|---|---|---|---|---|
| 1 | Interface implementation (CLASS c. INTERFACES i_ref) | CL_TREX_SQL_PREPARED_STATEMENT | TREX SQL prepared statement. | 20100325 |
| 2 | Interface implementation (CLASS c. INTERFACES i_ref) | CL_TREX_SQL_STATEMENT | TREX SQL statement | 20100325 |
Properties
| Class | IF_TREX_SQL | |
| Short Description | ADBC based SQL interface | |
| Super Class | ||
| Instantiability of a Class | 2 | Public |
| Final |
General Data
| Message Class | ||
| Program status | ||
| Category | 0 | |
| Package | ||
| Created | 20100325 | SAP |
| Last change | 20140121 | SAP |
| Shared Memory-enabled | ||
| Fixed point arithmetic | ||
| Unicode checks active |
Forward declarations
| # | Type group / Object type | Type | Type Description |
|---|---|---|---|
| 1 |  ADBC |
Type group use (TYPE-POOLS tp) | Type group use (TYPE-POOLS tp) |
Interfaces
Class IF_TREX_SQL has no interface implemented.
Friends
Class IF_TREX_SQL has no friend class.
Attributes
| # | Attribute | Level | Visibility | Read only | Typing | Associated Type | Initial Value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 | C_PERF_ID_COMMIT |
Constant | Public | Type reference (TYPE) | STRING | 'COMMIT' | 20101104 | ||
| 2 | C_SQL_CODE_SYNTAX_ERROR |
Constant | Public | Type reference (TYPE) | INT4 | 257 | Natural number | 20110118 |
Methods
| # | Method | Level | Visibility | Method type | Description | Created on |
|---|---|---|---|---|---|---|
| 1 | CALL_WITH_XSTRING |
Instance method | Public | Method | 20100325 | |
| 2 | CLEAR_PARAMETERS |
Instance method | Public | Method | Only for prepare statement. | 20100325 |
| 3 | CLOSE |
Instance method | Public | Method | Only for prepare statement. | 20100325 |
| 4 | EXECUTE_DDL |
Instance method | Public | Method | 20100326 | |
| 5 | EXECUTE_PROCEDURE |
Instance method | Public | Method | 20110513 | |
| 6 | EXECUTE_QUERY_COUNT_ONLY |
Instance method | Public | Method | 20100325 | |
| 7 | EXECUTE_QUERY_ITAB |
Instance method | Public | Method | 20100325 | |
| 8 | EXECUTE_QUERY_SINGLE_FIELD |
Instance method | Public | Method | 20130424 | |
| 9 | EXECUTE_UPDATE |
Instance method | Public | Method | 20100325 | |
| 10 | SET_PARAM |
Instance method | Public | Method | 20100325 | |
| 11 | SET_PARAM_TABLE |
Instance method | Public | Method | 20130607 |
Events
Class IF_TREX_SQL has no event.
Types
Class IF_TREX_SQL has no local type.
Method Signatures
Method CALL_WITH_XSTRING Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 |  Importing |
FUNC_NAME | Call by reference | Type reference (TYPE) | CLIKE | 20100325 | |||
| 2 | Importing |
REQUEST_X | Call by reference | Type reference (TYPE) | XSEQUENCE | 20100325 | |||
| 3 |  Exporting |
RESPONSE_X | Call by reference | Type reference (TYPE) | XSEQUENCE | 20100325 |
| # | Exception | Resumable | Description | Created on |
|---|---|---|---|---|
| 1 |  CX_TREX_BAD_REQUEST |
20100325 | ||
| 2 | CX_TREX_REMOTE_COMMUNICATION |
20100325 | ||
| 3 | CX_TREX_SQL_EXCEPTION |
Exception Class for SQL Error | 20100902 |
Method CLEAR_PARAMETERS Signature
Method CLEAR_PARAMETERS on class IF_TREX_SQL has no parameter.
Method CLEAR_PARAMETERS on class IF_TREX_SQL has no exception.
Method CLOSE Signature
Method CLOSE on class IF_TREX_SQL has no parameter.
Method CLOSE on class IF_TREX_SQL has no exception.
Method EXECUTE_DDL Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Importing |
STATEMENT | Call by reference | Type reference (TYPE) | CSEQUENCE | 20100326 |
| # | Exception | Resumable | Description | Created on |
|---|---|---|---|---|
| 1 | CX_TREX_SQL_EXCEPTION |
Ausnahmeklasse für SQL Fehler | 20100622 |
Method EXECUTE_PROCEDURE 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 | 20110513 |
| # | Exception | Resumable | Description | Created on |
|---|---|---|---|---|
| 1 | CX_TREX_BAD_REQUEST |
Unexpected data received from application. | 20110513 | |
| 2 | CX_TREX_SQL_EXCEPTION |
TREX SQL exception | 20110513 |
Method EXECUTE_QUERY_COUNT_ONLY Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 |  Returning |
RVAL | Value transfer | Type reference (TYPE) | I | 20100325 | |||
| 2 | Importing |
STATEMENT | Call by reference | Type reference (TYPE) | CSEQUENCE | 20100325 |
| # | Exception | Resumable | Description | Created on |
|---|---|---|---|---|
| 1 | CX_TREX_SQL_EXCEPTION |
20100622 |
Method EXECUTE_QUERY_ITAB Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Importing |
CORRESPONDING_FIELDS | Call by reference | Type reference (TYPE) | ADBC_COLUMN_TAB | 20100325 | |||
| 2 | Exporting |
ITAB | Call by reference | Type reference (TYPE) | STANDARD TABLE | 20100325 | |||
| 3 | Importing |
LOB_FIELDS | Call by reference | Type reference (TYPE) | ADBC_COLUMN_TAB | 20101209 | |||
| 4 | Importing |
STATEMENT | Call by reference | Type reference (TYPE) | CSEQUENCE | 20100325 |
| # | Exception | Resumable | Description | Created on |
|---|---|---|---|---|
| 1 | CX_TREX_SQL_EXCEPTION |
20100622 |
Method EXECUTE_QUERY_SINGLE_FIELD Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Exporting |
RESULT | Call by reference | Type reference (TYPE) | ANY | 20130424 | |||
| 2 | Importing |
STATEMENT | Call by reference | Type reference (TYPE) | CSEQUENCE | 20130424 |
| # | Exception | Resumable | Description | Created on |
|---|---|---|---|---|
| 1 | CX_TREX_SQL_EXCEPTION |
TREX SQL exception | 20130424 |
Method EXECUTE_UPDATE Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Returning |
ROWS_PROCESSED | Value transfer | Type reference (TYPE) | I | 20100325 | |||
| 2 | Importing |
STATEMENT | Call by reference | Type reference (TYPE) | CSEQUENCE | 20100325 |
| # | Exception | Resumable | Description | Created on |
|---|---|---|---|---|
| 1 | CX_TREX_SQL_EXCEPTION |
Ausnahmeklasse für SQL Fehler | 20100622 |
Method SET_PARAM Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Importing |
DATA_REF | Call by reference | Object reference (TYPE REF TO) | DATA | 20100325 | |||
| 2 | Importing |
INOUT | Call by reference | Type reference (TYPE) | TYPINT1 | CL_SQL_STATEMENT=>C_PARAM_IN | Referenz-Datenelement "TYPINT1" zu DATLDREF | 20100325 |
Method SET_PARAM on class IF_TREX_SQL has no exception.
Method SET_PARAM_TABLE Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Importing |
TABLE_REF | Call by reference | Object reference (TYPE REF TO) | DATA | 20130607 |
| # | Exception | Resumable | Description | Created on |
|---|---|---|---|---|
| 1 | CX_PARAMETER_INVALID |
Superclass for Parameter Error | 20130607 |
History
| Last changed by/on | SAP | 20140121 |
| SAP Release Created in |
