Where is the access path logic created by the DB2 Optimizer
stored?
Answer / s
It is stored as bound plans/packages in the DSNDB01
directory in SKCT02, SKPT01 tablespaces.
Is This Answer Correct ? | 4 Yes | 2 No |
What's The Error Code For Unique Index Voilation?
I have a subprogram B calling from mainprogram A.I have opened a cursor in A ,Can i fetch the same cursor in subprogram B , If yes , Please explain the reason?
Is it Possible to declare or create a cursor for UPDATE of table? If yes tell me how? If no Tell me why?
What is the latest version of ibm db2?
Explain how can you do the explain of a dynamic sql statement?
How to execute stored procedure in db2 command editor?
What is catalog database in db2?
what is the responsibility of the construction superintendent
What is meant by the attachment facility?
How to resolve SQL Code -310. The db table feild is declared as Decimal(7,2).
What is the difference between Primary key and unique index?
What is a view? Why use it?