select 100 records from million records ?

2 Answers   Verizon,

---

Is db2 a mainframe database?

0 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,

---

Generally if I want to select the names starting with c I need to use c% But how could I code to select the data which contains % as a part of data.

5 Answers  

---

Define predicate?

0 Answers  

---

---

How can we retrieve the total number of records in RPG & CLLE?

0 Answers  

---

What is explain in db2?

0 Answers  

---

How do I create a table MANAGER (EMP-NO, MANAGER) where MANAGER is a foreign key which references to EMP-NO in the same table? Give the exact DDL.

3 Answers  

---

What is the max length of sqlca?

0 Answers  

---

What is declare cursor?

0 Answers  

---

What's The Percentage Free Space ?

0 Answers   IBM,

---

What is meant by index cardinality?

2 Answers  

---