What is the difference between primary key & unique index ?

6 Answers   Patni, Temenos,

---

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  

---

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,

---

How to resolve -917 sql code in DB2?

3 Answers   Cap Gemini,

---

How can you quickly find out the number of rows updated after an update statement?

1 Answers   CSI, CTS,

---

What is the use of dclgen in db2?

0 Answers  

---

Can I use LOCK TABLE on a view?

1 Answers  

---

if i made sme changes in sub pgm wht r the things to be done for this ?

1 Answers   TCS,

---

What are the three types of page locks that can be held?

1 Answers  

---

What is meant by dclgen?

0 Answers  

---

Hi, i would like to start a new carrier in DB2 DBA.Which and what all step should i have to take..?

0 Answers  

---

How do I create a table MANAGER (EMP-NO, MANAGER) where MANAGER is a foreign key which references to EMP-NO in the same table? Give the exact DDL.

3 Answers  

---