iSeries: Duplicate a table (with or without data)

Date: 2016-07-04

CREATE TABLE SCHEMA.NEW_TB AS (
SELECT *
FROM SCHEMA.OLD_TB
) WITH NO DATA;

CREATE TABLE SCHEMA.NEW_TB AS (
SELECT *
FROM SCHEMA.OLD_TB
) WITH DATA;

2770cookie-checkiSeries: Duplicate a table (with or without data)