In my table having 3000 Records. How can I delete the 500th
row? (we don't know what is data inside the table)
Answer Posted / 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 |
Post New Answer View All Answers
What rules are followed by the search verb.
How to get the last record in vsam file in cluster? And how can you get the ksds file records into your cobol program?
What is the usage of comp fields in cobol?
How to use the same COBOL program in Batch and CICS on lines? explain with an example
write a cobol logic. i have file that has 10 records .1 record go to first output file and second record goes to 2 output and etc
How arrays can be defined in COBOL?
i want to learn mainframe..any websites and material to learn from basic..? my mail id : rajeswaribe2010@gmail.com
Why is it necessary that file needs to be opened in I-O mode for REWRITE?
how do you reference the ksds vsam file formats from cobol programs
how to convert the recors form vsam file to db2 table tru file aid
Write a program that uses move corresponding.
1.Is it possible to move the data from 99.99 to 99v99? 2.What is the CICS-vsam Compilation process? 3.In My GDG 5 generation will be there GDG3 got an abend what will happen? 4.In my GDG first generation is +1 And I want to add the new generation what will happen previous generation? 5.How can you give the PIC clause below conditions A). s9 (reddy), B). s9 (5) occurs 5 times? 6.How override the proc from a particular step? and what is symbolic and override Procs?
what are decleratives in cobol?
System Testing for Mainframe Developers What is System Testing? integration testing ? what's the procedure ..
how do you reference the variable unblock file formats from cobol programs