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
- 10202 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 |
What is Redefines clause?
How can we increase the size of an existing PDS to include more no. of modules.
What is the different between index and subscript?
what is redefines? where it can be effectively use for the purpose of memory utilization? give an example?
how will u pass dadta to cobol+db2 program...?
I have a sequential file of 100 records. How do I load the records into a two dimensional array ?
What is the utilization of copybook in cobol? Could we utilize a similar copybook?
When would you use in-line perform?
How can i load all the data from a file to Table (array) in cobol.How i manage the occurs clause with out reading the file.Any options avilable ? Please can any one help me it is urgent?
What is the difference between structured cobol programming and object alternativelyiented cobol?
How to declare if emp-name = AAAAA""BBB in working-storage section. After display emp-name should print like AAAAA""BB
i want to enter the name 'pandu' into ur table how?
COBOL 
