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.

How to find primary key of a table in db2?

1125

---

Is schema the same as database?

1107

---

What is query_cache_limit?

1036

---

How do you concatenate the firstname and lastname from emp table to give a complete name?

1122

---

What is a dbrm in db2?

1077

---

Explain the contents that are a part of dclgen.

1137

---

How does cobol compile db2 program?

1130

---

What is syscat in db2?

1072

---

What is cloudant database?

1158

---

Can you use max on a char column?

1144

---

What is the difference between spufi and qmf?

1204

---

What is dbrm? When it will be created?

1089

---

What is the result of open cursor statement?

1127

---

How to run db2 command in windows?

1245

---

Highlight all the advantages that are attached to a package.

1169

---