Re: duplicate record Id's in multi user environment

[Anton Gombkötö <Gombkoetoe@xxxxxxxxxx>]

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