How can the firstname and the lastname from the emp table be concatenated to generate complete names?

0 Answers  

---

what is the syntax for FOR UPDATE CLAUSE in cursor declaration and how can u update using cursor? is it possible to update multiple rows at a time.

2 Answers   Syntel,

---

How do you insert a record with a nullable column?

2 Answers  

---

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

2 Answers   UST,

---

Name the lockable units in DB2?

0 Answers  

---

What is reorg and runstats in db2?

0 Answers  

---

What is runstats utility in db2?

0 Answers  

---

select distinct(empid),distinct(dept),name from EMP will the above query work?

2 Answers   CTS,

---

What is ACQUIRE/RELEASE in BIND?

3 Answers   Cognizant,

---

Q1. How will you use two different DB2 qualifiers in a single COBOL program? Suppose we have 2 tables EMP1 and EMP2 with same structure defined in two different DB2 qualifiers QUAL1.EMP1 and QUAL2.EMP2 now during first 15 days we want to use QUAL1.EMP1 and rest of the days QUAL2.EMP2  how will we do this.  We can create a single program and a single load for this program. 

2 Answers   RBS,

---

What is the purpose of the QUIESE Utility?

1 Answers  

---

what is consistency token

3 Answers  

---