What if , we failed to mentioed null indicator in sql select query , that may retrieve null value ?

2 Answers   Cap Gemini,

---

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,

---

How to access db2 tables in mainframe?

0 Answers  

---

What is the difference between bind and rebind in db2?

0 Answers  

---

What is the use of reorg in db2?

0 Answers  

---

---

What is the difference between group by and order by?

2 Answers   IBM, TCS,

---

List out the buffer pools in db2

0 Answers  

---

How do you declare a host variable (in COBOL) for an attribute named emp-name of type VARCHAR(25) ?

2 Answers   IBM, Tech Mahindra,

---

Can we delete records from view?

0 Answers  

---

On which levels locks can be applied?

0 Answers  

---

What is alias in db2?

0 Answers  

---

What is the difference between Where and Having Clause

7 Answers   IBM, iFlex,

---