Interested to Buy Any Domain ? << Click Here >> for more details...
Explain the EXPLAIN statement?
- 1 Answers
- 4905 Views
- I also Faced
- E-Mail Answers
Answer / s
EXPLAIN, determines the access path that will be used by
DB2 to execute that particular SQL statment. The results
are written to the PLAN table.
| Is This Answer Correct ? | 1 Yes | 1 No |
If there is no row in Emp table with Ename as Raghava and you run the below queries in SPUFI. 1.select Ename from EMP wher Ename = 'raghava' 2.Select count(*) from EMP where Ename = 'raghava' What is SQLCODE shown up in SPUFI
I have a main program (A) where we delete some rows in table in a cursor, and we commit it in sub program(B). What will happen - will we get an error or not?
How can you quickly find out the # of rows updated after an update statement?
What is copy book?
What kind of database is db2?
i have cobol+ db2 program but it contains n number of subprograms for this how many dbrm members i need to mention in bind process
Name some fields from SQLCA.
What is isolation level in db2?
What is a predicate?
What is meant by a unit of recovery?
Where besides the DB2 catalog is database object information stored by DB2?
What is the cobol picture clause of the db2 data types date, time, timestamp?
COBOL 
