i friends greetings to the day...!!! I face a quation
like"while runnig the programe every day i have to access
the previous day updates only...!! Ex:- Let last day 100
customers took bank account i have to select those
customers only.."
Answer Posted / sa
If the database is getting updated daily with the records,
next day you can write the query which will have records
only for the current day.
Select * from Lib/Database
where WS-Date > Give the date when the database is last updated
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
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.
Describe the cobol database components?
How are the next sentence and continue different from each other?
Can a Search can be done on a table with or without Index?
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.
What is the difference between structured cobol programming and object alternativelyiented cobol?
Why do we code s9 (4) comp. Inspite of knowing comp-3 will occupy less space?
What is rmode(any) ?
How do you code cobol to access a parameter that has been defined in jcl? And do you code the parm parameter on the exec line in jcl?
Why occurs cannot be used in 01 level in COBOL?
What are the access modes of START statement?
How to get the last record in vsam file in cluster? And how can you get the ksds file records into your cobol program?
INREC AND OUTREC? HOW TO SPLIT 5K RECORDS TO DIFFERENT FILES IN A FILE IN COBOL? RESTART IN COBOL-DB2? ISOLATION LEVELS?
Explain how you can characterize tables in cobol?