db2 Copy table with or without data Copy Table with where clause
Example
CREATE TABLE myschema.tableNew AS (
SELECT *
FROM myschema.tableOld
WHERE column1 = 'myCriteria'
) WITH DATA
CREATE TABLE myschema.tableNew AS (
SELECT *
FROM myschema.tableOld
WHERE column1 = 'myCriteria'
) WITH DATA
