Interested to Buy Any Domain ? << Click Here >> for more details...
what is a plan and how do you refer the plan in the
program?
- 2 Answers
- 7015 Views
- Xansa, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / harsha
plan is executable.it contains access path.we will refer
plan in jcl as plan name.generally all information abt the
plan will be there in sysibm.sysplan
| Is This Answer Correct ? | 5 Yes | 0 No |
Answer / guest
The DBRM name is the program name and should be bound to a
plan before the DB2 program can be executed. The plan is
nothing but bound DBRMs or packages.
| Is This Answer Correct ? | 0 Yes | 1 No |
I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.
Explain transactions, commits and rollbacks in DB2.
What is the FREE command?
How to execute stored procedures?
Can we insert update delete in view?
What is the difference between plan and package in db2?
Mention the different locking levels that are available in db2.
Mention the way of highlighting as well as putting a cursor to use in a cobol program.
What is the syntax of SELECT statement when embedded in a COBOL program?
1. what if null values retrived from database and no null indicator mentioned in query. What is sql code.
I need to view the number of tables existing under one particular Owner. Is it possible? If so, pl give the SQL query for this?
How to insert more than one record using insert?
COBOL 
