1. Categories >> Software >> MainFrame >> IBM AS400 >> DB400
  2. Suggest New Category

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

Question Posted / sony

Answers were Sorted based on User's Feedback



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

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.

Is This Answer Correct ?    17 Yes 1 No

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

Answer / cyjil

USING THE COMMAND 'RGZPFM'

Is This Answer Correct ?    9 Yes 1 No

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

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.

Is This Answer Correct ?    7 Yes 1 No

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

Answer / gatla

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

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

Is This Answer Correct ?    2 Yes 1 No

Post New Answer

More DB400 Interview Questions

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  

How many max. Record format a logical file have?

13 Answers   Systime,

How to retrieve a physical file after deleting that?

0 Answers  

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

0 Answers  

Why journalling is compulsory before commitment control?

1 Answers  




How to read a pf in reverse(from last record to first) using cl?

0 Answers  

what is the intractive job? what is the batch job ? how to change the batch job to interactive job?

2 Answers   Four soft,

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 multiple member pf

1 Answers   Active Brains,

I had created one physical file tell me command to enter data in to?

1 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  

how to update physical file using logucal file with example

1 Answers   Wipro,

For more DB400 Interview Questions Click Here
Categories