topic DUMP in select query in Application Development and Automation Discussions

DUMP in select query

Former Member — Wed, 18 Nov 2009 06:34:43 GMT

Hi friends,

I have one problem , I am IDoc information from EDIDC table for one year EDIDC have more 500000 records, my selet query going dump . could you please help me how to avoid this dump.

Regards,

jayachandran

Re: DUMP in select query

Former Member — Wed, 18 Nov 2009 06:45:11 GMT

Hi Jayachandran

Try using PACKAGE SIZE Option in your select query.

Regards

Bala

Re: DUMP in select query

Former Member — Wed, 18 Nov 2009 06:50:12 GMT

Use the package size option in the select statement while retrieving the data from table.

Sample code

SELECT * FROM EDIDC
                   PACKAGE SIZE 10000
                  APPENDING TABLE itab.    
            
              ENDSELECT.

Regards,

Srinivas.P.

Re: DUMP in select query

Former Member — Wed, 18 Nov 2009 11:26:37 GMT

Hello Jai,

You can do it in following ways:

1. Do not use '*' instead use key field or the required one.

2. Use package size

3. Use into table instead of row by row transfer.

Thanks,

Augustin.