What is the specific need of Plan and..where are the tables
in DB2 are physically saved
Answer Posted / srinivas chennareddy
Though the tables are stored logically in tables space and
physically all tables/table Spaces are stored in VSAM
files....so the ultimate pgysical storage of any database
object is a VSAM file.
| Is This Answer Correct ? | 11 Yes | 0 No |
Post New Answer View All Answers
Cursors can be declared in both working-storage & procedure division, agreed. But is there any difference? If could you please suggest what is the difference
What is ibm db2 used for?
How to execute stored procedures?
Which component is responsible for db2 startup and shutdown?
What is db2 stogroup?
My sql statement select avg(salary) from emp yields inaccurate results. Why?
Where do you specify them?
Explain package in db2 and its advantages?
On which levels locks can be applied?
what is the role of the cursor in db2?
What are foreign keys in db2?
How do I create a view in db2?
Can you tell me how can you find out the # of rows updated after an update statement?
Explain correlated sub-queries.
Mention the definition of cobol in varchar field.