Re: SQL (not embedded)

I don't see anything wrong..

Note however that you don't need to do it in two steps...

alter table actpstlg00
alter column apgldate set not null
with default '0001-01-01'
alter column apgloccr set not null
with default '0001-01-01';



On Thu, May 28, 2015 at 6:37 PM, Englander, Douglas <
Douglas_Englander@xxxxxxxxxxxxx> wrote:

Here are the two ALTER TABLE lines. I know I can create the defaults with
the create table, but I am using another table to copy the definitions, and
you cannot (that I know of) change the default on specific columns of a
CREATE TABLE AS(select...)

alter table actpstlg00 alter column apgldate set not null
with default '0001-01-01';
alter table actpstlg00 alter column apgloccr set not null
with default '0001-01-01';
--
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.