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

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/.

View solution in original post

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

Announcements

Windchill RVS Users


Please take our

Windchill RV&S Authoring with Formula Editor Survey