Interested to Buy Any Domain ? << Click Here >> for more details...
i want to retrieve record b/w 2 dates in as400
- 2 Answers
- 8265 Views
- L&T, I also Faced
- E-Mail Answers
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
what are the key words you must use when using a subfile?
can any one help in hawkeye and turnover or any change management system plzzzzz or send the documents to my mail id :gvsp.as4@gmail.com
How to declare the pull button in AS/400..
What is ment by record level identifier?
What is the diff bw PF/LF Name and their Record format name? what is restriction in record format then file name?
what was the robotech rpg?
what is the necessary keyword needed to scroll subfile records?
what is file information data structure?
what is the rpg system?
what is the procedure and explain about real time scenario.
Suppose we have one database file and it is used by 5 programs and in 3 program we have to add some records in datbase file s what is the impact on other program?
how do you use commitment control in rpg?
what is the use of sflnxtchg?
Q:HI friends accually ihave one problem plesase let me know the alternate code of this code. Related field description of code: Add a field, CALvsPRD, "Calendar Day Starts Before/After Production Day" to the parameter set WRKORDER which accepts values 'A' or 'B' o B = Calendar Day Starts Before Production Day o A = Calendar Day Starts After Production Day o Any other value indicates the production and calendar dates are always the same. code: Automatic Execution Of *INZSR Subroutine /Z01 * retrieves WRKORDER field values. /Z01 * Calculate default Production Date and return it to caller. /Z01 * Production date defaults to system date /Z01 C Eval P@Pdate = %DATE() /Z01 * unless Calendar date starts Before PDN(production) date and /Z01 * system time is before PDN Start Time then /Z01 * PDN date is yesterday. /Z01 C If W@CALvsPRD = 'B' and /Z01 C %TIME() < %TIME (W@Strtime) /Z01 C Eval P@Pdate -= %Day(1) /Z01 * unless Calendar date starts After PDN date and /Z01 * system time is *GE PDN(production) Start Time then /Z01 * PDN date is tomorrow. /Z01 C ElseIf W@CALvsPRD = 'A' and W@Strtime > *Zero and /Z01 C %TIME() >= %TIME (W@STrtime) /Z01 C Eval P@Pdate += %Day(1) /Z01 C EndIf /Z01 C Eval *InLr = *On
how do I declare a minor?
