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 with ur in db2?
What is DB2 (IBM Database 2)?
What are the abend codes occour in ur latest PROJECT in DB2
What is the use of dclgen in db2?
If a table has a column "dept" (declared to have nulls) and there are 10 rows in the table of which 3 have a null value in the dept column, what will select count(*) and select count(distinct dept) return?
how to resolve -811 sqlcode .give clear explaination
Update command
Explain about cursor stability?
I need to view the number of tables existing under one particular Owner. Is it possible? If so, pl give the SQL query for this?
How do you pull up a query which was previously saved in qmf?
What is consistency token in db2?
What is a synonym? How is it used?