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 open data base command

1 Answers   Active Brains, Cognizant, CSC, CTS,

---

There are six records in a file and we are going to update that records and used commit operation when it complete the update but suppose when it updating the third record,a error occured and operation failed.Is previously two records will be update or whole operation will be rollback? Please confirm it.

2 Answers  

---

wirte a simple program for read file in cl

2 Answers   Active Brains,

---

How to retrieve a physical file after deleting that?

0 Answers  

---

Suppose I have a pf, it contains 5 members, how to access particular member data from logical file? What is the use of member in pf?

0 Answers  

---

What is the interactive job? What is the batch job? How to change the batch job to interactive job?

0 Answers  

---

How to know logical file belongs to which physical file without source?

1 Answers  

---

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

6 Answers   HSBC,

---

Define interactive jobs and batch jobs

6 Answers  

---

i have a PF,it contains 5 members,how to access particular member data from logical file ?and what is the use of member in PF

3 Answers  

---

what is exception and how many types of exception

1 Answers   Active Brains,

---

A pf containing 100 records... my query is how to display from 11th record in the pf?

3 Answers  

---