cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Community Tip - Need help navigating or using the PTC Community? Contact the community team. X

Adding columns to a table

sdamery
1-Newbie

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?

1 ACCEPTED SOLUTION

Accepted Solutions

This has been fixed in release 11.0 of Implementer. You can log on to the PTC website and request to download the upgrade or request a CD shipment at http://www.ptc.com/support/.

View solution in original post

2 REPLIES 2

This has been fixed in release 11.0 of Implementer. You can log on to the PTC website and request to download the upgrade or request a CD shipment at http://www.ptc.com/support/.

We are currently on 10.3 so I will have to update and test.

Top Tags