Answer / s

DIGITS will convert INTEGER to character string

SUBSTR(DIGITS(PARTID),5,1) ='9'
This will extract the 5th character and checks to see if it
is 9.

What is role in db2?

1 Answers  

---

What is the difference between primary key & unique index ?

6 Answers   Patni, Temenos,

---

Hi Dude,this is Ram.could any one tell me aboue CURRENT OF clause in DB2. Thanks in advance.......

2 Answers  

---

I HAVE 2 TABLES ONE IS EMP_TABLE AND ANOTHER DEPT_TABLE.EMP_TABLE CONTAINS NAME,DEPTNO,DEPTNAME,LOCATION AND DEPT_TABLE CONTAINS DEPTNO,DOJ(DATE OF JOINING).I WANT TO DISPLAY NAME,DEPTNAME,DOJ AND WHO ARE JOINED BETWEN 01- JAN-2007 TO 01-JAN-2008?

6 Answers   Perot Systems,

---

What are the bind parameters ibm db2?

1 Answers  

---

Bind concepts in DB2 cobol

10 Answers   IBM, TCS, TRD, Virtusa,

---

In cobol+DB2program if the code of cobol program has changed than i have to do precompilation once again?

6 Answers   TCS,

---

I have two tables A and B. Both tables are connected with SSN number as foreign key. I want to retrieve a column data from B table. How will you write a query?

3 Answers   CTS,

---

What is a result table?

1 Answers  

---

WHAT IS MEANT BY COMMIT COMMAND?

7 Answers   Wipro,

---

What are the abend codes occour in ur latest PROJECT in DB2

2 Answers   Cap Gemini,

---

Q3. How will you fetch duplicate values from a DB2 table?

2 Answers   RBS,

---