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

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

What is reorg and runstats in db2?

794


What is copy pending and check pending in db2?

664


How would the varchar column remarks defined?

726


How do I delete a table in db2?

732


What is the difference between dbm cfg and db cfg file in db2 ?

1104






How do you simulate the explain of an embedded sql statement in spufi/qmf?

724


What is the difference between cursor stability and repeatable read isolation levels?

777


What kind of database is db2?

662


What is the use of db2 optimizer?

694


What is database reorganization?

680


Discuss about db2 bind?

748


What is difference between isnull and coalesce?

689


How is the value function used?

713


Can you tell me how can you find out the # of rows updated after an update statement?

709


What are union and union all?

625