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

Question Posted / anurag

2 Answers
8125 Views
L&T, I also Faced
E-Mail Answers

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

parameters cannot be passed in which one??

2 Answers CTS,

what do you mean by an input subfile, what are the keywords required?

0 Answers IBM,

What is the diff bw PF/LF Name and their Record format name? what is restriction in record format then file name?

0 Answers Wipro,

what happens when sflsiz = sflpag? What are the advantages and disadvantages?