topic Re: Large Table / Export with SQL into many little files in Application Development and Automation Discussions

Large Table / Export with SQL into many little files

Former Member — Sat, 06 Mar 2010 14:10:57 GMT

Hi@all,

at the moment we have a report which download many sap data tables into one big file for each table.

example: BSEG have 25 million records, so the file bseg.txt is maybe 20gigabyte large.

Is it possible to split this into 25 files with 1 million records? like "BSEG_001.txt, BSEG_002.txt...."

best regards,

alex

Re: Large Table / Export with SQL into many little files

venkat_o — Sat, 06 Mar 2010 16:24:41 GMT

Hi, <li>There is one statement called OPEN CURSOR , you can use that . <li>Try this test program.


 REPORT ztest_notepad.
DATA:it_nfal     TYPE STANDARD TABLE OF nfal WITH HEADER LINE.
DATA:c1          TYPE cursor.
DATA:flag        TYPE c.
DATA:no_of_lines TYPE i VALUE '1000'.

START-OF-SELECTION.
OPEN CURSOR:c1 FOR SELECT * FROM nfal.
DO.
  IF flag NE 'X'.
    FETCH NEXT CURSOR c1 APPENDING TABLE it_nfal PACKAGE SIZE no_of_lines.
    IF sy-subrc <> 0.
      CLOSE CURSOR c1.
      flag = 'X'.
    ENDIF.
  ENDIF.
  IF flag = 'X'.
    EXIT.
  ENDIF.
ENDDO.

Thanks Venkat.O

Re: Large Table / Export with SQL into many little files

Former Member — Sat, 06 Mar 2010 21:16:22 GMT

The OPEN CURSOR approach will run into difficulties if there are any COMMITs (may be implied) in the code.

Rob