Answer / harika

Db2 Index. Indexes are the database objects created based on one or more columns of a table.

Explain packages.

0 Answers  

---

What is a DB2 bind?

1 Answers   Logica CMG,

---

How do you run JCL in cobol program

1 Answers   IBM, Syntel,

---

I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.

0 Answers  

---

How do I import data from excel to db2?

0 Answers  

---

---

What is the use of with ur in db2?

0 Answers  

---

How do you retrieve the first 5 characters of firstname column of db2 table emp?

1 Answers  

---

List some fields from sqlca?

0 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  

---

what will be the output of the below given query, if no matching records are found : (a.) 0 (b.) null (c.) error select Avg(salary) from TableA where Deptno = 'insurance'

10 Answers   Amdocs,

---

What is an intent lock?

3 Answers  

---

I need to view the number of tables existing under one particular Owner. Is it possible? If so, pl give the SQL query for this?

3 Answers  

---