Answer / shravan kumar.p

If Length is not declared for varchar, sql code -311 will appears...
by giving the varchar lenth in cobol+db2 pgm we can resolve this -311 sql code..

if wrong correct me..
thakyou...

I want to fetch the 10th row of a table which has been changed.How can I do it without going thru all the rows.

5 Answers  

---

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

2 Answers  

---

What is ibm db2 client?

0 Answers  

---

how to resolve -811 error. give clear explination

4 Answers   IBM,

---

What is concurrency?

0 Answers  

---

What is a bind in db2?

0 Answers  

---

Which component is used to execute the sql statements?

0 Answers  

---

Under what circumstances will DB2 allow an SQL statement to update more than one primary key value at a time?

1 Answers  

---

I HAVE 2 TABLES ONE IS EMP_TABLE AND ANOTHER DEPT_TABLE.EMP_TABLE CONTAINS NAME,DEPTNO,DEPTNAME,LOCATION AND DEPT_TABLE CONTAINS DEPTNO,DOJ(DATE OF JOINING).I WANT TO DISPLAY NAME,DEPTNAME,DOJ AND WHO ARE JOINED BETWEN 01- JAN-2007 TO 01-JAN-2008?

6 Answers   Perot Systems,

---

What is -904 sql code? How to resolve it?

3 Answers  

---

How do you concatenate the firstname and lastname from emp table to give a complete name?

0 Answers  

---

I have a DB2 table which has 1000 rows.after udatingg first 110 rows, my job abends. Now what I have to do if I want to restart the job next time so that it should start updating from 111th row (without updating first 110 rows again).

10 Answers   Cap Gemini, Wipro,

---