Re: DDL question

[Charles Wilt <charles.wilt@xxxxxxxxx>]

Here's a way to do it on the fly...

create table newtable as
(select b.*
from sysibm.sysdummy1 A
     left outer join oldtable B
      on 1 = 0) with no data

all the columns of newtable will be allow null.

Charles


On Thu, Jul 13, 2017 at 10:12 AM, Englander, Douglas <
Douglas_Englander@xxxxxxxxxxxxx> wrote:

> I need to create a new table with the same fields as another table that
> was created using DDS. I am using DDL to create the new table. I have used
> both CREATE TABLE LIKE and CREATE TABLE AS(). Both methods create the new
> table with fields that do not allow NULL, which is the DDS default.
>
> Does anyone know how to create the new table with all of the fields being
> nullable, or is there a way to execute one command to change all of the
> columns to nullable, instead of executing an ALTER TABLE command for each
> column?
>
> Thank you,
>
> Doug
>
> --
> This is the RPG programming on the IBM i (AS/400 and iSeries) (RPG400-L)
> mailing list
> To post a message email: RPG400-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
> or email: RPG400-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/rpg400-l.
>
> Please contact support@xxxxxxxxxxxx for any subscription related
> questions.
>
> Help support midrange.com by shopping at amazon.com with our affiliate
> link: http://amzn.to/2dEadiD