Re: SQL (not embedded)

[Charles Wilt <charles.wilt@xxxxxxxxx>]

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.