what is the Foreign key? explain?

2 Answers  

---

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

0 Answers  

---

Can one database have multiple instances?

0 Answers  

---

Can we install 2 different versions of Db2 on same mainframe?

3 Answers  

---

What is SPUFI?

4 Answers  

---

Describe major components of db2?

0 Answers  

---

Can we use select * statement in cobol program without giving field names ???

3 Answers   Zensar,

---

how to u check the query is executing or not ?where will u check for sqlcode ?

6 Answers   Infosys,

---

Can we use select query in a loop to fetch multiple rows in a COBOL PROGRAM? If so, what is the advantage of cursor?

1 Answers   UST,

---

select distinct(empid),distinct(dept),name from EMP will the above query work?

2 Answers   CTS,

---

db2 maintains information about the data... a.in tables. b.in a set of tables known as db2 catalog. c.in db2 database. d.none of the above.

1 Answers  

---

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  

---