Skip to Content
0
Former Member
Mar 24, 2006 at 12:36 PM

Fetching Millions of records

112 Views

Hi Friends,

I have a scenario where the following code is helpful.

DATA: BEGIN OF ztab_int OCCURS 0.

INCLUDE STRUCTURE ztab.

DATA: END OF ztab_int.

SELECT * FROM ztab INTO TABLE ztab_int PACKAGE SIZE 5000.

INSERT z_tab1 FROM TABLE ztab_int.

COMMIT WORK.

ENDSELECT.

But i have a doubt,first time it fetches the data it starts from 1 to 5000 ,but from the next time does it fetch 50001th record to 6000 and so on??

Please help me!

Thanks in adv.

Sandy