Answer / bharathi

we can not update a PF from CL.
If we want to delete unused space in PF use CPYF or
RGZPFM. these are used to remove unused space.

Answer / cyjil

USING THE COMMAND 'RGZPFM'

Answer / nitendra chaurasia

USING THE COMMAND 'RGZPFM'
The Reorganize Physical File Member (RGZPFM) command
compresses (removes deleted records from) one member of a
physical file in the database, and it optionally
reorganizes that member.

Answer / gatla

CL.... Only for displaying data in a FILE..

we can't update/delete/insert data into a file through CL PROGRAM...

WHAT IS THE DIFFERENCE BETWEEN 'COLHDG' AND 'ALIAS'?

5 Answers   Accenture,

---

what is open data base command

1 Answers   Active Brains, Cognizant, CSC, CTS,

---

what is the difference between adding keys & constraints into a phisical file

4 Answers   HSBC,

---

what is multiple member pf

1 Answers   Active Brains,

---

If we use the file level keywords like LIFO, FIFO, FCFO in a file, can we see the impact of it by doing the run query of the file? if not how can we see the impact of these keywords.

2 Answers  

---

---

What is FORMAT keyword and its use?

0 Answers  

---

what is open data path? and what is the diff b/w access path and open data path?

3 Answers   Cap Gemini,

---

How to find the list of source physical files in a library?

0 Answers  

---

YOU CAN DELETE THE RECORD SPACE PERMENANTLY IN PHYSICALFILE THROUGH CL?

4 Answers  

---

Hi, Please give the answer to this question? I have Phisical file with 100 records,there is no any duplicate records in this pf.Based on this pf one Logical file i have used.But this lf is viewing only 80 records only of that pf?What is the reason for this?Please give me answer?

4 Answers   IBM,

---

what is general and type of general

1 Answers   Active Brains,

---

what is the difference between adding keys & constraints into a phisical file

6 Answers   HSBC,

---