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 want to retrieve record b/w 2 dates in as400

Answer Posted / shishir

you can retrieve record between 2 dates is through openqry file :
ovrdbf share =*yes
oprnqry in condition there is a range parameter write those 2 dates between them
call program
dltovr
clof

Is This Answer Correct ?    0 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to call one program from another program in RPG? please help me with the code

1672


how do I play {insert rpg system here}?

981


what is program status data structure?

2284


how do I declare a minor?

1110


Set on command is used for closed all opened files , initialize var and release resource , return cmd is used for return to calling program but my req. Is dnt close opened files and resource must released while doing transactions , how can i do this...?

1990


what is an online rpg?

1197


What is the purpose of record level identifier?

1080


explain sflclr, sflend, sfldlt, and sflcsrrrn?

1301


What is difference between bind by copy and bind by reference?

2396


How to write record if no field or the field are different in physical file in rpgle ?

906


When we have a file with Duplicate records and I want to read the unique record from the file. For example a file containing Emp Name as 'Ram' and there are 3 entries of it. So how to read a unique record from File?

901


How can we override a file during runtime in rpg?

1141


do you use message subfiles? What are the necessary keywords required coding a message subfile?

1081


1. What is bound-by-call and bound-by-reference? 2. Where and why is *Nomain used? 3. What are the difficulties faced by programmers when using service programs? 4. Explain the different ways of parsing and compiling XML in iSeries.

6370


which program rpg or cl is efficent to update a transaction onto a database file and why ?

1198