How can you split a table in to exactly half?
Answer Posted / reddy kanupuru
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.
Is This Answer Correct ? | 4 Yes | 3 No |
Post New Answer View All Answers
what are bind concepts in db2 cobol?
Define db2 and its databases?
What is explain plan in db2?
What is view db2?
What is dbrm?
How to check last update on table in db2?
What is ibm db2 database?
what is the sqlcode -501
Why do chiropractors use drop table?
What is the use of dclgen in db2?
Explain about rct in db2?
What does a deadlock mean in DB2?
If I have a view which is a join of two or more tables, can this view be updateable?
What is a db2 schema?
How to find primary key of a table in db2?