Thanks, I'll go vote for it. We are undergoing a database modernization effort and the lack of these commands that are available in the LUW version of DB2 is causing extra steps for us.
-----Original Message-----
From: Rob Berendt <rob@xxxxxxxxx>
Sent: Tuesday, December 18, 2018 6:20 AM
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
Subject: Re: Where is ALTER TABLE RENAME COLUMN on IBMi?
Does renaming columns really happen a lot? Like, "let's rename Employee_id to Associate_id as it's more politically correct. Well, sure you'll have to change like a bazillion lines of code..."
I can see it as a one time thing for people who want to differentiate between column name and the 10 character limitation of system column name.
BTW, the RFE has been out there since 2016
https://www.ibm.com/developerworks/rfe/execute?use_case=viewRfe&CR_ID=96458
Rob Berendt
--
IBM Certified System Administrator - IBM i 6.1 Group Dekko Dept 1600 Mail to: 2505 Dekko Drive
Garrett, IN 46738
Ship to: Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com
From: "Matt Olson" <Matt.Olson@xxxxxxxx>
To: "Midrange Systems Technical Discussion" <midrange-l@xxxxxxxxxxxx>
Date: 12/17/2018 04:47 PM
Subject: Where is ALTER TABLE RENAME COLUMN on IBMi?
Sent by: "MIDRANGE-L" <midrange-l-bounces@xxxxxxxxxxxx>
It seems DB2 for IBMi doesn't support the following syntax but other
flavors of DB2 do?!?
ALTER TABLE library.tablename RENAME COLUMN oldcolumn TO newcolumn;
Am I missing something?
Any chance of doing it through a CL command?
FYI: These are all DDL / SQL described tables.
As an Amazon Associate we earn from qualifying purchases.