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
- 7296 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 |
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?
i have a table like this : Name ADDRESS Toto 123 ... Toto 456 ToTo 678 I would like to delete 2 last row...please tell me how to delete its
Can there be more than one cursor open for any program?
Why use RUNSTAT Utility?
How to run db2 command in windows?
How does DB2 determine what lock-size to use?
how to identify the pseudo conversation by seeing the program
A Table feild is declared as Decimal(7,2). I want to insert the decimal in to this column thru cobol-db2 program. How should I declare my local input file variable or any suggestion?
What is query_cache_limit?
wht r the requirements for writing a cobol-db2 pgm ?
When is the results table for the query in a DECLARE CURSOR statement created?
How Plan is created while executing the query using SPUFI?
COBOL 
