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

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

what is dynslt and why we use that command when do we use command

2 Answers   Active Brains, UHG,


How to change the batch job to interactive job?

0 Answers  


How to retrieve a physical file after deleting that ? what is keyword used for that....??

6 Answers  


can we concate fileds in physical file? If yes how can we do?

5 Answers   Patni,


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

6 Answers   HSBC,






How to know the particular record in pf with out reading?

0 Answers  


one physical file can have how many max of logical files? what is the primary file?

3 Answers   Four soft,


how to update physical file using logucal file with example

1 Answers   Wipro,


How many max. Record format a logical file have?

13 Answers   Systime,


How can i retrieve city while my i have one field address length 60 but i don't know what where is city in this field ?

4 Answers  


What is the primary file?

0 Answers  


how to eliminate the level check error

2 Answers   TCS,


Categories