Solved: Re: Large file upload

Former Member · ‎2004 Nov 22

Hi all,

Is there a way to upload a large file.

The problem:

1 file with fixed length records (59 bytes wide)

Over 17million lines available (actually a download from an extreme old system), making a total of almost 1Gb.

I have a database table that exactly machtes the record data.

So the question is: How to upload this amount of data. The normal upload functions do not apply because i run out of memory space (system I-MODE too large).

Regards,

Rob.

Former Member · ‎2004 Nov 22

Hi Rob,

I'm not too sure if this solution will be acceptable in your case, but here's one way that I can think of -

You can FTP this file to the Application Server and then process this file through a simple ABAP program and update the file's data to the desired database table.

Regards,

Anand Mandalika.

Former Member · ‎2004 Nov 22

Hi Rob,

I'm not too sure if this solution will be acceptable in your case, but here's one way that I can think of -

You can FTP this file to the Application Server and then process this file through a simple ABAP program and update the file's data to the desired database table.

Regards,

Anand Mandalika.

Former Member · ‎2004 Nov 22

Hi Rob,

with open dataset and read dataset, you can apply some logic to limit the number of records read into memory to a number you like and process the data in small packages.

regards

Siggi