Answer / sabahat khan

The only place of VSAM KSDS in DB2 is in Boot Strap Data
Set.

Answer / s

VSAM KSDS is used for DB2 indexes

What is the difference between SYNONYM and ALIAS?

6 Answers   TCS,

---

When is the authorization check on DB2 objects done - at BIND time or run time?

1 Answers  

---

What is an alias?

3 Answers  

---

What is db2 isolation?

2 Answers  

---

What is the specific need of Plan and..where are the tables in DB2 are physically saved

3 Answers   Infosys,

---

---

Usually, which is more important for DB2 system performance - CPU processing or I/O access?

1 Answers  

---

How do you filter out the rows retrieved from a Db2 table ?

1 Answers  

---

How to find the number of rows in a db2 table?

0 Answers  

---

I have a subprogram B calling from mainprogram A.I have opened a cursor in A ,Can i fetch the same cursor in subprogram B , If yes , Please explain the reason?

1 Answers   HeadStrong,

---

Suppose pgm A calling Pgm B .Pgm B has some Db2 program. at the time of compilation should plan and package will be created for both A and B or only B? What is the concept?

2 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,

---

How to resolve the -305 error code in DB2? And also please let me know, how to resolve the db2 error codes.

7 Answers   TCS,

---