topic Re: Package Size Statement in Application Development and Automation Discussions

Package Size Statement

Former Member — Wed, 18 Feb 2009 10:24:57 GMT

Hi Friends,

What is the advantage of using package size along with select querry or when do we use it?Pls brief with scenario.

Re: Package Size Statement

viquar_iqbal — Wed, 18 Feb 2009 10:26:03 GMT

Package size is use to allot an initial size to the internal table declared

Package size can be used to retreive a spcific number of records at a time. This can be used if you for example only want tofinish processing a limited amount of data at a time due to lack of memory.

Re: Package Size Statement

Former Member — Wed, 18 Feb 2009 10:26:50 GMT

Hi,

We will use package size so that we can send the data by peices.If we have large amount of data then define the packet size and send the data with that packet size.

Regards,

jaya

Re: Package Size Statement

Former Member — Wed, 18 Feb 2009 10:28:53 GMT

Hi,

package size give you initial memory size.

It is very usefull when you are fetching huge records to the internal table, in this case by this statement you can restrict dump which may occure due to table space overflow .

Thanks

Pinaki

Re: Package Size Statement

Former Member — Wed, 18 Feb 2009 10:29:21 GMT

Hi Hosmath,

Refer the following link:

Regards,

Nitin.

Re: Package Size Statement

Former Member — Wed, 18 Feb 2009 10:30:19 GMT

Hi,

if you use package size option in select, you have to use selecte-endselect compulsorily.

Package size determines the Total # of records that will be picked up in the First loop.

Regards

Rajesh Kumar

Re: Package Size Statement

Former Member — Wed, 18 Feb 2009 10:31:30 GMT

hi,

see this link

Package size only makes sense if there is another processing afterwards.

thanks

Re: Package Size Statement

Former Member — Wed, 18 Feb 2009 10:40:54 GMT

thanks friends,rewarded.