IBM Support

Create OR REPLACE Table

News


Abstract

CREATE TABLE enhanced with OR REPLACE option

Content

Db2 for i is adding optional OR REPLACE capability to the CREATE TABLE SQL statement.  By moving to a replacement table strategy, customers should have a much easier approach for managing change.  Prior to this support, the user would need to construct the perfect ALTER TABLE statement or manually deal with removal and recreation of dependent objects.  With CREATE OR REPLACE TABLE, Db2 for i will manage these complex tasks.

See the SQL Reference for details: CREATE TABLE statement


Note: This support was enabled after the Db2 for i PTF Group with the following PTF:
IBM i 7.2:  5770SS1 SI57123


[{"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SWG60","label":"IBM i"},"Component":"","Platform":[{"code":"PF012","label":"IBM i"}],"Version":"All Versions","Edition":"","Line of Business":{"code":"LOB08","label":"Cognitive Systems"}}]

Document Information

Modified date:
13 January 2020

UID

ibm11164622