ABAP Open/ Fetch Cursor

 The Open SQL statement OPEN CURSOR opens a database cursor for the result set of the main query defined after FOR and links a cursor variable dbcur with this database cursor. The results set of the main query can be read with the statement FETCH.

If the addition WITH HOLD is specified, the database cursor is not closed by a database commit executed using Native SQL.

Syntax

OPEN CURSOR [WITH HOLD] @dbcur|@DATA(dbcur) FOR
  [WITH
    +cte1 AS ( SELECT subquery_clauses )[,
    +cte2 AS ( SELECT subquery_clauses )
    ...]]
  SELECT mainquery_clauses
  [UNION ...]
  [UP TO ...] [OFFSET ...]
  [abap_options].


Fetch cursor

The Open SQL statement FETCH extracts the requested rows (using the addition INTO or APPENDING) from the results set of the database cursor (associated with the cursor variable dbcur) from the current cursor position and assigns these rows to the data objects specified in the results set.

FETCH NEXT CURSOR dbcur INTO|APPENDING ....


Comments

Post a Comment

Popular posts from this blog

FP_JOB_CLOSE throws an exception. (sy-subrc 2: system error)

Hi, We have a report which generates PDF documents. During the process the FM FP_JOB_CLOSE throws an exception. (sy-subrc 2: system error). Interesting part is that, it works fine in development and integration system. But throws this exception only in Q. Here is the error message i can see in debug mode: Reference :  https://community.sap.com/t5/application-development-and-automation-discussions/the-fm-fp-job-close-throws-error/td-p/12719075 Refer:   Usage and System Error in SAP Adobe Refer:  ADS: SOAP Runtime Exception: CSoapExceptionTransport :(100101) CX_FP_RUNTIME_SYSTEM ADS_NO_RESULT F23D9BD05B30754F85AE6E206713113B SPOOL_NO_XDC 74D76E3FEABD6C61E10000000A1550A8 ADS_ERROR 594E4D42A52F4778E10000000A1551FF RFC_ERROR C621084226C43C11E10000000A1551FF SOAP_ERROR B84D4D42A52F4778E10000000A1551FF CX_ROOT TEXTID B84D4D42A52F4778E10000000A1551FF PREVIOUS {O:INITIAL} KERNEL_ERRID IS_RESUMABLE CX_ROOT 16AA9A3937A9BB56E10000000A11447B INTERNAL_SOURCE_PO...
Read more

rough notes

Image
 BAL_DB_SEARCH      AIN -Asset Intelligence Network      /n/GRCPI/GRIA_EAM   https://community.sap.com/t5/technology-blogs-by-sap/benefit-from-sap-master-data-governance-on-sap-s-4hana-2023-feature-pack/ba-p/13808294 https://codesap.wordpress.com/2015/01/21/debug-smartforms-in-production-environment/   https://community.sap.com/t5/application-development-and-automation-blog-posts/debugging-smart-forms-in-production-environment/ba-p/13245694 https://sapcodes.com/2015/11/19/debugging-a-smartform/ https://codesap.wordpress.com/tag/debug-smartform/ https://www.indexit.org/how-to-debug-smartforms-in-sap-abap/ https://community.sap.com/t5/application-development-and-automation-discussions/how-to-delete-data-from-dynamic-internal-table/m-p/5345410 https://www.sapnet.ru/abap_docu/ABAPMODIFY_ITAB.htm#&ABAP_VARIANT_3@3@ ========================== Profile for Maintaining Task Lists   Relationships ==>The chronological order and time-based de...
Read more