Hi,

Here i am giving the procedure , how to make the table into 
half..... using program... I dont know whether any direct 
SQL command is there or not. This is just for ur idea what 
i know.

1) Find the total number of rows in a table using count(*)

2) Declare two variable in working storage section.
eg: 02  A pic 9(4) .
    02  B pic 9(2).

store the count no into one variable .assume u stored that 
in A.

then divide that by 2. so u will get half of the rows in a 
table. strore that value in B.

3)  Take another variable name C . 

eg: 02  c pic 9(4) value 0.

perform para1 until B =C

para1:

Retrive the row from the table.

move to corresponding  host variables ( use table to store 
muliple rows ).

insert into table(u can insert multiple rows at a time ...)

do the same for storing the other half into the another 
table. 

means here 1 st half rows were stored in one temp 
table .... the other in the one table.

i forgot to mention the  c value increment in the above 
mail.increment the c value after each row retrieved.

Hi ............
try this one ....might be a logical one ... but have to 
give customers what they want.....

Select count(*) into :ws-count from emp with ur;

Declare CURSOR cursor1 for 
              Select *(if possible better code all fields) 
from emp where count(*) < :ws-count;
Open cursor 
Fetch cursor.

Declare CURSOR cursor2 for 
              Select *(if possible better code all fields) 
from emp where 
                                                            
                                         count(*) >= :ws-
count;
Open cursor 
Fetch cursor.

ohh.. just manage the ws-count variable..