Answer / s

IN subselect will return rows that match the values in the
IN list. EXISTS will return rows if the subselect return a
true value.

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,

---

How would you move a tablespace (using STOGROUP) to a different DASD volume allocated to that tablespace?

1 Answers  

---

cursor with hold explain ?

1 Answers   Verizon,

---

Name some fields from SQLCA.

2 Answers  

---

what is different three logs in DB2?

1 Answers   Syntel,

---

---

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  

---

what is diffrence b/w file-aid tool and file-aid utility???

1 Answers  

---

can we view the access paths created by dbrm ? how ? thx

2 Answers   IBM,

---

How would the varchar column remarks defined?

0 Answers  

---

insert into tablename a column1, column2 select column1, column2 from tablename b i am getting abend -104..can any one help?

3 Answers   Syntel,

---

What is the syntax for seeing the columns and data types of a table in the db2 database?

0 Answers  

---

in GDG: is it poosible to copy records from a file which utilizes some 100 cylinders to a gdg whose model is defined as trk(1,0) and also it possible to copy 100 bytes file to 80 bytes file?

1 Answers   IBM,

---