Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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


Please Help Members By Posting Answers For Below Questions

can anybody post me about file-aid and changemen tools pls and give me reference if any mainframe guys are there

2381


What rules are followed by the search verb.

1127


Describe the cobol database components?

1183


How are the next sentence and continue different from each other?

1301


Can a Search can be done on a table with or without Index?

1292


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.

2439


What is the difference between structured cobol programming and object alternativelyiented cobol?

1256


Why do we code s9 (4) comp. Inspite of knowing comp-3 will occupy less space?

1156


What is rmode(any) ?

1276


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?

1208


Why occurs cannot be used in 01 level in COBOL?

1164


What are the access modes of START statement?

1275


How to get the last record in vsam file in cluster? And how can you get the ksds file records into your cobol program?

1145


INREC AND OUTREC? HOW TO SPLIT 5K RECORDS TO DIFFERENT FILES IN A FILE IN COBOL? RESTART IN COBOL-DB2? ISOLATION LEVELS?

868


Explain how you can characterize tables in cobol?

1063