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

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,


What is the purpose of the chain and setll and setgt?

0 Answers  


how can we write LF using flatfile.

9 Answers  


How many max. Record format a logical file have?

13 Answers   Systime,


In a CL Program after executing a SQL SP how to receive a Output value from the SP. Just to make it clear I am sending 2 input and 1 output parameter to the SQL Stored Procedure. Now while receiving it output parm it is failing.

0 Answers   Nous,






wirte a simple program for read file in cl

2 Answers   Active Brains,


How to update physical file using logical file with example?

0 Answers  


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

3 Answers  


How many maximum record format a logical file have?

0 Answers  


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

1 Answers  


I have a PF with out any data but the dependent LF is having data?

1 Answers   HCL,


How to find the list of source physical files in a library?? Is there any way to get a list??

5 Answers   Infosys,


Categories