RE: Milliseconds

[rob@xxxxxxxxx]

Then Peter's and Bob's examples should do the trick.  However, since you 
store it in character you'll have to convert it to time first.

If you want you can create a logical file that will do this for you.  Then 
your PC application could download that.

First create a simple RPG service program to convert the character field 
into milliseconds.  Must be a subprocedure in a service program.
Then create a User Defined Function, or UDF, based on this.
Then use SQL to create a view based on this UDF.
For more details you can look at:
http://faq.midrange.com/index.pl?_highlightWords=udf&file=185

Rob Berendt
-- 
"They that can give up essential liberty to obtain a little temporary 
safety deserve neither liberty nor safety." 
Benjamin Franklin 





"Peter Vidal" <Peter_Vidal@xxxxxxxx>
Sent by: rpg400-l-bounces@xxxxxxxxxxxx
08/06/2003 10:52 AM
Please respond to RPG programming on the AS400 / iSeries
 
        To:     RPG programming on the AS400 / iSeries 
<rpg400-l@xxxxxxxxxxxx>
        cc: 
        Fax to: 
        Subject:        RE: Milliseconds



"C              MyTime   SUBDUR   T'00:00:00'   Mili:*MS"

How big should be "MyTime"?

Peter Vidal
Pall Aeropower Corp.
SR Programmer Analyst
WWW.Pall.com / 727-539-8448, x2414

"A good player makes himself look good; a great player makes the team look
good."
Author unknown


_______________________________________________
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.