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

Answers were Sorted based on User's Feedback



i want to retrieve record b/w 2 dates in as400..

Answer / vijay

Take date 1 and date 2 as date fields and give the condition as If date 1 > = date and date 2 < = date ;
dsply date ;
Endif; then u can retrieve the records based on the above condition.

Is This Answer Correct ?    0 Yes 1 No

i want to retrieve record b/w 2 dates in as400..

Answer / 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

More RPG400 Interview Questions

how do you use commitment control in rpg?

0 Answers   IBM,


Can anybody tell me that why we use option(*nodebugio)in H- Spec?

3 Answers  


1.I have a Physical file with 100 records, No duplicates exists, all are Unique,But while i am running Runqry utility i am getting only 80 records..What could be the reason?

3 Answers   Cap Gemini,


how to find whether a date format is valid or not in RPG400 not in RPGILE.Can you please write the coding for this sir,i'm new to AS400.Please help.

1 Answers  


What will be the value of STRING after line 0106 is executed in the code below? 0101 E* Fromfiletofile..tabnameprnentlenpdatabnamlenpda 0102 E ARR 8 1 0103 ISTRING DS 0104 I 1 8 ARR 0105 C MOVE *BLANK STRING 0106 C MOVEA'ABC' ARR A) 'AAAAAAAA' B) 'BBBBBBBB' C) 'CCCCCCCC' D) 'ABC ' E) ' ABC'

2 Answers  


How Commitment and Roll back control is used in as400, explain with real time senario ???

2 Answers   Acolite, HSBC,


explain sflclr, sflend, sfldlt, and sflcsrrrn?

0 Answers   IBM,


Mr.Sidc sirfor my question{how to convert date format from one format to another i think in CL/400 its CVTDAT,Please tell in RPG/400 sir not in RPGILE} you have answered using MOVE opcode,can you illustrate me with a small example sir very kind of you.

1 Answers   CTS, IBM, iGate,


can anyone explain aboutovrOVRDBF,OPNQRYF, OVRSCOPE and OPNSCOPE?

2 Answers   TCS,


What is the name of default out queue when user logs inn to syatem with valid profile?

3 Answers   IBM,


difference between 1:%found and %equal built function in detail with example .

6 Answers   Polaris,


How do you proceed in case your active AS400 session has got disconnected suddenly, how can you get back to your session ? Is it possible??

1 Answers  


Categories