IBM Support

CREATE INDEX - optional alias and rename controls for field names

News


Abstract

The CREATE INDEX statement has been enhanced to allow more control over the index column names.

Content

You are in: IBM i Technology Updates > Db2 for i - Technology Updates > Db2 for i Functional Enhancements > CREATE INDEX - optional alias and rename controls for field names

image-20200115132008-1

image-20200115132017-2

CREATE INDEX

{ "data": [ { "Article Type":"News (DB600)", "Category":"IBM i Db2 / Index / Access Path / Logical file", "ARM Category":"IBM i Db2 > Index / Access Path / Logical file", "Keywords":"CREATE INDEX; index column names; column alias; RENAME; Db2 for i; SQL; index; IBM i 7.4; Db2 for i Functional Enhancements; IBM i", "Predicate":"PROACTIVE", "Classifier":"DEVELOP" } ] }

[{"Type":"MASTER","Line of Business":{"code":"LOB68","label":"Power HW"},"Business Unit":{"code":"BU070","label":"IBM Infrastructure"},"Product":{"code":"SWG60","label":"IBM i"},"ARM Category":[{"code":"a8m0z0000001i6QAAQ","label":"IBM i Db2-\u003EIndex \/ Access Path \/ Logical file"}],"ARM Case Number":"","Platform":[{"code":"PF012","label":"IBM i"}],"Version":"7.6.0;7.5.0;7.4.0","Edition":""}]

Document Information

Modified date:
20 November 2026

UID

ibm11116501