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 difference between alias and synonym in db2?
In cobol+DB2program if the code of cobol program has changed than i have to do precompilation once again?
Why cursor is used in db2?
What is the physical storage length of the data types: date, time, timestamp in the db2 database?
wht are the restrictions for union ?
how to u check the query is executing or not ?where will u check for sqlcode ?
EXPLAIN has output with MATCHCOLS = 0. What does it mean?
5 rows are inserted to a DB2 Table. Next 3 of those are updated, then a rollback is issued. What would happen when the rollback is issued?
what are the frequent DB2 abends did you encounter in your programs ?? What are different SQL abends ??
What is ACQUIRE/RELEASE in BIND?
Which isolation level provides highest data integrity?
I have a subprogram B calling from mainprogram A.I have opened a cursor in A ,Can i fetch the same cursor in subprogram B , If yes , Please explain the reason?