Answer Posted / arpita

We can achieve this by using STRSQL and CPYF commands as
follows -

Type STRSQL, Press Shift + F1, option1 Change session
attributes.Type 3 for SELECT option, specify the output
file name and library (must be created in QTEMP, for a
temporary file). Press ENTER twice.

Then, type the following query -
select * from SAHAA/EMPDATA1
where rrn(EMPDATA1) in(
SELECT distinct dec((rrn(EMPDATA1)/2)) FROM SAHAA/EMPDATA1
) --> use your file and library name

Press Enter, the message File TEMP in QTEMP was created.
Restore the previous session attributes as follows -

Press Shift + F1, option1 Change session attributes.Type 1
for SELECT option. Press ENTER thrice.

Now, we would have half no. of records of EMPDATA1 in file
TEMP (say)

Now, simply use the CPYF command to copy TEMP file data
into EMPDATA1 as follows -

CPYF FROMFILE(QTEMP/TEMP) TOFILE(SAHAA/EMPDATA1) MBROPT
(*REPLACE)

Note:- TEMP is the file temporarily created in QTEMP, so
that it is no longer present in the system when the session
expires.

What is role in db2?

1109

---

What is data manager?

1051

---

What is nvl in db2?

1096

---

What is the purpose of using commit?

1100

---

My sql statement select avg(salary) from emp yields inaccurate results. Why?

1095

---

What does db2 plan contain?

1022

---

What is load utility in db2?

1181

---

What is the maximum length of sqlca?

1529

---

What is the default page size of buffer pools?

1122

---

Following a db2 update statement, what is the quickest way to compute the total number of updated rows?

1074

---

Outputs of explain are with matchcols = 0. What does this signify?

1061

---

What are the full forms of spufi and dclgen and why are they used?

1091

---

What does reorg do in db2?

1030

---

What are catalog tables in db2?

1051

---

What is db2 look?

1026

---