Re: SQL DDL Create Table Names

["rick baird" <rick.baird@xxxxxxxxx>]

here's one way.

build your source like this:

create table &library/&filename

compile your SQL DDL source into a query manager query (CRTQMQRY) and
pass the library and file names into the source using the substitution
parameters in the STRQMQRY command.

STRQMQRY QMQRY(querylib/qryname) SETVAR((LIBRARY 'MYLIB') (FILENAME 'MYFILE'))

On 5/31/07, Jerry Adams <jerry@xxxxxxxxxxxxxxx> wrote:
> 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.
>
> --
>        * 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>
>
>
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.