Interested to Buy Any Domain ? << Click Here >> for more details...
DB2 can implement a join in three ways using a merge join,
a nested join or a hybrid join. Explain the differences?
- 0 Answers
- 2852 Views
- I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
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).
How do I delete a table in db2?
What is the advantage in De-normalizing tables in DB2?
I have a subprogram B calling from mainprogram A.I have opened a cursor in A ,Can i fetch the same cursor in subprogram B , If yes , Please explain the reason?
What is a root page?
What is an instance in db2?
what are extents?
How and when does the db2 enforces the unique key?
What is iseries database?
What is the FREE command?
How to resolve -805 error in DB2?
What is explain plan in db2?
COBOL 
