Re: Rename column in SQL?

[Vernon Hamberg <vhamberg@xxxxxxxxxxxxxxx>]

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?