×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
Another way is to use CREATE TABLE in a "field reference file" context:
CREATE TABLE newTable as
(SELECT field1, field3, field17 FROM fldRfcTbl)
WITH NO DATA
There are number of other parms on CREATE TABLE to investigate (i.e.
INCLUDING IDENTITY COLUMN ATTRIBUTES or starting with V5R4 new RCDFMT
keyword).
Check them all out here:
http://publib.boulder.ibm.com/infocenter/iseries/v5r4/topic/db2/rbafzmsthcta
bl.htm
HTH, Elvis
Celebrating 10-Years of SQL Performance Excellence
http://centerfieldtechnology.com/training.asp
-----Original Message-----
Subject: SQL DDL Create Table Names
I just started using DDL to define tables so this is certainly a newbie
question.
I have a lot of tables with exactly the same layout, but different
names. Is there a way to override the file name on the CREATE statement
[CREATE TABLE ARMAST ( , for example] so that I can use the same source
member to create different files? Even files that still use the S/36
group file id (such as A.ARMAST)? Same question as it relates to the
ALTER TABLE.
I saw in the RUNSQLSTM command the DFTRDBCOL parameter to tell it the
name of the schema (library), but I didn't see anything about the table
name.
midrange.com
