Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


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

pls anyone explain about compile time array,pre run time array run time array

4 Answers  


What is the use of member in pf?

0 Answers  


wirte a simple program for read file in cl

2 Answers   Active Brains,


Define interactive jobs and batch jobs

6 Answers  


how to restrict upon adding the data for field reference file in DB400

1 Answers  


What is FORMAT keyword and its use?

0 Answers  


What is the difference between access path and open data path?

0 Answers  


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

3 Answers   Accenture, Cognizant, eFunds,


How to add a field to a PF and compile it without loss of data?

7 Answers  


How we can't update join logical files?

10 Answers  


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

3 Answers   Four soft,


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

0 Answers  


Categories