IBM Support

Create OR REPLACE Table



CREATE TABLE enhanced with OR REPLACE option


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":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SWG60","label":"IBM i"},"Component":"","Platform":[{"code":"PF012","label":"IBM i"}],"Version":"All Versions","Edition":"","Line of Business":{"code":"LOB57","label":"Power"}}]

Document Information

Modified date:
13 January 2020