What is a Database Request Module(DBRM)?
Answers were Sorted based on User's Feedback
Answer / s
Precompiler replaces the SQL statements with a call to DB1.
The SQL statments from the application program are written
to a PDS member called DBRM.
| Is This Answer Correct ? | 17 Yes | 4 No |
Answer / mani d
Pre-compiler replaces the source module SQL statements to
Host language(COBOL) CALL statements.DBRM will hold the
HOst language call statements.Then this will undergo for
BINDing on Compilation process.
| Is This Answer Correct ? | 1 Yes | 2 No |
What is universal database?
What is bind and rebind in db2?
PLAN IS EXECUTABLE AND PACKAGE IS NOT EXECUTABLE . THEN WHAT IS THE USE OF PACKAGE?
2 Answers Tech Mahindra, Wipro,
Define sqlca.
When is the authorization check on DB2 objects done - at BIND time or run time?
What is sqlca’s maximum length?
Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?
What are the full forms of spufi and dclgen and why are they used?
How can you count the number of rows from a table tab?
i know the stpes 2 create an executable CICS/DB2 cobol code. 1. DB2 Precompiler converts the SQL Statements into COBOL API statements and creates another member with Acess plans. CodeA results in CodeB (code with API calls) & CodeC ( Access Plans ) 2.Code B is compiled/linked 2 create an exceutable.(codeE) 3.Now CodeC is binded to the database on which CodeE will be run. Can somebody provide me the sample JCLs for precompile/compile/link/bind.
What is a plan and package in db2?
Is DECLARE TABLE in DCLGEN necessary? Why it used?