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.

What is bind plan?

0 Answers  

---

What are the 4 environments which can access DB2 ?

2 Answers  

---

quary for 1> fetch last record 2> fetch in reverse order 3> fetch last 5 row 4> fetch second last record (their is no primary key) i think concept of count can be use for this in 4th

5 Answers  

---

What is cascading rollback?

0 Answers  

---

What is FREEPAGE and PCTFREE in TABLESPACE creation?

1 Answers  

---

what is copy pending and check pending ?

1 Answers   Xansa,

---

What is the difference between cursor and select statement?

0 Answers  

---

if suppose i am having an ACCOUNT table with 3 coloumns ACC. NO,ACC. NAME,ACC. AMOUNT . If a unique index is also defined on ACC.NO and ACC.NAME then write a query to retrieve account holders records who have more than 1 ACC.

8 Answers   Wipro,

---

Explain the contention situations caused by locks?

0 Answers  

---

When would you prefer to use VARCHAR?

3 Answers  

---

what is db2 restart?

0 Answers  

---

What is package in cobol db2?

0 Answers  

---