Re: SQL DDL Create Table Names

[Jerry Adams <jerry@xxxxxxxxxxxxxxx>]

Elvis,

Thanks for the link.  Though I hadn't checked that one out ahead of 
time, I had gone to a couple of others and some printed (gasp!) material 
beforehand. 


It may be that I am either not understanding the response or that I 
didn't make myself clear.  Which, in either case, is my fault.  So let's 
see if I can do at least a little better.


We can give a DDS source member any name, FILEJ, for example.  On the 
CRTPF or CHGPF commands there is a FILE parameter and the value used, 
JFILE, for example, points to (or creates) a specific file named JFILE 
based upon the source member (FILEJ) provided.  I.e., while usually the 
DDS source member and physical file have the same names, it ain't 
necessary; the name of the file to be created (or changed) is not 
inherent inside the DDS source member.


Now, if I understood your example and the other reading, "newTable" is 
the actual name of the table that will be created.  There is no way that 
I have seen/found to use this same source member to create "newTableX".  
Or is there?  If not, I'll have to stick with DDS for these mirror-image 
tables and use SQL for the unique tables (new or old).


        * Jerry C. Adams
*IBM System i5/iSeries Programmer/Analyst
B&W Wholesale Distributors, Inc.* *
voice
        615.995.7024
fax
        615.995.1201
email
        jerry@xxxxxxxxxxxxxxx <mailto:jerry@xxxxxxxxxxxxxxx>



Elvis Budimlic wrote:
> 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.
>
>