Interested to Buy Any Domain ? << Click Here >> for more details...
In my table having 3000 Records. How can I delete the 500th
row? (we don't know what is data inside the table)
- 3 Answers
- 10391 Views
- Keane India Ltd, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / pratap
delete from table where ROWNUM = 500;
As per IBM notes ROWNUM is support feature in DB2.
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / suraj kumar pathak
SELECT * FROM (SELECT col1,col2,col3, rownumber() over() AS rn FROM tab1) as tr WHERE rn = 500;
| Is This Answer Correct ? | 4 Yes | 5 No |
How do you differentiate between cobol and cobol-ii?
How can we find that module can be called – whether DYNAMICALLY or STATICALLY?
copy 100 records without using ibm utilities
) How do u handle errors in BMS macro?
How do pass the values to the parameters in cobol
Using string statement.Is coding three destination string from one source string possible in one code?or three codes for every destination string of one source string.?thank you
What is a subscript ?
What is JOBLIB and STEPLIB in JCL? what is the purpose of using it?
wht is packed decimal in cobol
I have a field with data type X(10). I want to perform arithmetic operation on this field? I tried doing it by moving the value into a numeric field. but it didn't work out. I am getting a S0C7 abend. Pls let me know if there is any way of getting this done?
What are the cobol coding sheets?
What are ISOLATION LEVELS? Where do we need to specify them in compiling JCL (Exactly which statement and what is syntax for it)?
COBOL 
