INCLUDE COLUMNS using Update
I want to add an include column to an existing index using RC/UPDATE. How do I do that?
On alter index screen update ORDER for newly included column as INCL.
CMD SEQ# PS KEY-COLUMN-NAME ORDER COLTYPE SRCTYPE SIZE N
___ 1 COL2 ASC INTEGER 4 N
___ 2 COL1______________ INCL CHAR______________ 10 Y
Was this information helpful?