In cursor program perform para varying until 1 by 1 fetch para cursor------close para in the blank what will come for confirming in the database?

1 Answers   HCL,

---

Select empno, sal from emptbl where empno < 101.By this query can we fetch first 100 recs? where empno is primary key.It won't throw -811 error? if it wont,then what is use of cursor technique while fetching first 100 recs. Please need more clarification.

2 Answers  

---

Request to database but database is not available so what is was abend is raised?

2 Answers   UST,

---

What is the max length of sqlca?

0 Answers  

---

if any of the column names is provided wrong, where do you get the error(during precompilation or during Bind)

3 Answers  

---

---

In my table having 100 Rec. How can I delete the 7th row?? (we don't know what is data inside the table)

9 Answers   IBM,

---

What is error -818 in db2. where can you find the timestamp of the DBRM and the source code.( precompile puts the timestamp on dbrm and source code correct?)

2 Answers  

---

Update command

1 Answers  

---

Is db2 a mainframe?

0 Answers  

---

What technique is used to retrieve data from more than one table in a single SQL statement?

9 Answers   CTS, IBM, TCS,

---

I have a table(product),It contain fields(productname,cost). I want to retrieve the product name ,which cost is second maximum in the table?

10 Answers   Fidelity,

---

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  

---