What do you need to do before you do EXPLAIN ?
Answer / naveen87ginjupalli
The Plan_table is created under the AUTHID.
| Is This Answer Correct ? | 5 Yes | 0 No |
how can you copy records present in a flat physical file to a database file(physical file).please explain in rpg400 with a simple example
What are db2 error codes -305 and -407. What is the difference between these 2 error codes ?
How is a typical DB2 batch program executed ?
What is sqlcode -922 ?
How would you move a tablespace (using STOGROUP) to a different DASD volume allocated to that tablespace?
Are views updatable ?
what is sql abend code -801,-802?
How is the SUBSTR keyword used in sql?
What is a system catalog table in db2?
What is the physical storage length of the data types: date, time, timestamp in the db2 database?
On which levels locks can be applied?
What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?