i have a table like this : Name ADDRESS Toto 123 ... Toto 456 ToTo 678 I would like to delete 2 last row...please tell me how to delete its

5 Answers   EDS,

---

What is image copy?

1 Answers   Virtusa,

---

i know the stpes 2 create an executable CICS/DB2 cobol code. 1. DB2 Precompiler converts the SQL Statements into COBOL API statements and creates another member with Acess plans. CodeA results in CodeB (code with API calls) & CodeC ( Access Plans ) 2.Code B is compiled/linked 2 create an exceutable.(codeE) 3.Now CodeC is binded to the database on which CodeE will be run. Can somebody provide me the sample JCLs for precompile/compile/link/bind.

0 Answers  

---

Explain about rct in db2?

0 Answers  

---

What is the difference between CS and RR isolation levels?

1 Answers  

---

How would you find out the total number of rows in a db2 table?

0 Answers  

---

What is sqlcode -811?

7 Answers   Accenture, CTS, TCS,

---

What is the maximum number of columns in a db2 table?

0 Answers   IBM,

---

What is a bind in db2?

0 Answers  

---

For Null indicator we have 3 values 0,-1,-2. 0->Not nulll -1->Null -2->Value truncated If ther is any possibility to have any positive value other than 0 in Null indicator.If it is so then when we will get and what is the value?

1 Answers   BNP Paribas,

---

Is there any advantage to denormalizing DB2 tables?

1 Answers  

---

How can you validate Sql errors during cursor operation in db2 pgms and where do you code?

0 Answers   IBM,

---