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;

What happens in the background of spool when we submit a job for compilation and execution... This is a recent question in ibm...Kindly help me.....

3 Answers   IBM,

---

What is difference between static and dynamic call in cobol?

0 Answers  

---

Suppose i want to declare a binary comp fild of 7 byte .how to write?

6 Answers   IBM,

---

COMP field occupy ?

2 Answers  

---

what is rediffine clause?in what situation it can use?give me real time example?

1 Answers   IBM,

---

What is the difference between NEXT SENTENCE and CONTINUE?

2 Answers   Mphasis,

---

Program A (Normal COBBAT) calling a B Program (DB2COBOL, COBBATDB which is using a VSAM file. its a dynamic call. How we will handle VSAM file decleration in our from JCL from where we are running A PGM. And should we have PLAN for A pGM also. if possible can some one post a sample JCL. Thanks for help in advance.

0 Answers   iNautix,

---

TO abend the data sholud open in which mode? 1.new 2.old 3.mod 4.shr

1 Answers   MNC,

---

If there are two copybooks which have same variables and we are using both the copybooks in our program. will there be an error and if i move values to the variable which copybook varibales gets the values i move in.

3 Answers   CTS,

---

What is the use of intialize verb?

0 Answers  

---

77 a pic x(4) value '1234' -----> instead of this 'abcd' 77 b pic 9(4) value zeros. move a to b what is the answers for both cases? IS it possible? Give me elementary move rules briefly......

8 Answers  

---

soc-7 is a bad data,invalid data. when ever we are moving the alphabets in the position of numeric then we got this abend. so my question is if o1 ws-data pic 9(1) value passing the alphabet some x. then we got soc-7 or not? i want clarification ?

7 Answers   CitiGroup, IBM,

---