Can anyone help me w/ the query below. I am trying to create a table from another table.

SQL:
create table cca8380.testing as select * from card.mktg_cmpgn;

Have a look into the CREATE TABLE Statement in SQL reference corresponding to your platform, version of your product

Cheers
Sathyaram

In Ver 8.1 you can also do CREATE TABLE x like MyTable....

It can do more than "as select *..."

Andy

But usually:

create table x.y as (select statement) definition only

Will work

B.O.W.

you can copy a table whit the export/import statement, example:

EXPORT TO "E:\PROGRA~1\IBM\SQLLIB\WEBCPTAB.IXF" OF IXF MESSAGES "E:\PROGRA~1\IBM\SQLLIB\WEBCPTAB.EXM" SELECT * FROM DB2DWAD1.A0_2MESESATRAS;

IMPORT FROM "E:\PROGRA~1\IBM\SQLLIB\WEBCPTAB.IXF" OF IXF MESSAGES "E:\PROGRA~1\IBM\SQLLIB\WEBCPTAB.IMM" CREATE INTO DB2INST1.NEWTABLE IN TBATTRIB INDEX IN TBINDEX LONG IN TBLOB;