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

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

Question Posted / rama

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

Please Help Members By Posting Answers For Below Questions

B37 abend during spufi?

1405

What are the benefits of using the db2 database?

1156

What parameters are used to control the free space in DB2?

1012

How would the varchar column remarks defined?

1038

Explain correlated sub-queries.

979

How do I connect my db2 database to ibm?

988

What is commit in db2?

998

before altering a table is it necessary to lock ? if lock what is it ? how to do ? ifi want to lock a table what is that command ?

2125

What is image copy in db2?

946

Can you use max on a char column?

1031

Mention the downsides of page level lock.

1112

Mention some fields that are a part of sqlca.

972

What is rct?

1167

How to take backup of table in db2?

1023

Explain how can you do the explain of a dynamic sql statement?

1066