Select Query !!!
Consider the following scenario.
A select query has to select very large amount of data from the table ( based on some condition ).
Now, because of that and also because of time taken in the network communication, the program is getting timed-out.
Is there any way in which we can select the data in <b>PACKETS</b> from the table WITHOUT CHANGING THE SELECT QUERY i.e. WITHOUT CHANGING THE WHERE CLAUSE ETC.
I repeat the requirement once more:
There should be no change in the select query except few minor changes which might be needed in the same as a part of the syntax.
Amit Mittal replied
1. U already have the answer.
2. The syntax is also very simple.
3. Just copy paste to get a taste of it.
DATA : t001 LIKE TABLE OF t001 WITH HEADER LINE.
DATA : ctr TYPE i.
PARAMETERS : a TYPE c.
<b>SELECT * FROM t001
INTO TABLE t001
PACKAGE SIZE 5 .</b>
ctr = ctr + 1.
WRITE :/ '----
Loop Pass # ' , ctr.
LOOP AT t001.
WRITE :/ t001-bukrs , t001-butxt.