Regarding Select condition

[Former Member]

Hi all

I would like to transfer more than 50 lakhs records from more than six tables which shld be further processed.

I would like to have a optimized code so that it doesnt end with short dump.

[Former Member]

Hi,

In the select query specify the Package size as 5000 and fetch package by package.

Regards,

Satish

[Former Member]

Hi Satish,

I have used package size also. still its throughing short dump

[Former Member]

Hi,

You may use the above method itself. But the problem may be getting a timeout error. Ask your BASIS people to increase the time for some period.

Regards,

Renjith Michael.

[Former Member]

Hi Dhurga ,

can you elaborate your requirement. Is it possible to select data with more filters (Example : if you have 100 BUKRS, process data for 1 BUKRS at a time).

Regards,

Mohaiyuddin

[Former Member]

Hi,

I have to run my for code for more than 50 BURKS for a selected year.. I have to schedule it as a background job.So is it possible to optimize further?

[Former Member]

If you want any real help, you'll have to post the code.

Rob