Answer / pratap

delete from table where ROWNUM = 500;
As per IBM notes ROWNUM is support feature in DB2.

Answer / suraj kumar pathak

SELECT * FROM (SELECT col1,col2,col3, rownumber() over() AS rn FROM tab1) as tr WHERE rn = 500;

Answer / venkata subbaiah

Delete from table where rowid=500;

how many subpgms we can use in a main pgm ? how do u link sub pgm to main pgm ? how can i use the parameters declared in main pgm to sub pgm ?

2 Answers   TCS,

---

what is the difference between Plan & package

3 Answers   IBM,

---

where will we code call by content and call by reference dude pls reply soon ?

2 Answers  

---

What should be the sorting order for SEARCH ALL?

5 Answers  

---

wht is load module and object module ?

2 Answers   DELL, TCS,

---

Differentiate cobol and cobol-ii. (Most of our programs are written in cobolii, so, it is good to know, how, this is different from cobol)?

0 Answers  

---

WORKING-STORAGE SECTION. 01 VAR1 COMP-2 VALUE 0. PROCEDURE DIVISION. MOVE 10.2115 TO VAR1. DISPLAY 'VAR1 =' VAR1. GOBACK. 10.2115 is stored as .10211499999999996E 02 in OS VS Cobol 10.2115 is stored as .10211500000000000E 02 in ecobol. Any reason why?

3 Answers   TCS,

---

What will happen if we try to create GDG (+2) generaton instead of (+1) generation?

1 Answers  

---

Can we move SPACES to numeric field and ZEROES to alphabetic field? If yes what are the way doing this?

6 Answers   T systems,

---

What are various search techniques in cobol? Explain.

0 Answers  

---

What type of SDLC u followed? Why?

0 Answers   IBM,

---

Can the OCCURS clause be at the 01 level?

2 Answers  

---