topic Re: Regarding Select condition in Application Development and Automation Discussions

Regarding Select condition

Former Member — Fri, 11 Jan 2008 07:03:52 GMT

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.

Re: Regarding Select condition

Former Member — Fri, 11 Jan 2008 07:05:43 GMT

Hi,

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

Regards,

Satish

Re: Regarding Select condition

Former Member — Fri, 11 Jan 2008 07:11:52 GMT

Hi Satish,

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

Re: Regarding Select condition

Former Member — Fri, 11 Jan 2008 09:14:01 GMT

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.

Re: Regarding Select condition

Former Member — Fri, 11 Jan 2008 09:19:28 GMT

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

Re: Regarding Select condition

Former Member — Wed, 16 Jan 2008 02:56:12 GMT

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?

Re: Regarding Select condition

Former Member — Wed, 16 Jan 2008 14:07:49 GMT

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

Rob