ABAPSELECT_EXTENDED_RESULT - SELECT EXTENDED RESULT

BAL_S_LOG - Application Log: Log header data   BAL Application Log Documentation  
This documentation is copyright by SAP AG.

SELECT, extended_result

Short Reference

... EXTENDED RESULT @oref ...

Effect

The EXTENDED RESULT addition of the INTO clause can be used to provide an extended result of the current main query in a result object. After EXTENDED RESULT, an object reference variable oref of static type for the documented class CL_OSQL_EXTENDED_RESULT must be specified as a host variable, which points to an object of the class. The reference variable must be prefixed with the escape character @.

The following applies to use of EXTENDED RESULT:

• The reference variable must not be initial, and the object must be created before execution of the statement. Parameters specifying which values the extended result should include must be passed to the instance constructor of class CL_OSQL_EXTENDED_RESULT.

• If possible, the result object is filled with the requested values at first database access.

• If a loop is opened with the statements SELECT or WITH, the result object is filled once when the loop is entered.

• If the INTO clause after FETCH is used for the result set of a database cursor that is opened with OPEN CURSOR, the result object is filled once in the first FETCH statement.

• After the statement is closed, the required values can be read using the instance methods of the class. If the result object does not then contain any results, or no valid results, an exception of the class CX_OSQL_EXTENDED_RESULT is raised.

Note

The addition EXTENDED RESULT can currently only be used for access to cached views of the SAP HANA database.

Example

Excerpt from the executable example SAP HANA, Cached Views.

rdisp/max_wprun_time - Maximum work process run time   CPI1466 during Backup  
This documentation is copyright by SAP AG.

Length: 3272 Date: 20230207 Time: 083443     sap01-206 ( 49 ms )