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.

Differentiate between cs and rr isolation levels? Where do you specify them?

1071

---

What is a storage group (stogroup)?

1246

---

Is ibm db2 open source?

1075

---

What is ibm db2 connect?

1002

---

What is ibm db2 used for?

1082

---

What does reorg do in db2?

1030

---

What are host variables in db2?

1072

---

How to connect to db2 database from windows command line?

1066

---

How do I create a view in db2?

1024

---

What is clone table?

1046

---

Who uses db2?

1050

---

How to retrieve rows from a db2 table in embedded sql?

1393

---

What is cloudant database?

1101

---

what is db2 restart?

2162

---

Outputs of explain are with matchcols = 0. What does this signify?

1061

---