Re: DDL question

Hi Doug,

you can create a table from a SELECT statement - that's not the problem:
CREATE TABLE ... AS (
SELECT ... AS ...,
... AS ...,
FROM ...
)
DEFINITION ONLY
INCLUDING COLUMN DEFAULTS
RCDFMT ...;
This creates the table with the column definitions from the SELECT.

Of course you can also use multiple "reference" tables, but using JOIN.

But it's a bit more complicated if you also need columns the you want to define yourself - you can try it with fixed values and CAST, but that doesn't work always perfect:
CREATE TABLE ... AS (
SELECT CAST('' AS CHAR(50)) AS ...,
... AS ...,
FROM ...
)
DEFINITION ONLY
INCLUDING COLUMN DEFAULTS
RCDFMT ...;
Or you create the table with SELECT first, and then add the additional columns with ALTER TABLE ADD COLUMN.

HTH and kind regards,
Daniel

Am 23.09.2025 um 17:17 schrieb DEnglander--- via MIDRANGE-L <midrange-l@xxxxxxxxxxxxxxxxxx>:

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.