Re: Rename column in SQL?

Never go to the LUW manual to get the syntax for IBM i - SERIOUSLY - do NOT do that! There IS a reference guide for IBM i - use it!

There will never be a "merging" of those teams in the way you want. And there should not be. The IBM i database team is not going to go into the "feature-chasing" game. And there are sufficient differences in the underlying systems that one could not make a single code-base, seems to me.

There is a ton of compatibility among the versions of DB2 - you did not mention the version that runs on Z - another entirely different set of hardware and all.

I was there at IBM in 2001 when the new query engine was worked on - there was a blending, if you want to call it that - the IBM i team went to the Z team and got some code for statistics that was adapted to IBM i - it's not that the divisions are unaware of each other.

Regards
Vern

On 3/3/2016 5:35 PM, Matt Olson wrote:

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.