Allow Replace Table functionality for Temporal Tables

Attachment (Description): Error message received after adding field.

Attachment (Description): Temporal table after adding new field

I have an sql temporal (TMPTST2) and history table (TMPTST2HST) that I created in library ITGF (see attachments). The source for the temporal table uses "Create or Replace Table". I add a field to TMPTST2 (newfld1). I used the following statement to run sql TMPTST2 (with new field) : RUNSQLSTM SRCFILE(TOTTO/QSQLSRC) SRCMBR(TMPTST2) COMMIT(*NONE) DFTRDBCOL(ITGF). Based on your statements, I would expect the new field to be updated to the temporal and the history table. Instead I get the SQ20525 error with reason code 21 (see attachments). Am I doing this incorrectly? If so, what should I be doing differently? I wasn't able to attach all files. I'll try to add them separately from this update.

Attachment (Description): History table sql.

Attachment (Description): Temporal table as originally created.

Hi, did you know that Db2 for i automatically maintains the history table when you ALTER TABLE ADD COLUMN or ALTER COLUMN (to widen) or ALTER TABLE ADD PARTITION? In fact, you can use CREATE OR REPLACE TABLE as your means of making such changes to the system temporal table. The exception is when you make a change that could involve data loss. In those scenarios, we require that you temporarily drop versioning and make the change(s) to both tables. However, you could still use CREATE OR REPLACE TABLE to make those changes.
Regards, Scott