Interested to Buy Any Domain ? << Click Here >> for more details...
Explain what a plan is?
- 3 Answers
- 8784 Views
- CTS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / bhavna
A plan is an executable module containing the access path
produced by DB2 optimizer.
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / s
An application program cannot run without a plan. A Plan is
created by BIND PLAN, by binding DBRMS, packages or DBRMS
and packages together.
| Is This Answer Correct ? | 1 Yes | 3 No |
How can we define a table? How can we apply SEARCH ALL on it ?
we can code COPY DCLGEN or INCLUDE DCLGEN, At which stage of the precompilation , dclgen get expanded if we write 1) copy 2) include one question about dclgen.. Is it mandatory to use declare table in dclgen.. I think no...but it will be used by the precompiler to validate the table name,column name etc.., can one clear my doubt ..is it necessary to include declare table or not?
There is a 5000 EMP in company.how we find out the 5th highest getting salary employee outof 5000 employes........
My SQL is not performing well. Describe how will you fine tune it?
What is db2 purescale?
how to fetch multiple records without using cursor
how do we solve soc 7 and soc4 ?
What is host variable in db2 cobol?
When do you specify the isolation level? How?
How to find the number of rows in db2 tables?
What are foreign keys in db2?
If a table has a column "dept" (declared to have nulls) and there are 10 rows in the table of which 3 have a null value in the dept column, what will select count(*) and select count(distinct dept) return?
COBOL 
