Re: Sv: OPNQRYF fun

["Scott P. Johnson" <sjohnson@xxxxxxxxxxxxx>]

Try something like this:

     C     WAEndT        SUBDUR    WAStrtT       SDDayMins:*MN
      *
     C                   IF        SDDayMins > 0
     C                   EVAL      WorkHrs = SDDayMins / 60
     C                   EVAL      WorkMns = SDDayMins - (WorkHrs * 60)
     C                   EVAL      SDTotHrs = %EDITW(WorkHrs:'0 H') +
     C                                        %EDITW(WorkMns:'0 M')
     C                   ELSE
     C                   CLEAR                   SDTotHrs
     C                   ENDIF

The above are snips from a VARPG pgm that I wrote for our dept
to track our work schedules.  It should work in RPG IV also.
Hope this helps you out.
------------------------------------------------------
Scott P. Johnson
Programmer/Analyst
IBM Certified Specialist - AS/400 RPG Programmer
Highsmith Inc.
W5527 Hwy 106, PO BOX 800
Fort Atkinson, WI 53538-0800
TEL:  920-563-9571                FAX:  920-563-7395
sjohnson@highsmith.com
www.highsmith.com
------------------------------------------------------

Henrik Krebs wrote:
> 
> Remember: OPNQRYF/SQL/RUNQRY/... We are just talking about frontends. The
> machine behind it is exactly the same.
> 
> If you want a completely other machine - try FMTDTA. This was actually an
> add-on to s/38: "S/3 convertion reformat utility" replacing the old s/3
> program $DSORT. Outdated? Try it on a very large flat arrival seq file.
> Hugh  -  it's finished way before OPNQRYF/SQL/RUNQRY had finished
> thinking about what to do. Maybe (I'm not shure - haven't installed
> TAATOOL) the 'frontend' SRTFIL is a part of V3R1M0-QURSTOOL. 'cause it
> isn't easy to use. Specifications are the same as that old s/3-ones.
> 
> ----------
> > Fra: Pat Barber <MBOCEANSIDE@postoffice.worldnet.att.net>
> > Til: MIDRANGE-L@midrange.com
> > Emne: Re: OPNQRYF fun
> > Dato: 16. april 1999 00:41
> >
> > Rob Berendt wrote:
> > >
> > > Yes, OPNQRYF is powerful.  But isn't it just for companies who are
> too cheap to buy SQL?
> >
> > Nope... just a very poorly documented utility.. that goes back to the
> > S/38...
+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---