Answer / naveen87ginjupalli

DcLGEN is Declaration Generator generates DB2 equalent
cobol variables called Host Variables.

Answer / girish kumar

DCLGEN is one of the db2 UTILITY.
which is used to create host varibles.
when we provide tabel details to the DCLGEN, DCLGEN will
create host-varible structure in a saparate PDS Member.
That host variable are used to communicate application
program(COBOL) and database(DB2)

Answer / mahesh

its a decleration generation tool which is used to declare a
host variables for the source table to connnect cobol and db2

How do you leave the cursor open after issuing a COMMIT? (for DB2 2.3 or above only)

2 Answers  

---

What is a collection?

3 Answers  

---

I need to view the number of tables existing under one particular Owner. Is it possible? If so, pl give the SQL query for this?

0 Answers  

---

How to create db2 table in mainframe?

0 Answers  

---

Is it possible using max on a char column?

0 Answers  

---

What is a correlated sub query?

2 Answers  

---

Can we use select query in a loop to fetch multiple rows in a COBOL PROGRAM? If so, what is the advantage of cursor?

1 Answers   UST,

---

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 .....

0 Answers  

---

What's the Maximum Length of SQLCA and what's the content of SQLCABC?

2 Answers  

---

Which component is used to execute the sql statements?

0 Answers  

---

How to insert more than one record using insert?

7 Answers   Atos Origin, IBM,

---

What is the use of commit in db2?

0 Answers  

---