Answer / saikishore

select TIMESTAMP(DATECOLUMN)
FROM TABLE1

This was related to -811 sqlcode, In a COBOL DB2 program which accesses employee table and selects rows for employee 'A', it should perform a paragraph s001-x if employee 'A' is present. In this case it gets -811 sqlcode, but still it process the paragraph s001-x. What could be wrong in my code.

3 Answers  

---

How could one combine a set of incremental image copies into a single copy?

1 Answers  

---

How does cobol compile db2 program?

0 Answers  

---

Can we declare DB2 HOST variable in COBOL COPY book?

2 Answers  

---

Is ibm db2 open source?

0 Answers  

---

If a non-DB2 program calls a DB2 program, the calling program's name will be there in SYSIN of IKJEFT01 and the plan name will be that of the called program. But is a bind needed or a plan has to be created for the non-DB2 program also?

1 Answers   RBS,

---

How to resolve -502 sql code in DB2?

2 Answers   Cap Gemini,

---

Explain in detail about buffer manager and its functionalities?

0 Answers  

---

If I have 5 Queries in a DB2 Cobol program , while precompiling how many DBRMs will get created and How many Plans and Packages will get created while Bind Process?

8 Answers   Accenture,

---

Which transaction use a command thread ?

1 Answers  

---

What is db2 catalog database?

0 Answers  

---

On which levels locks can be applied?

0 Answers  

---