Re: SQL (not embedded)

On 28-May-2015 17:37 -0500, Englander, Douglas 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';

From what is shown [apparently without the EXEC SQL execute for the dynamic SQL in RPG], the code seems possibly to fail to check the sqlstate and\or sqlcode after each statement. Perhaps the second invocation fails; the sqlcode should be negative and likely the joblog logs error(s).