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

how to add a new field to a file without compiling it?

1 Answers  


can any one tell me what is meant by PSSR? Kindly elaborate it...

1 Answers  


Suppose 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?

0 Answers  


what is exception and how many types of exception

1 Answers   Active Brains,


What is the use of member in pf?

0 Answers  


how can we write LF using flatfile.

9 Answers  


Why we create the Physical File Member?

5 Answers  


Why journalling is compulsory before commitment control?

1 Answers  


How many maximum record format a logical file have?

0 Answers  


what is multiple member pf

1 Answers   Active Brains,


how to eliminate the level check error

2 Answers   TCS,


How to retrieve a physical file after deleting that?

0 Answers  


Categories