INCLUDE-columns

Document ID : KB000013269
Last Modified Date : 14/02/2018
Show Technical Document Details
Introduction:

INCLUDE COLUMNS using Update

Question:

I want to add an include column to an existing index using RC/UPDATE. How do I do that? 

Environment:
z/os
Answer:

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