Unique number generator...

[Latimer, Richard]

Chris,


We use the following as a date/time stamp (with a real cute picture
statement!!) which might work for you. Output is yyyymmddhhmmss. 

GLOBAL temp T_DTETME NUM*14 INITIAL               
            (SYSDATE * 10**6) + FLOOR(SYSTIME/100)


PH6.07E on AS/400 (which has hundredths of a second on it's systime!)


regards
Richard Latimer
Wellington MIS Manager
Airways New Zealand
Ph +64 4 471 4744
Fax +64 4 471 0395






-----Original Message-----
From: Gassett, Chris [mailto:Gassett@aavid.com]
Sent: Wednesday, 15 August 2001 5:27 a.m.
To: Powerhouse List (E-mail)
Subject: Unique number generator...


Anyone already have a unique number generater utilizing sysdate and systime?

POWERHOUSE813D

= = = = = = = = = = = = = = = = = = = = = = = = = = = =
Mailing list: powerh-l@lists.swau.edu
Subscribe: "subscribe" in message body to powerh-l-request@lists.swau.edu
Unsubscribe: "unsubscribe" in message body to
powerh-l-request@lists.swau.edu
http://lists.swau.edu/mailman/listinfo/powerh-l
This list is closed, thus to post to the list you must be a subscriber.


**********************************************************************
This electronic message together with any attachments is confidential. If
you receive it in error: (i) you must not use, disclose, copy or retain
it; (ii) please contact the sender immediately by reply email and then
delete the emails. Views expressed in this email may not be those of the
Airways Corporation of New Zealand Limited
**********************************************************************