RE: Rename column in SQL?

I will try that, I got that syntax from the DB2 LUW manual. Wish those two DB2 teams would merge together and collaborate.

I made a long drawn out script to copy data to a different table, create new table, restore table permissions, restore constraints, insert new data by overriding identity column so I get a like for like insert (identity columns need to stay the same), drop backup table

-----Original Message-----
From: Vernon Hamberg [mailto:vhamberg@xxxxxxxxxxxxxxx]
Sent: Thursday, March 3, 2016 5:30 PM
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
Subject: Re: Rename column in SQL?

Matt = you must be using the wrong syntax for changing the system name - this statement makes no sense to me. Checking the manual I get the following.

Just use the ALTER COLUMN syntax that is already there -

ALTER TABLE APPLICATIONS ALTER COLUMN PASSWORDHISTORYENABLED FOR PASSHISTEN [put in data-type stuff here] ;

Simple!

HTH
Vern

On 3/3/2016 3:07 PM, Matt Olson wrote:

I'm trying to rename a column, simple task I know. But for some reason the following syntax is not working:

ALTER TABLE APPLICATIONS RENAME COLUMN PASSWORDHISTORYENABLED TO
PASSWORDHISTORYENABLED FOR PASSHISTEN;

I wish to rename the column (long name is PASSWORDHISTORYENABLED and is staying the same), just trying to fix the "System Name" which is unique to IBM I's flavor of DB2 and set it to PASSHISTEN (10 character limit).

Thoughts?

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at http://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxx for any subscription related questions.