what is the input to PLAN?
what is the input to DBRM?
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 |
How do you simulate the explain of an embedded sql statement in spufi/qmf?
How to test SQL -911 error while developing COB-DB2 program
Hi Dude,this is Ram.could any one tell me aboue CURRENT OF clause in DB2. Thanks in advance.......
What is a precompiler?
What is a DB2 access path?
if any of the column names is provided wrong, where do you get the error(during precompilation or during Bind)
Hi. I am currently working as a application developer. I would like to persue a DB2 certification exam. Can anybody please provide me the details about this exam like Syllabus, Cost and how to take the certification?
Define check constraint.
What is the physical storage length of the data types date, time, and timestamp?
what is SMP/E? and what are the major steps of it? thanks...
in a table consist of 1000 records among that i was updated 145 record how could i know that ..list of recently updated record's and where could i see those updated record's....pls help me out....
why we go for SPUFI for creating tables or for sql queries?