Re: Use sql to calculate a time difference between 2 records

On Fri, Apr 2, 2010 at 22:22, Musselman, Paul
<pmusselman@xxxxxxxxxxxxxxxx> wrote:

We had an application that time stamped all of the transactions in its
log file. ÂBut they came in so fast that multiple records had the same
time stamp! ÂThe solution was to have the application delay for a
fraction of a second between writes so the time stamps were unique.

That doesn't sound like a solution to me. More like an ugly workaround
that's going to break at some point.

DB2 doesn't have built-in support for GUIDs yet, so you need to write
your own stored procs, but that's still the right way to go if you
need to uniquely identify something.

The IBM i platform might not require a full-time DBA position, but you
still need developers that understand databases.