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 / velmurugan
it is the member of the executing library
|Is This Answer Correct ?||1 Yes||1 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 the function of buffer manager?
how can you save the query in QMF?IS IT POSSIBLE OR NOT.IF POSSIBLW HOW?
If the cursor is kept open followed the issuing of commit, what is the procedure to leave the cursor that way?
What are the various locking levels available?
How to resolve deadlock issue
What is a DB2 bind?
Can a array declared with an index be displayed(readable format) in spool?
For Read Stability locks are not applicable for phantoms, What is Phantoms?
what is the Foreign key? explain?
Give a brief description of db2 isolation levels?
What is the purpose of coding FETCH in a SQL SELECT query? Explain with an example in Detail?
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.