Adding columns to a table
I have run into an issue, I want to add 3 new columns to my sql table and when I compile it in my local library the table and views all create correctly, however when I promote my table and views to QA I get an error from implementers ALTER table statement.
...
ADD COLUMN MY_FIRST_NEW_FIELD FOR COLUMN MFNFLD CHAR (1) CCSID 500 WITH DEFAULT 'N' NOT NULL BEFORE MSNFLD
ADD COLUMN MY_SECOND_NEW_FIELD FOR COLUMN MSNFLD CHAR (1) CCSID 500 WITH DEFAULT 'N' NOT NULL BEFORE MTNFLD
...
I am adding the columns to the middle of the create table script and it seems like the implementer ALTER TABLE is unable to handle 3 new fields in the middle of the table.
MSG ID SEV RECORD TEXT
SQL0205 30 1 Position 1 Column MSNFLD not in table MYTABLE in
IMB275S.
The error suggests that implementer is trying to add the first new field before the second new field...before the second new field is created.
HELP? Anyone run into this?