Once you create a view, where would information about the
view be stored?
Answer Posted / s
The CREATE statment is stored in the SYSIBM.SYSVIEWS
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What are db2 tables?
Explain about cursor stability?
Which component is used to execute the sql statements?
Which isolation level provides maximum concurrency?
What is db2 stogroup?
Why cursor is used in db2?
Define predicate?
How to find the number of rows in db2 tables?
Hi Everyone... Under the Logical files, when am working on multiple rec format logical file, I have joined two pf's using the multiple record format logical file concept, but when i run queried the LF only the first mentioned pf records are reflecting and I am not able to see any of the field records specified under the second pf. Kindly let me know whats the reason behind this. Below is the str of LF., R rec PFILE(LOGICAA) CUSTNO CUSTNAME BILL K CUSTNO R rec1 PFILE(LOGICAA1) CUSTNO ADD K CUSTNO .....
What is the use of value function?
What is the role of the data page in the db2 database?
How do you simulate the explain of an embedded sql statement in spufi/qmf?
What is the difference between plan and package in db2?
When reorg is used?
What are concurrency issues?