Suppose if a physical file is having 1000 records, but i
deleted 500 records from it. Here the concern is can the size
of the file changes or it remains the same... kindly help me
out with thorough xplanation.... Thanks in-advance...

Answers were Sorted based on User's Feedback



Suppose if a physical file is having 1000 records, but i deleted 500 records from it. Here the con..

Answer / ram

size of pf didnt change until u run rgzpf...

Is This Answer Correct ?    15 Yes 0 No

Suppose if a physical file is having 1000 records, but i deleted 500 records from it. Here the con..

Answer / pavana

No, the size of the file does not change.

Use DSPOBJD on the PF before and after deleting records in the PF and see the difference.

The size of the PF before and after deleting records is same.

Is This Answer Correct ?    12 Yes 0 No

Suppose if a physical file is having 1000 records, but i deleted 500 records from it. Here the con..

Answer / karthik

SIZE Won't change....

after deleting 500 records from 1000 records...

and then IF you want to insert NEW RECORDS

THAT RECORDS WILL ADDED AFTER THE 1000TH RECORDS PLACE......
BUT IF YOU WANT USE THE SPACE OF DELETED RCDS USE...

RCZPFM ON THAT PF...

THEN SIZE CHANGES...........

Is This Answer Correct ?    4 Yes 0 No

Suppose if a physical file is having 1000 records, but i deleted 500 records from it. Here the con..

Answer / abhay kumar

use rgzpfm filname then its size changed.

Is This Answer Correct ?    2 Yes 0 No

Suppose if a physical file is having 1000 records, but i deleted 500 records from it. Here the con..

Answer / pvenkatakishore

even i did RGZPFM the size of file can't change
is this right? give me answer

Is This Answer Correct ?    0 Yes 1 No

Suppose if a physical file is having 1000 records, but i deleted 500 records from it. Here the con..

Answer / abc

yes, the file size changes.

Is This Answer Correct ?    0 Yes 7 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  


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

2 Answers   Active Brains, UHG,


can any one pls tell me some differences between a LF and command OPNQRYF?

3 Answers   Accenture, Cognizant, eFunds,


Suppose if a physical file is having 1000 records, but i deleted 500 records from it. Here the concern is can the size of the file changes or it remains the same... kindly help me out with thorough xplanation.... Thanks in-advance...

6 Answers   ABC, TCS,


How we can't update join logical files?

10 Answers  






hi iam very new to as400. i had created one physical file can any one tell command to enter data in to that

9 Answers   Encore,


Can we concatenate fields in physical file? If yes how can we do?

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,


how to know total no of records in pf with out using sql??????

3 Answers  


I have a pf, it contains 5 members, how to access particular member data from logical file?

0 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  


When we use any keyword like FIFO,LIFO, at file level but whenever we check by runqry we couldn't find answer in FIFO,LIFO,FCFO etc so how we check the answer.

2 Answers  


Categories