Answer / ravi & dhana

10 HNAME.
49 HNAME-LEN PIC S9(4) USAGE COMP.
49 HNAME-TEXT PIC X(10).

Answer / a

its
10 HNAME.
49 HNAME-LEN PIC S9999 USAGE COMP.
49 HNAME-TXT PIC X(10).

that's it.

How can the duplicate values be eliminated from db2 select?

0 Answers  

---

What is an intent lock?

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

---

Do we need cursor for Count(*)?

4 Answers   iGate,

---

Explain dclgen.

0 Answers  

---

---

How is the SUBSTR keyword used in sql?

1 Answers  

---

Where could you look if you had a question about whether a column has been defined as an index?

2 Answers  

---

What is rct?

0 Answers  

---

How can you classify the locks in db2?

0 Answers  

---

Explain an outer join?

1 Answers  

---

What is a DB2 bind?

3 Answers  

---

How do I handle -911 (deadlock) error in a db2 program so that the program will never abend?

3 Answers   CTS, IBM,

---