In there is 100 no. of recordsin PF, if i delete all the
records. Then what is the Size of the PF?

Answers were Sorted based on User's Feedback



In there is 100 no. of recordsin PF, if i delete all the records. Then what is the Size of the PF?..

Answer / sekhar

If you Delete the record, size of PF will not change. You
have to Reorganize the file using RGZPFM. Then only you can
reclaim the space by deleted records.

Is This Answer Correct ?    31 Yes 0 No

In there is 100 no. of recordsin PF, if i delete all the records. Then what is the Size of the PF?..

Answer / bappaditya

The size of any physical file depends on the size of
existing fields and number of key fields. So the size of
the PF is not changed wheather we delete all records of it.
Please let me know anyone if I am wrong.

...

Is This Answer Correct ?    14 Yes 1 No

In there is 100 no. of recordsin PF, if i delete all the records. Then what is the Size of the PF?..

Answer / kavita

answer 3 is absolutely correct

Is This Answer Correct ?    11 Yes 0 No

In there is 100 no. of recordsin PF, if i delete all the records. Then what is the Size of the PF?..

Answer / nihar

If you delete all the records from PF then the size of the
PF remains same .If you want to PF size is zero then you
reorganized the file through RGZPFM command.

Is This Answer Correct ?    9 Yes 0 No

In there is 100 no. of recordsin PF, if i delete all the records. Then what is the Size of the PF?..

Answer / harish

I hope size of the physical file will not change


if records deleted means the physical file will be empty






Harish poomgame shivappa
NIIT Technolgies
Kolkata

Is This Answer Correct ?    6 Yes 0 No

In there is 100 no. of recordsin PF, if i delete all the records. Then what is the Size of the PF?..

Answer / subash

answer 3 is absolutely correct

Is This Answer Correct ?    2 Yes 0 No

In there is 100 no. of recordsin PF, if i delete all the records. Then what is the Size of the PF?..

Answer / sunil

If you delete all the records from a PF file the size won't change unless and until if you use RGZPFM.

Is This Answer Correct ?    1 Yes 0 No

In there is 100 no. of recordsin PF, if i delete all the records. Then what is the Size of the PF?..

Answer / kanika

size will not change even if u do rgzpfm.

Is This Answer Correct ?    0 Yes 0 No

In there is 100 no. of recordsin PF, if i delete all the records. Then what is the Size of the PF?..

Answer / dinesh

i hope size of physical not changed beacaue we delet only
record not field

Is This Answer Correct ?    0 Yes 1 No

Post New Answer

More IBM AS400 AllOther Interview Questions

How can we arrange duplicate records in a file?

0 Answers  


How can I automate sftp commands(ls & get) in CL program.. If I want to write two scripts one for each command... can u plz tell where the script should be written? & what will be the content of each scripts?

1 Answers  


when do you use f-spec. Continuation line ?

1 Answers   IBM,


What Is Default Data Type (if You Define Decimals '0') In Physical File?

1 Answers   IBM,


What is LEVEL CHECK?

7 Answers   HCL, TCS,






When would the ALL keyword be used?

1 Answers  


define the purpose/use for sflrna?

1 Answers   IBM,


What is Data Area?

1 Answers  


WHAT IS FERERENTIAL INTRIGRITY ?

0 Answers  


What is the maximum number of elements in an array?

1 Answers  


what is the necessary keyword for non-join logical file?

1 Answers   IBM,


What is the maximum length of a variable name in CL?

1 Answers  


Categories