IBM Support

[Db2] How to load data into system-period temporal tables.

How To


Summary

Users might see one of the following errors to load data into system-period temporal tables.

SQL2437N The data movement command failed because the utility was unable to
resolve how implicitly hidden columns should be processed. No data was moved.

SQL3550W The field value in row "x" is not NULL, but the target column has
been defined as GENERATED ALWAYS.

SQL20535N The data change operation "LOAD" is not supported for the target
object "<table_name>" because of an implicit or explicit period specification
involving "SYSTEM_TIME". Reason code: "1".

SQL3016N An unexpected keyword "includeimplicitlyhidden" was found in the
filetmod parameter for the filetype.

Document Location

Worldwide

[{"Type":"MASTER","Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"ARM Category":[{"code":"a8m500000008PlJAAU","label":"Data Movement-\u003ELoad"}],"ARM Case Number":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"10.1.0;10.5.0;11.1.0;11.5.0"}]

Log InLog in to view more of this document

This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.

Document Information

Modified date:
30 April 2025

UID

ibm16604311

Page Feedback