Answer Posted / deepak gairola

DCLGEN(Declaration Genrator) is used to generate DB2
equivalent Cobol Datatypes. We can write a cobol Db2
program without using it but we will have to declare cobol
variables in our Program and for sure it need to be DB2
Equivalent... but it is preffered to use DCLgen as it gives
you the accurate... equivalent... of db2 datatype...and it
enhances the performance no doubt...

For Sql Datatype is Name Varchar(20).
so cobol equivalent is
01 Name.
49 Name-len PIC s9(04) comp.
49 Name-text pic x(2).

How does cobol compile db2 program?

1005

---

Explain db2.

990

---

What is db2 bind process?

1171

---

What is coalesce in db2?

1051

---

can all users have the privilage to use the sql statement select * (dml)?

1102

---

What does runstats do in db2?

1022

---

Name the various locking levels available?

1035

---

Can there be more than one cursor open for any program?

1121

---

Mention the different locking levels that are available in db2.

1066

---

Define data page.

1011

---

How can record locking be achieved in those DB2 versions which do not support it?

1015

---

How do I start db2 in windows?

1018

---

For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.

1053

---

What is package in cobol db2?

1073

---

What is the physical storage length of timestamp data type?

1023

---