Answer Posted / suresh ramaiyan

The first thing is Host languages.
Whatever we are using in cobol (other than cobol langauge
command) that are called HOST language.

DB2 is also one of the host language.
COBOL compiler does not know the host language and does not
compile the same.
we will take cobol-db2 program..
Here, we are introduce PRE-COMPILER....
Pre-compiler will spilt the cobol db2 program into two
module.
1. Cobol program (fully cobol,all the host language
commands will get replaced with "MOVE and CALL" statements.
2. DBRM (DataBast Request Module)- only those commands,
which are code within 'EXEC SQL .. END-EXEC.

Now, we have spited and we have separate for each..(COBOL
and DB2)..
We know about compilation process for COBOL.
Now come to BIND process....
Bind is nothing but, compilation process of DBRM.
The output of this compilation process(BIND) is Package.
If we bind the packages then we will get Plan/Application
plan.
When we do the link-edit the cobol program, a thread will
be created between the load module of cobol and plan.

What is reorg?

1239

---

What is access path in db2?

1042

---

What is the purpose of rollback and commit?

1278

---

Explain db2.

1084

---

What is dbrm library?

1114

---

What is the use of reorg in db2?

1137

---

Hi Everyone... Under the Logical files, when am working on multiple rec format logical file, I have joined two pf's using the multiple record format logical file concept, but when i run queried the LF only the first mentioned pf records are reflecting and I am not able to see any of the field records specified under the second pf. Kindly let me know whats the reason behind this. Below is the str of LF., R rec PFILE(LOGICAA) CUSTNO CUSTNAME BILL K CUSTNO R rec1 PFILE(LOGICAA1) CUSTNO ADD K CUSTNO .....

2410

---

In case if at some point of time db2 is down, would that impact the pre-compilation process of a db2-cobol program?

1091

---

How to resolve deadlock issue

20315

---

Define declaration generator (dclgen).

1172

---

Explain correlated sub-queries.

1093

---

What is difference between isnull and coalesce?

1106

---

What is bind package and plan in db2?

1105

---

How to view db2 table structure?

1062

---

What is ibm db2 client?

1005

---