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
Answer / divyananda
The memory will be held untill you compress the PF
Is This Answer Correct ? | 6 Yes | 1 No |
Answer / rama
If it is a physical sequential file the size of the file
becomes 0.
Is This Answer Correct ? | 5 Yes | 2 No |
What is db2 command?
Return code 100 means?
What is the picture clause of null indicator variable?
How to resolve -803 sql code in DB2?
What does the sqlcode of -818 pertain to?
Select empno, sal from emptbl where empno < 101.By this query can we fetch first 100 recs? where empno is primary key.It won't throw -811 error? if it wont,then what is use of cursor technique while fetching first 100 recs. Please need more clarification.
What is tablespace?
What is the use of value function?
What is runstats utility in db2?
How to compare data between two tables in db2?
What is meant by dclgen?
What are some characteristics of columns that benefit from indexes?