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.

Describe major components of db2?

1089

---

How to find the number of rows in db2 tables?

1056

---

Is db2 a mainframe?

1039

---

How to find primary key of a table in db2?

1056

---

What is dclgen in db2?

1137

---

What are the contents of a dclmgen?

1120

---

What is blu acceleration in db2?

1065

---

What is temporal table in db2?

1030

---

What is a db2 package?

1045

---

What is load utility in db2?

1179

---

What is the use of predicate?

1039

---

I HAVE 500 ROW TO UPDATE I WOULD LIKE TO USE ROLLBACK ALONG WITH COMMIT.WHAT IS THE SYNTAX TO CODE COMMIT AND ROLLBACK FOR EVERY 100 ROWS.AND HOW THE CURSOR ROLLBACK TO THE LAST COMMITTING POINT.

3198

---

What is host variable in db2 cobol?

1069

---

What is database manager in db2?

1011

---

How will you return the number of records in table?

925

---