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.

OUTER JOINS USED TO GET MATCHING AND NONMATCHING ROWS FORM 2 OR MORE TABLES BASED ON COLUMNS. SIMPLE JOINS ALSO DO THE SAME THEN WHAT IS THE USE OF OUTER JOINS.

1 Answers   Syntel,

---

what are the max. & min. no. of partitions allowed in a partition tablespace?

2 Answers   IBM,

---

Update command

1 Answers  

---

How can record locking be achieved in those DB2 versions which do not support it?

0 Answers  

---

What is the purpose of the SDSNLOAD dataset in the STEPLIB while running DB2 programs?

2 Answers  

---

How could one combine a set of incremental image copies into a single copy?

1 Answers  

---

What is consistency token in db2?

0 Answers  

---

How would you print the output of an SQL statement from SPUFI?

2 Answers  

---

How does DB2 determine what lock-size to use?

2 Answers  

---

A Table feild is declared as Decimal(7,2). I want to insert the decimal in to this column thru cobol-db2 program. How should I declare my local input file variable or any suggestion?

7 Answers   IBM,

---

What is isolation level?

4 Answers  

---

How to access db2 tables in mainframe?

0 Answers  

---