i want to retrieve record b/w 2 dates in as400
Answer Posted / 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 View All Answers
How to call one program from another program in RPG? please help me with the code
how do I play {insert rpg system here}?
what is program status data structure?
how do I declare a minor?
Set on command is used for closed all opened files , initialize var and release resource , return cmd is used for return to calling program but my req. Is dnt close opened files and resource must released while doing transactions , how can i do this...?
what is an online rpg?
What is the purpose of record level identifier?
explain sflclr, sflend, sfldlt, and sflcsrrrn?
What is difference between bind by copy and bind by reference?
How to write record if no field or the field are different in physical file in rpgle ?
When we have a file with Duplicate records and I want to read the unique record from the file. For example a file containing Emp Name as 'Ram' and there are 3 entries of it. So how to read a unique record from File?
How can we override a file during runtime in rpg?
do you use message subfiles? What are the necessary keywords required coding a message subfile?
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.
which program rpg or cl is efficent to update a transaction onto a database file and why ?