Can I use LOCK TABLE on a view?
Answer / s
You can use LOCK TABLE on any table. View is not a
physical object.
| Is This Answer Correct ? | 4 Yes | 2 No |
What do you need to do before you do EXPLAIN ?
the dd name for ksds is dest1 and what is the dd name for alternate index of ksds ? a.dest b.dest1 c.dest1a d.dd1
Define buffer pool.
How many types of page locks can be held in db2?
What are the various locks available?
Can DB2 be accessed by TSO users? If yes, which command is used to invoke DB2?
how to resolve -805 . how to see dbrm and package not found
What is copy book?
What is sqlca?
What is a Resource Control Table(RCT)? Describe its characteristics.
List down the data types in the db2 database.
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. TIA