Interested to Buy Any Domain ? << Click Here >> for more details...
what is the input to PLAN?
what is the input to DBRM?
- 4 Answers
- 10716 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / harish
dbrm or package is input to plan....talking abt
dbrm.......the cobol+db2 prgrm is input to precompiler which
separtes cobol souce code and dbrm
| Is This Answer Correct ? | 8 Yes | 2 No |
Answer / mani
DBRMs and Packages are the input to the plan as said above.
The input to DBRM is the sql statements in the cobol db2
program
i.e all the sql statements in the cobol db2 program will be
replaced by the host language statements in this case it is
cobol and the sql statements are bound into DBRMs.
| Is This Answer Correct ? | 2 Yes | 2 No |
Answer / guest
The input to a plan is a DBRM or package. The DBRM is a
copy of the SQL statements of the program that is being
prepared.
| Is This Answer Correct ? | 1 Yes | 1 No |
Answer / anil reddy
DBRM-Caontains SQL statments seperated from your host
laguae bt Precompiler.
PLAN-Is the generated by BIND process , which will contain
Excutale cde for SQL statements in the DBRM.
| Is This Answer Correct ? | 0 Yes | 0 No |
I have 3 cursors declared. Cursor1 retieves some data. Based on this curso2 will also fetches some data. In cursor3 (using for some updation) I'm using the data retrieved by the above 2 cursor. My question is, while working with cursor3, periodically if I give commit, will all the three crsors will be closed or only cursor3 will be closed?
In my table having 100 Rec. How can I delete the 7th row?? (we don't know what is data inside the table)
What is an access path?
If I have a view which is a join of two or more tables, can this view be updateable?
What happens to a tablespace when its recovery infromation has been removed and a full recovery is no longer possible?
What are the various isolation levels possible?
What is reorg and runstats in db2?
How connect db2 database to datastage?
What is the difference between base table and view?
how we will do null data selection in cobol-db2 program
Hi Team, Please tell me, If i don't declare the cursor in the program and i have given open and fetch and close, then what error will get.
Where is the output of EXPLAIN stored?
COBOL 
