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 is the SQL query to select, delete and get count of duplicate rows in DB2?
How would you find out the total number of rows in a db2 table?
Give the COBOL definition of a VARCHAR field.
1) I have 3 programs : PGMA, PGMB, PGMC. PGMA calls PGMB and PGMB calls PGMC. I have to do inserts, updates in all the 3 pgms. 2) Say PGMC has done its work successfully and returned to PGMB 3) PGMB had an SQL error while doing some update 4) PGMA has already done some updates before calling PGMB all are running under the same CICS region. What will happen if I issue SYNCPOINT ROLLBACK in PGMB when it abends ? Does all the changes in PGMA,B,C rollback ? (because all the pgms belong to same task).
What is runstats db2?
What is innodb buffer pool?
Can we able to find all the Table names under a Particular Plan?
Which component is responsible for db2 startup and shutdown?
Is db2 relational database?
What is the difference between SYNONYM and ALIAS?
Can All Users Have The Privilege To Use The SQL Statement Select (DML)?
What are db2 error codes -305 and -407. What is the difference between these 2 error codes ?