Answer / sunil1405

join is more efficeint, Subselect can be written as a join.

Which component is responsible for db2 startup and shutdown?

0 Answers  

---

How do you eliminate duplicate values in db2?

0 Answers  

---

Say CUST Table contains records like: CUSTNO CUSTNAME CUSTLOC 100 ABC SSS 200 XYZ 300 PQR 400 MNO WWW 500 CVV ------------- ------------- Now write a query to retrieve all records with CUSTLOC no data.

3 Answers   IBM,

---

How do you run JCL in cobol program

1 Answers   IBM, Syntel,

---

What will the COMMIT accomplish?

5 Answers  

---

How do you simulate the EXPLAIN of an embedded SQL statement in SPUFI/QMF? Give an example with a host variable in WHERE clause)

2 Answers  

---

What is null in db2?

0 Answers  

---

SI Stud name Subject Marks Pass/Fail 1 Sham Maths 40 P 1 Sham Physics 50 P 1 Sham Bio 20 F 2 Ram Maths 40 P 2 Ram Physics 50 P 2 Ram Bio 60 P For the above data , write the SQL query for the student who passed in all the subjects . For eg : I want the data of only Ram coz he passed all subjects .

2 Answers   Cognizant,

---

why we go for SPUFI for creating tables or for sql queries?

4 Answers  

---

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

1 Answers  

---

What information can you find in SYSIBM.SYSLINKS table?

1 Answers   TCS,

---

How to check last update on table in db2?

0 Answers  

---