Re: TIMESTAMP(12) with System Period Temporal Tables

Thanks Jonathan, Joep already beat me to it and replied with the information on how DB2 for i populates the time stamp field.

Glynn



On 28/04/18 12:52, Jonathan Wilson wrote:

On Fri, 2018-04-27 at 14:47 +0100, Glynn jones wrote:

Hi, I've created a system period temporal table as per documentation but
the last 6 digits of the TIMESTAMP(12) field all appear to have '000244'
in them.

I vaguely recall that timestamps are not filled to the full length
within RPG, but are within embedded SQL, so updates/writes truncate the
fractional time value; even if the timeststamp field is given a more
fractional value within the program.

That said, I am unsure how a *temporal timestamp* is written to the
record... as in, is the value given by the RPG program directly within
code, or behind the scenes with some compile time trick, or by the
underlying database. If its done directly within the RPG program, by
code or an unseen bit of code being generated at compile time, then my
guess is it still suffers from the limitation of timestamp fields within
RPG programs.

Any ideas?

Jon