Interested to Buy Any Domain ? << Click Here >> for more details...
Where is the access path logic created by the DB2 Optimizer
stored?
- 1 Answers
- 8362 Views
- I also Faced
- E-Mail Answers
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 |
This was related to -811 sqlcode, In a COBOL DB2 program which accesses employee table and selects rows for employee 'A', it should perform a paragraph s001-x if employee 'A' is present. In this case it gets -811 sqlcode, but still it process the paragraph s001-x. What could be wrong in my code.
Are views updatable ?
What is a view? Why use it?
What is blu acceleration in db2?
Plan is an executable form of sql statements,But what exactly resides inside a Plan. what are the details inside Plan.
How to resolve -407 sql code in DB2?
What is the command used by TSO users to invoke DB2?
What are common abends
What do you need to do before you do EXPLAIN?
What is commit in db2?
When is the results table for the query in a DECLARE CURSOR statement created?
What is DYNSLT keyword? How do you perform selection using DYNSLT
COBOL 
