Re: Where is ALTER TABLE RENAME COLUMN on IBMi?

A work around is the "create or change" manage to rename if you only change
one column name at the time - if that is documented I don't know..

On Tue, Dec 18, 2018 at 12:07 AM Vernon Hamberg <vhamberg@xxxxxxxxxxxxxxx>
wrote:

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.

--
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: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: https://amazon.midrange.com