Have you ever wanted to perform an ABAP Commit within ABAP Select Endselect statement. iF so you will have found that within a SELECT ENDSELECT you can not trigger an explicit commit otherwise you will get the DBIF_RSQL_INVALID_CURSOR error. <\/p>\n
The problem is if you do want to perform a commit every x number of records you need to exit the select..endselect do the commit and then somehow return to the record you left off at. The following example ABAP code allows you to do this using a cursor and a fetch statement.<\/p>\n
*&———————————————————————*
\n*& Report ZSELECT_CURSOR
\n*&
\n*&———————————————————————*
\n*&
\n*&
\n*&———————————————————————*
\nREPORT zselect_cursor.<\/p>\n
DATA: it_table TYPE STANDARD TABLE OF but000,
\n wa_table LIKE LINE OF it_table.<\/p>\n
DATA: ld_cursor TYPE cursor.<\/p>\n
PARAMETER: test AS CHECKBOX.<\/p>\n
SELECT *
\n FROM but000
\n INTO wa_table.<\/p>\n
” You can’t commit here within a select …endselect<\/p>\n
ENDSELECT.<\/p>\n
* Use OPEN cursor and fetch to be able to select records row by row
\n* or multiple rows at a time and perform a commit per fetch
\nOPEN CURSOR WITH HOLD ld_cursor FOR<\/p>\n
SELECT * FROM but000.
\nDO.
\n FETCH NEXT CURSOR ld_cursor
\n INTO TABLE it_table PACKAGE SIZE 1000.
\n IF sy-subrc <> 0.
\n EXIT.
\n ENDIF.<\/p>\n
* Do any updated here
\n ” LOOP AT it_table into wa_table.
\n ” modify…
\n ” ENDLOOP.
\n “CALL FUNCTION ‘DB_COMMIT’.
\n “COMMIT WORK.<\/p>\n
ENDDO.<\/p>\n
CLOSE CURSOR ld_cursor.<\/p>\n","protected":false},"excerpt":{"rendered":"
Have you ever wanted to perform an ABAP Commit within ABAP Select Endselect statement. iF so you will have found that within a SELECT ENDSELECT you can not trigger an explicit commit otherwise you will get the DBIF_RSQL_INVALID_CURSOR error. The problem is if you do want to perform a commit every x number of records […]<\/p>\n","protected":false},"author":1,"featured_media":2536,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[4],"tags":[],"yoast_head":"\n