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
- 9631 Views
- Keane India Ltd, I also Faced
- E-Mail Answers
Answer Posted / venkata subbaiah
Delete from table where rowid=500;
| Is This Answer Correct ? | 1 Yes | 6 No |
Post New Answer View All Answers
Which is the default, TEST BEFORE or TEST AFTER for a PERFORM statement?
what are decleratives in cobol?
How to remove 2 duplicate records and copy only one using job control language?
how to access the file from prodution from changeman tool and to submit a file to production
What the difference is between continue and next sentence?
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.
can anybody post me about file-aid and changemen tools pls and give me reference if any mainframe guys are there
how do you reference the variable block file formats from cobol programs
input= ,,,, mainframe training ,,, hyderabad .... location.... output1=$ mainframe training in hyderabad location$ output2=**** mainframe training in hyderabad location ****. In this pgn when we give input considering the spaces the output is displayed in this format.Like in the place of ,,,, $ should be displayed likewise.So please helpmeout.
Explain how will you differentiate between an internal and an external sort, the pros and cons, internal sort syntax etc
What is redefines clause in COBOL?
can anybody post me about file-aid and changemen tools pls and give me reference if any mainframe guys are there
Write a program that uses move corresponding.
Have you used the sort in your project?for this type of questions any working on real time project give the eg. with real time scenario.
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.
