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
- 10389 Views
- Keane India Ltd, I also Faced
- E-Mail Answers
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 are declaratives and what are their uses in cobol?
which is Best IBM Mainframe Training and Placement Institute in Ameerpet Hyderabad
I have to write to a outfile where the number of records in that file should be the header of that file using IMS.. can anyone help me in this issue
how do you reference the rrds file formats from cobol programs
What is the problem of ordered sequential files access?
here is my requirement A1 is alphanumeric with value 'A1B2C3D4' as defined below 05 A1 PIC X(8) VALUE IS 'A1B2C3D4' but i need to have A2,A3 as ABCD & 1234 repectively...... A2 = ABCD A3 = 1234 Can you please explain me what are the different ways to do it?
can anybody post me about file-aid and changemen tools pls and give me reference if any mainframe guys are there
What rules are followed by the search verb.
What is the Purpose of Pointer in the string?
I have one ps file in which there are 3 fileds emp_no,emp_name and leave_app.this ps file information give the detail of employee which is going to apply for leave.suppose emp_no=113430,emp_name=ajay,leave_app=1 that means he is going to apply for 1 day leave.and accordingling the table in db2 will be updated means if he has that no of leave in his account then he will get dat leave and updated acc. in table(leave_balance=previous leave present in table-leave_app).Now i want to check whther the updated result is correct or not by comparing the two ps file using IEBCOMPARE or icetool so what is going to be the two ps file and how its is going to be compare.
Write a program that uses move corresponding.
How to read the 2nd last record of a VSAM file? (The file size is huge and we don't know the key)
In COBOL, what is the different between index and subscript?
What is rmode(any) ?
How do you differentiate between cobol and cobol-ii?
