i want to retrieve record b/w 2 dates in as400
Answer Posted / 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 |
Post New Answer View All Answers
what is the rpg system?
How to define data area in RPG program? In which scenario multi occurrence DS is use in AS400?
When it is desirable to describe files Internally?
how do I preserve and clean the array?
how does the rpg element work?
If my rpg program has a date field, what extra care I have to take while compiling that rpg program? If the file is keyed and I have declared the file as well as key list properly in my program. Still am getting an error message like "chain/reade operation is not allowed" what may be the case?
thanks mr.Harshad R Suryawaunshi,i'm new to as400 i think you are telling in rpgile i know only rpg400 if possible can you tell in rpg400
How Chain operation copies the record's data to the input buffer for the program?
1. If there are two programs using same file and 2 users are using the file at the same time and what can be done to allow them both to access? 2. How can remove lock from the file for accessing it by both users?
what do you mean by an input subfile, what are the keywords required?
How to handle duplicate error handling in RPG?
How to call one program from another program in RPG? please help me with the code
What is file identifier where we can use?
during execution, an rpg/400 program automatically follows a sequence of operations for each record that is processed. The built-in program cycle includes the following logical steps.
what is a rpg?