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 hapens when we use CPYF command to copy a LF? On which PF will it be dependent???

7 Answers   HSBC, Systime,


Write a program to display prime numbers between 1 to 100 using RPGLE.

1 Answers  


Why Rpg/400 is Famous?

2 Answers   IBM,


can I touch the array during treatments?

0 Answers   IBM,


while i am using the dspmsg command on comman line in Mocha am getting error like Not authorized to message queue message my messagequeue Name? can anybody help me how to change my message queue Am anable to see my messages in message queue

1 Answers  






Are all these RPG/400 Interviewed Questions being asked recently? are current?

1 Answers  


what is the difference between the cpyf command crtdupobj command?

9 Answers   IBM,


without logical file we cannot access the data in physical file.but we specify physical file in the program(ie:- Ffile IF E k disk).how can it be accessed?

3 Answers   HSBC, TCS,


How to declare the dynamic(run time) array in rpgle? can you please give example

2 Answers   Polaris,


How to select highest score of each subject or how to select highest income of every month?

0 Answers  


In ProgramB there is a SBMJOB, which is a call to program C .There is also a CALL to program D from B. How would you check the program C has been executed in D?

4 Answers  


The PGMA calls PGMB.PGMB generates a report.The report should contain the called program name(PGMA).How do i get the called program name in PGMB to print it on the spool file?(calling program name should NOT be hard coded or passed as parameter to called program?

6 Answers  


Categories