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...


If we have 100 records in the PF, we deleted all the records
then what is the Size of the PF?

Answers were Sorted based on User's Feedback



If we have 100 records in the PF, we deleted all the records then what is the Size of the PF?..

Answer / divyananda

The memory will be held untill you compress the PF

Is This Answer Correct ?    6 Yes 1 No

If we have 100 records in the PF, we deleted all the records then what is the Size of the PF?..

Answer / rama

If it is a physical sequential file the size of the file
becomes 0.

Is This Answer Correct ?    5 Yes 2 No

Post New Answer

More DB2 Interview Questions

Hi Everyone... Under the Logical files, when am working on multiple rec format logical file, I have joined two pf's using the multiple record format logical file concept, but when i run queried the LF only the first mentioned pf records are reflecting and I am not able to see any of the field records specified under the second pf. Kindly let me know whats the reason behind this. Below is the str of LF., R rec PFILE(LOGICAA) CUSTNO CUSTNAME BILL K CUSTNO R rec1 PFILE(LOGICAA1) CUSTNO ADD K CUSTNO .....

0 Answers  


What is dbrm in db2 database?

0 Answers  


Generally if I want to select the names starting with c I need to use c% But how could I code to select the data which contains % as a part of data.

5 Answers  


What is the FREE command?

1 Answers  


Can a unique index have more than one null value? If not, what error code is given if an attempt is made to insert more than one null value?

3 Answers  


what is the maximum number of tables that can be joined ?

8 Answers   IBM, TCS,


Discuss about db2 bind?

0 Answers  


What does CURRENTDATA option in bind indicate

1 Answers   IBM,


how we will do null data selection in cobol-db2 program

2 Answers   Wipro,


Can a primary key have null values? If we try to insert a null value in a primary key column, will it work or give an error code?

6 Answers  


in my project..TEST is db2 8.1 version In PROD it is 7.1 if i do REORG in TEST.. can I use the same REORG jcl with out modification in PROD region (this is DB2 8.1 )? if not, what modification i need to do in my REORG control card?

0 Answers  


What are column-name qualifiers used?

1 Answers  


Categories