Answer / s

Column name qualifier is Table name

What is the max length of sqlca?

0 Answers  

---

pls explain the precompilation process of cobol-db2 pgm

3 Answers   HCL, IBM,

---

we can code COPY DCLGEN or INCLUDE DCLGEN, At which stage of the precompilation , dclgen get expanded if we write 1) copy 2) include one question about dclgen.. Is it mandatory to use declare table in dclgen.. I think no...but it will be used by the precompiler to validate the table name,column name etc.., can one clear my doubt ..is it necessary to include declare table or not?

2 Answers  

---

How to check last update on table in db2?

0 Answers  

---

What is the use of COMMAREA ?Minimum how much data we can pass from it?

7 Answers   Cap Gemini,

---

---

Is it mandatory to use DCLGEN? If not, why would you use it at all?

2 Answers  

---

List down the data types in the db2 database.

0 Answers  

---

What keyword does an SQL SELECT statement use for a string search?

2 Answers  

---

Is it Possible to declare or create a cursor for UPDATE of table? If yes tell me how? If no Tell me why?

1 Answers   IBM, scintel,

---

How to define the data items to receive the fetch items for the SQL?

2 Answers  

---

How is the SUBSTR keyword used in sql?

1 Answers  

---

One program calling 5 subprograms, its a cobol db2 program, after precompilation how many plans and packages will created?

3 Answers  

---