On Thu, 28 Mar 2019 11:38:24 -0700, Sri h Kolusu wrote: >>I'm astonished; I'd expect data bases to log times of transactions. Or is >>that left the responsibility of the UI/API? > >When I say DB2 gives a static timestamp is when you are trying to get >EXISTING records from a DB2 table and append a time stamp. ... > OK. I RTFM. The term it uses in a few places is "time of the run". I'm happy that means the time of the SELECT rather than time of the FETCH. May I assume, since neither you nor Bernd said otherwise, that insertion of a row will use the instantaneous timestamp?
And disappointed, that the format has a granularity of at best µsec, sacrificing the uniqueness of the (E)TOD clock. Not an issue unless/until processors are fast enough to perform more than one transaction in that time. -- gil ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
