What else is there in the PLAN apart from the access path?
Answer / s
The Plan contains the executable SQL code(if DBRMs are
directly bound to the plan) with its access path as well as
the consistency token that will be checked against the
contoken in the load module at execution time.
| Is This Answer Correct ? | 3 Yes | 0 No |
How does one remove entries from the SCT02 table?
what are the frequent DB2 abends did you encounter in your programs ?? What are different SQL abends ??
What is the SQL query to select, delete and get count of duplicate rows in DB2?
What is meant by repeatable read?
What is meant by dclgen?
What does this mean ? GRANT BIND,EXECUTE ON PLAN MK2 TO PUBLIC;
what is the input to PLAN? what is the input to DBRM?
How to view db2 table structure?
Describe the elements of the SELECT query syntax?
what needs to be done if a table is in copy pending / check pending status?
What is the difference between cursor and select statement?
What is the connection string to connect to the DB2 Database ?