What do you need to do before you do EXPLAIN?
Answer / s
Create the Plan_table to holds the results of the explain.
| Is This Answer Correct ? | 5 Yes | 0 No |
What's the Maximum Length of SQLCA and what's the content of SQLCABC?
What is a precompiler?
What technique is used to retrieve data from more than one table in a single SQL statement?
What is commit in db2?
assume ther are 5000 records in a database and want to fetch using cursor. cursor fetches only 3000 records and fetch is not happening for remaining 2000 records. why it happens and how to rectify it
What is a recovery log?
What is sqlcode -922 ?
can any one give the list of some important sql abend codes which r frequently asked in interviews?
where will u check for sqlcode ?
what is a collection?
If the base table underlying a view is restructured, eg. attributes are added, does the application code accessing the view need to be redone?
What is bind package and plan in db2?