topic Re: Using Cursors in Application Development and Automation Discussions

Using Cursors

Former Member — Sat, 06 Oct 2007 23:39:48 GMT

Hello,

Can anyone tell me how to use cursors. I have a table with 1 million records,

I need to process 100000 records each time my select statement executes, process those records ,and get the next 100000.

Thanks, points are awarded

Former Member — Sat, 06 Oct 2007 23:54:09 GMT

Use the "package size" addition to limit how many records you want to process at one time in the select.

eg.

SELECT *

FROM vbak

INTO TABLE lt_vbak PACKAGE SIZE 100000.

ENDSELECT.

Former Member — Sun, 07 Oct 2007 01:15:07 GMT

DATA: lv_cursor TYPE cursor.

OPEN CURSOR WITH HOLD lv_cursor

FOR SELECT * FROM <table>

WHERE ...

DO.

FETCH NEXT CURSOR lv_cursor

INTO TABLE itab

PACKAGE SIZE 100000.

IF sy-subrc <> 0.

CLOSE CURSOR lv_cursor.

EXIT.

ENDIF.

...

ENDDO.