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,

---

Do we have any optinon to search part of integer in DB2 as we have for character Like,SUBSTR optins?

1 Answers  

---

Request to database but database is not available so what is was abend is raised?

2 Answers   UST,

---

How do run the JCL which has 25 steps by skipping the following steps 5, 10,15 and 25 without using COND statement

5 Answers   Syntel,

---

What is CHECK PENDING ?

5 Answers  

---

What is a root page?

1 Answers  

---

i hav created a program and moved to production but failed to create the table which is been used in the program. the program shows error as soon as it is moved or installed in production or shows error during its runtime. what is the sqlcode for this error

3 Answers   UST,

---

Mention and explain the contention situations caused by locks?

1 Answers  

---

How will you delete duplicate records from a table?

7 Answers   Google,

---

What is iseries database?

0 Answers  

---

Why might full image copies be faster to implement than an incremental image copy?

4 Answers  

---

How to test SQL -911 error while developing COB-DB2 program

1 Answers   Satyam,

---