Re: Where is ALTER TABLE RENAME COLUMN on IBMi?

[Vernon Hamberg <vhamberg@xxxxxxxxxxxxxxx>]

Hi Matt

Seems there might already be an RFE for this - you could check that out.

Now there might be a kind of "interesting" workaround - I've not tried 
it - but using the ALTER TABLE with the syntax for changing the SQL name 
for the shorter system name.

Cheers
Vern

On 12/17/2018 3:46 PM, Matt Olson wrote:
> 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.