Answer / kiran

by giving save command in commandline option

Why PS file called Physical seqential file?How to sore data in sequential file and ESDS file? What is the use of DBRM,PLAN,package and Collection.

1 Answers  

---

What is access path in db2?

1 Answers  

---

What information is held in SYSIBM.SYSCOPY?

1 Answers  

---

I have two tables A and B. Both tables are connected with SSN number as foreign key. I want to retrieve a column data from B table. How will you write a query?

3 Answers   CTS,

---

can all users have the privilage to use the sql statement select * (dml)?

1 Answers   IBM,

---

How can you classify the locks in db2?

1 Answers  

---

Can a primary key have null values? If we try to insert a null value in a primary key column, will it work or give an error code?

6 Answers  

---

how can u retrieve the data from null values using applicaion program.

3 Answers   TCS,

---

Mention the location where the output received from explain statement is stored.

1 Answers  

---

Explain the contention situations caused by locks?

1 Answers  

---

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?

3 Answers  

---

On which levels locks can be applied?

1 Answers  

---