Re: DDL question

[Rob Berendt <robertowenberendt@xxxxxxxxx>]

This works
create table rob.m0923 as (
select rco.cmpny, rco.cmpnam,
       rcm.ccust, rcm.cnme
from erplxf.rco, erplxf.rcm)
definition only
including column defaults
;

I'm not a big fan of renaming each column in the new table to have a
character or 3 indicating the table of origin.  It just obfuscates
SYSCOLUMNS.  Besides, for decades now we've been able to qualify tables on
selects (as shown above) and in native RLA in RPG.

On Tue, Sep 23, 2025 at 11:17 AM DEnglander--- via MIDRANGE-L <
midrange-l@xxxxxxxxxxxxxxxxxx> wrote:

> I can create a table using column definitions from another table (create
> tablenew as(select fromcolumn as newcolumn) ).
>
> Does anyone know if it is possible to add columns to a table using column
> definitions from another table?
>
> I am looking to add about 5 columns to an existing table using column
> definitions from a field reference file. Is that possible?
>
> Thank you,
>
> Doug
>
>
>
> "CONFIDENTIALITY NOTICE:  This e-mail transmission (and/or the attachments
> accompanying it) contain confidential information belonging to the sender.
> The information is intended only for the use of the intended recipient.  If
> you are not the intended recipient, you are hereby notified that any
> disclosure, copying, distribution or the taking of any action in reliance
> on the contents of the information is strictly prohibited.  Any
> unauthorized interception of this transmission is illegal under the law.
> If you have received this transmission in error, please promptly notify the
> sender by reply e-mail, and then destroy all copies of the transmission."
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: https://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at https://archive.midrange.com/midrange-l.
>
> Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
> questions.