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 the clustering index in the db2 database?

0 Answers  

---

What is the purpose of coding FETCH in a SQL SELECT query? Explain with an example in Detail?

4 Answers  

---

what is the steps followed in EXPLAIN Process or EXPLAIN command. (Explain is for identifying the optimized access path but how or what is the steps for doing the EXPLAIN)

4 Answers   IBM,

---

How to resolve -502 sql code in DB2?

2 Answers   Cap Gemini,

---

What happens in bind step in a db2 program?

0 Answers  

---

What is the COBOL picture clause of the following DB2 data types: DATE, TIME, TIMESTAMP?

3 Answers  

---

What are the rules for db2 programming?

0 Answers  

---

What is cursor?

2 Answers  

---

What is db2 instance?

0 Answers  

---

what is load and unload in db2

1 Answers   IBM,

---

Where besides the DB2 catalog is database object information stored by DB2?

1 Answers  

---

If the main program has only cobol statements and subprogram has the db2 statements what is the procedure for precompilation. for which program we need to do the precompilation

1 Answers   IBM,

---