RE: TimeStamp Resolution

Thank you for the suggestion.

Jack Derham
Direct Systems, Inc.

-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-bounces@xxxxxxxxxxxx]
On Behalf Of HauserSSS
Sent: Monday, January 02, 2006 2:19 AM
To: RPG programming on the AS400 / iSeries
Subject: AW: TimeStamp Resolution

The easiest way to get the current timestamp with all 6 position of
microseconds is to use embedded SQL:

C/Exec SQL   Set :MyTimeStamp = Current_Timestamp
C/End-Exec

Mit freundlichen Gru?en / Best regards

Birgitta

"Shoot for the moon, even if you miss, you'll land among the stars."
(Les Brown)

-----Ursprungliche Nachricht-----
Von: rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx]Im Auftrag von Jack Derham
Gesendet: Montag, 2. Januar 2006 05:03
An: 'RPG programming on the AS400 / iSeries'
Betreff: RE: TimeStamp Resolution


Thanks Bob. Happy New Year!

Jack Derham
Direct Systems, Inc.

-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-bounces@xxxxxxxxxxxx]
On Behalf Of Bob Cozzi
Sent: Sunday, January 01, 2006 1:51 PM
To: 'RPG programming on the AS400 / iSeries'
Subject: RE: TimeStamp Resolution

Check out gettimeofday() or Qp0zGetTimeofDay() for microsecond-level time
retrieval.


-Bob Cozzi
www.RPGxTools.com
RPG xTools - Enjoy programming again.

-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-bounces@xxxxxxxxxxxx]
On Behalf Of Jack Derham
Sent: Saturday, December 31, 2005 11:29 PM
To: RPG programming on the AS400 / iSeries
Subject: TimeStamp Resolution



Have a problem with TimeStamp resolution. Have a conversion program that is
using an Audit File to record events of the processing. The DDS for this
file defines it as a unique keyed file with a TimeStamp type field as the
unique key value. The conversion program extracts the current TimeStamp
value using op code TIME. As you all know this returns a TimeStamp value
with seconds down to only three places while the format allows for six. The
processing in this program can generate audit records at a rate which faster
then the resolution of the TIME timestamp and resulted in "Duplicate Record"
messages. A work around using a save timestamp value last used and a check
to see if the current timestamp gets around the problem.



My question - is there a method by which I can extract the timestamp value
to its full definition value?



Jack Derham

Direct Systems, Inc.







--
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.




--
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.



--
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.