Re: duplicate record Id's in multi user environment

The date, time and time stamp fields are not as excessive as DSPPFM would
lead you to believe. Given the following file:

File: ADATE       Test date, time & timestamp data types
Libr: CC#PGMPCD   Fmt: TESTREC
Mbr : ADATE                                    Scan:
 Seq Pg K Field      T  Len Fd Dd  From   To Text
   5  1   DATE1      L   10           1   10 DATE
  10  1   TIME1      T    8          11   18 TIME
  15  1   TSTMP      Z   26          19   44 TIMESTAMP

the SQL HEX function shows that the lengths are not actually what they seem:

....+....1....+....2....+....3....+....4....+...
DATE1     HEX ( DATE1 )
05/14/97    00256497        actual length 4 bytes

TIME1     HEX ( TIME1 )
15:02:45     150245         actual length 3 bytes

TSTMP                       HEX ( TSTMP )
1997-05-14-15.02.45.000000  00256497150245000000  actual length 10 bytes

At some level they're playing tricks, and it's apparently a pretty low level
since DSPPFM shows the formatted date, time and timestamp.

But that only seems to prove that IBM isn't wasting disk space for formatting characters (great info, thanks!); it does not prove that IBM isn't providing the precision they present with e.g. a DSPPFM. (That RPG's TIME isn't delivering the last 3 digits of the timestamp is another story)

Besides of the fact that a timestamp can never be unique (just let the machine be fast enough and let there be enough users - not now, in e.g. 5 years!).

Mit freundlichen Grüssen / best regards

Anton Gombkötö

e-mail Office   :       mailto:Anton.Gombkoetoe@avenum.com
Homepage        :       http://www.avenum.com

---

Avenum Technologie GmbH
Brigittenauer Lände 50-54, Stiege 6     Salzburger Strasse 29   Dreifelder Strasse 4
A-1200 Wien / Austria                   A-5163 Mattsee          D-70599 Stuttgart

Tel./phone      :       +43-1/92101-148         +43-6217/5995 - 0               +49-711/4411 116
Fax             :       +43-1/92101-300         +43-6217/5995 - 13      +49-711/4411 563

---

Avenum ist der Zusammenschluss von AS Software und Black System.

---

+--- | This is the RPG/400 Mailing List! | To submit a new message, send your mail to RPG400-L@midrange.com. | To subscribe to this list send email to RPG400-L-SUB@midrange.com. | To unsubscribe from this list send email to RPG400-L-UNSUB@midrange.com. | Questions should be directed to the list owner/operator: david@midrange.com +---