My DB2 program first read the data from a file and then it look into a table with the data it got from the file.If we did not bind the program , should the file read before SQL execution be success??

2 Answers   Xansa,

---

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

1 Answers  

---

Which are the db2 tools to protect integrity of the database?

0 Answers   IBM,

---

What is a correlated sub query?

2 Answers  

---

by using cursors , we can access particular records from the table based on some condition, i want to delete those selected records, how can we write a query for this in the program?

4 Answers   Mphasis,

---

How do you pull up a query which was previously saved in qmf?

0 Answers  

---

What are the three DB2 date and time data types and their associated functions?

1 Answers  

---

What is SPUFI?

4 Answers  

---

When Can you be sure that a query will return only one row?

4 Answers   IBM,

---

What information can you find in SYSIBM.SYSLINKS table?

1 Answers   TCS,

---

What is db2 look?

0 Answers  

---

how does the defining of a stored procedure effect the size of a DB2 data base A) it increases the size of a data base B) it decreases the size of a data base C) it does not effect the size of the data base D) it changes the table space structures

2 Answers   Accenture,

---