Page Comparison

...

Liquibase Enterprise Version 8.1 and earlier does not support the create or replace command.
DB2 on zOS Version 12.1.5 and earlier does not support the create or replace command.

create tablespace and create table limitations

You cannot run both create tablespace and create table in the same packager run using DDL. For these commands to run successfully, you must run create tablespace in a separate packager before packaging create table as depicted below.

developerWorking/sql_code/sql_direct/create_tablespace.sql

CREATE TABLESPACE A2759TS IN A2759966 USING STOGROUP SYSDEFLT PRIQTY -1 SECQTY -1 DSSIZE 2 G MAXPARTITIONS 256 SEGSIZE 32 BUFFERPOOL BP16K0 CCSID EBCDIC LOCKMAX SYSTEM LOCKSIZE ROW MAXROWS 255;

developerWorking/sql_code/ddl/create_table_on_tablespace.sql

CREATE TABLE TABLE_04 (
    "ID" INTEGER NOT NULL,
    "NAME" VARCHAR(49))
    IN A2759966.A2759TS;

Alter Statements

The Alter View statement regenerates a view using an existing view definition at the current server. Alter view is primarily used during Db2 migration or when Db2 maintenance is applied.

...