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
Was this topic helpful?
13 January 2020