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

What will be your approach in going either for OPNQRYF or Logical files. Which one to go for?

2 Answers  


when will come session device error?

4 Answers   TCS,


Can we have a Physical file without any member ? Please let me know

12 Answers  


In RPG program one file using as a PRIMARY file while running program some of the records reading twice any body know why its happening

2 Answers  


ESCAPE message sent by child program can be handled by parent program using which keyword?

2 Answers  






Can somebody tell me that, Is it possible to read all the member of PF without OVRDBF?

6 Answers  


How to print output from openquery in as400 ?

1 Answers   Four soft,


How can i keyed a flat file in RPGLE

5 Answers   IBM, Wipro,


Why did we give STRSRVJOB while debugging batch program

3 Answers   HBL Power Systems,


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.

2 Answers  


What will happen if we r using seton lr after return or vice versa.

5 Answers  


Hi, I am getting the error in RPG (All Record Formats for externally-described file ABCD ignored or dropped due to error; file ignored.) Please suggest any

2 Answers   Satyam,


Categories