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 to resolve the soc4 and soc7 errors?

5 Answers   IBM, RBS,

---

A table has two indexes defined. Which one will be used by the SEARCH?

0 Answers  

---

how can we code index in an array of cobol pgm?

1 Answers   Wipro,

---

1.give the details about WHEN OTHER. 2. how many form are available in evaluate.

0 Answers   IBM,

---

What is XDC ?

3 Answers   Cap Gemini, IBM,

---

i have 10 names in an array and my name is one of them also array is not in sorted order i need to display my name using index how will i do this

0 Answers  

---

RENAME clause takes new SPACE in memory.TRUE or FALSE? a)TRUE 2)FALSE

12 Answers   TCS,

---

How can we increase the size of an existing PDS to include more no. of modules. I tried the answer posted by Jagan(TSO PDS 'pds name') but did not find it working. The answer posted by kamal i know very well. Please suggest me a answer so that we don't need to delete the existing PDS and still we can change the size as well.

10 Answers  

---

01 a pic x(6) value is abcdef 01 b pic x(3) move a to b wht will be the value in b ?

3 Answers   Patni,

---

period is missing in the cobol program which error we getting

5 Answers   TCS, Tesco,

---

Can you please let me know the centre name of INS certification in Kolkata.

0 Answers  

---

If my file contains 100,000 records and job abended at 55,000th records processing then how can i restart job from that record onward by ignoring that record. I can not edit the file as file size is big and it is getting browse substituted?

5 Answers   TCS,

---