Re: DDL question

On 13-Jul-2017 10:12 -0600, Englander, Douglas 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,

Unsure how this is in any way related to RPG, but …

The following shows a DDL example of using NULLIF in the AS(select) to assign the selected columns as allowing NULL values; i.e. effect the same as the ALWNULL DDS feature for Physical File (PF):

create table xmp /* example mimics DDS disallow NULLs */
( c char not null default ' '
, d dec not null default 0 )
;
create table xmp_as as
( select
nullif(c, null) as c
, nullif(d, null) as d
from xmp
) with no data
;

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?

One SQL statement, the ALTER TABLE; alter every column to drop the NOT NULL attribute from each, for example, using the XMP table created above:

alter table xmp
alter column c drop not null
alter column d drop not null