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.

Explain dclgen.

1 Answers  

---

What is difference between rollback and commit?

1 Answers  

---

why should we bind the DB2 program . What if we did not BIND a BD2 program ??

9 Answers   Infosys, TCS, Xansa,

---

Outputs of explain are with matchcols = 0. What does this signify?

1 Answers  

---

I want to fetch the 10th row of a table which has been changed.How can I do it without going thru all the rows.

5 Answers  

---

How can you find out the # of rows updated after an update statement?

1 Answers  

---

run jcl for cobol+db2 pgm?.. //jobcard //step001 exec pgm=ikjeft01 //systin dd * DSNSYSTEM(--------) RUN PROGRAM(MYPGMNAME) PLAN(-----), LIB(-------), PARMS(------) /* WHAT WILL U GIVE INSIDE THE BRACKETS... WHAT IS PLAN,PACKAGE,BIND?..PLAN N PACAKGES ARE GENERATED BY ?...

1 Answers   IBM,

---

I have a main program (A) where we delete some rows in table in a cursor, and we commit it in sub program(B). What will happen - will we get an error or not?

2 Answers  

---

What is a dbrm in db2?

1 Answers  

---

Can one database have multiple instances?

1 Answers  

---

how to fetch multiple records without using cursor

14 Answers   HCL,

---

What is the physical storage length of each of the following DB2 data types: DATE, TIME, TIMESTAMP?

1 Answers   CTS,

---