Answer / s

For User authorization, SYSIBM.SYSUSERAUTH

What is alias in db2?

0 Answers  

---

When do you use the IMAGECOPY?

4 Answers  

---

What is db2 optimizer?

0 Answers  

---

What does the CHECK Utility do ?

1 Answers  

---

Suppose if I need to update a column, how you do that using cursor?

2 Answers   Verizon,

---

5 rows are inserted to a DB2 Table. Next 3 of those are updated, then a rollback is issued. What would happen when the rollback is issued?

2 Answers  

---

What is declare cursor?

0 Answers  

---

Define sqlca.

0 Answers  

---

what is the total syntax for fetch ? can any one please give me all the details of fetch ? thx

2 Answers   IBM,

---

What is normalization and what are the five normal forms?

1 Answers  

---

Consider that a package is bound into 2 different collections and the PKLIST option specifies both the collections. If the collection id is not specified in the program while executing the SQL query, then when the DB2 system will search the package list, which collection will it pick up or will it give an error/abend?

1 Answers  

---

Q1. How will you use two different DB2 qualifiers in a single COBOL program? Suppose we have 2 tables EMP1 and EMP2 with same structure defined in two different DB2 qualifiers QUAL1.EMP1 and QUAL2.EMP2 now during first 15 days we want to use QUAL1.EMP1 and rest of the days QUAL2.EMP2  how will we do this.  We can create a single program and a single load for this program. 

2 Answers   RBS,

---