Answer / praveen

passing the value

Answer / ravinder dudimatla

PARM is also one of the way to pass the values/data to the propgram and the maximum amount of data which we can send to the program using the PARM Parameter is 100 characters we will declare PARM under linkage section as below:
01 PARM-VALUE.
05 PARM-LENGTH PIC S(9)4 COMP.
05 PARM-TEXT PIC X(100).

PARM-BUFFER is for lenght of the parm value passed thrugh the PARM and PARM-TEXT will have the input data passed through the PARM.

how will i display the duplicate record's from a table... i don't want to eliminate ...i want to display the duplicate record...for example in my table i have 10 record's like record no(1,2,3,4,2,9,6,1) in this ...so i want to receive duplicates...

1 Answers   UST,

---

Describe major components of db2?

0 Answers  

---

I HAVE 500 ROW TO UPDATE I WOULD LIKE TO USE ROLLBACK ALONG WITH COMMIT.WHAT IS THE SYNTAX TO CODE COMMIT AND ROLLBACK FOR EVERY 100 ROWS.AND HOW THE CURSOR ROLLBACK TO THE LAST COMMITTING POINT.

0 Answers   ITC Infotech, Syntel,

---

What do you mean by commit and rollback?

0 Answers  

---

what is the syntax for FOR UPDATE CLAUSE in cursor declaration and how can u update using cursor? is it possible to update multiple rows at a time.

2 Answers   Syntel,

---

What is explain plan in db2?

0 Answers  

---

What are the rules for db2 programming?

0 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  

---

pls explain the precompilation process of cobol-db2 pgm

3 Answers   HCL, IBM,

---

How to handle null values in db2

4 Answers  

---

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,

---

how to check the table is empty or not?

3 Answers   IBM,

---