topic Re: File in Application Development and Automation Discussions

File

Former Member — Tue, 06 May 2008 00:07:44 GMT

Hi Guys

Any suggestion ....

Getting file from legacy and splitting in to six different files and putting in Application server.

It is taking 28 hours.....dont know why??

Using Open dataset and close dataset for 6 times for 6 files...

checking conditions before splitting...

Thanks in advance.

Re: File

Former Member — Tue, 06 May 2008 12:18:58 GMT

Hi,

First of all you need to check in the SE30 if there are performance problems about database access or others routines.

Regards,

Fernando

Re: File

Former Member — Tue, 06 May 2008 15:40:29 GMT

Analyze program via SM30 as mentioned in previous email. I would focus on type of internal tables used to manipulate data, i.e, standard tables can be "killers"; e.g., use sorted tables.

Re: File

valter_oliveira — Tue, 06 May 2008 16:30:37 GMT

Hello.

How big are your files? Consider separating in smaller ones ...

Use SM30 as already been told ... or debug it!

Best regards.

Valter Oliveira.

Re: File

Former Member — Sat, 10 May 2008 06:32:52 GMT

Hello krk,

Are you using US or NUS (Unicode, or not)?

For Unicode the file interface, the OPEN DATASET statement has been completely overhauled and the following enhancements added for US:

OPEN DATASET dsn IN TEXT MODE ......

OPEN DATASET dsn IN BINARY MODE......

OPEN DATASET dsn IN LEGACY TEXT MODE .......

OPEN DATASET dsn IN LEGACY BINARY MODE .......

I am not sure but I guess the Unicode concept "is able" to cause such trouble in uploading from the application server. Back in 2001 (no Unicode at this time) I had to upload more the 700,000 records, each about 1,000 Bytes long. There was no problem in uploading the data. My long runtime (28 hours) was more likely caused by inserting the data into SAP tables, even I used the Direct-Input technique (BDC took about 10 times as long).

Hope it helps!

Best wishes,

Heinz