Re: TIMESTAMP(12) with System Period Temporal Tables

Thanks Joep.

Glynn



On 28/04/18 21:08, Joep Beckeringh wrote:

Jonathan,

Temporal tables need a few specific columns (<https://www.ibm.com/support/knowledgecenter/en/ssw_ibm_i_73/rzahf/rzahftmprltt.htm>); row start and row end are automatically filled by the system. These column contain the values ending on '000244'.

Joep Beckeringh


Op 28-4-2018 om 13:52 schreef Jonathan Wilson:

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