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 |
In db2, how do you insert multiple rows in 1 query using a.) Cursors, b.) Normal query?? Give syntax for both.
If a non-DB2 program calls a DB2 program, the calling program's name will be there in SYSIN of IKJEFT01 and the plan name will be that of the called program. But is a bind needed or a plan has to be created for the non-DB2 program also?
wht are the restrictions for union ?
What is EXPLAIN?
Explain in brief how does db2 determine what lock-size to use?
What is db2 connect?
How does DB2 determine what lock-size to use?
how we will do null data selection in cobol-db2 program
What is the function of the Data Manager?
Where besides the DB2 catalog is database object information stored by DB2?
What does an outer join do?
What is catalog database in db2?