What is nvl in db2?

0 Answers  

---

How can you count the number of rows from a table tab?

0 Answers  

---

what is utility for parm lib

0 Answers   IBM,

---

What is release/acquire in bind?

0 Answers  

---

What are the functions of Bind?

2 Answers   Amdocs, IBM,

---

---

in db2, already 10 columns arie der, and i want to insert 11th column. what parameters u wil consider for insertion and how will u insert

1 Answers   TCS,

---

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 is correlated subquery?

1 Answers  

---

If there is no row in Emp table with Ename as Raghava and you run the below queries in SPUFI. 1.select Ename from EMP wher Ename = 'raghava' 2.Select count(*) from EMP where Ename = 'raghava' What is SQLCODE shown up in SPUFI

4 Answers   ADP,

---

What is the difference between oracle and db2?

0 Answers  

---

can all users have the privilage to use the sql statement select * (dml)?

0 Answers   IBM,

---

What is the physical storage length of each of the following DB2 data types: DATE, TIME, TIMESTAMP?

1 Answers   CTS,

---