parallel processing of database

[Former Member]

hi friends.

if a internal table contains a lakh. how to divide into four and access it parallely. can anyone help. please send me the sample coding..

[Former Member]

hi,

u can write select statment like this and move into four different itab's .

select * from <databasetable> into <itab> upto 25 000 rows where condition.

and second one is..

select * from <databasetable> into <itab> where keyfield <b>ge</b> '25000' and keyfield <b>le</b> '50000'.

like this u can write for third and fourth.

reward points if useful,

regards,

seshu.

[Former Member]

hi ,

i have to update in a single internal table. do anyone have idea about that

[Former Member]

You are saying that u have an internal table containing a lakh records, and u want to distribute it into four internal tables(having the same structure of course)

[Former Member]

Take a read through SAP's program RUTBTPA0 - particularly the example code towards the bottom, and the comments which describes its use:

* Your program is suited for parallelization, if:
*   it determines a list of objects
*   and then loops over this list doing some function for each object
* Then you can start tasks in parallel each working on a subset
* of objects and finally merging the results of these tasks.

[Former Member]

hi tripat,

i saying that we are getting lakhs of record for the condition we are using.for that we have to check whether it is greater than lakh we have to divide it by 4 and access it with on internal table by processing 25000 at the same time it has to process from next record in the same internal table..