Re: Change column name on DDL SQL table in iSeries Navigator

On 21 May 2013 07:07, Matt Olson wrote:

Anyone figure out how to rename a column in iSeries navigator on a
SQL DDL table?

Someone recently started an off-topic thread on the RPG400-l subject "change column name in sql?"; I gave some replies, one including some effective scripts [without the "CL:" designation for the non-SQL]:
http://archive.midrange.com/rpg400-l/201305/threads.html#00120

For the life of me I can't figure out why it doesn't allow column
renames.

Renaming a column is allowed and easily effected with the CREATE VIEW statement; optionally combined with RENAME TABLE or RENAME VIEW so as to have the VIEW object with the corrected names take place of the TABLE or VIEW which still has the undesirable names.

Hardly trivial, in general, to change the actual column name in a TABLE because of issues with dependencies. Yet for a trivial scenario where there are no dependencies and the record format could be updated and its new definition refreshed in the catalogs, it is similarly easy for the user to accomplish the same effect with DROP TABLE and CREATE TABLE [when no data or with data then including also a RENAME and INSERT INTO ... SELECT], or a couple or a few ALTER TABLE requests; as shown in my replies in the thread for the included link.