INCLUDE-columns

Products

• RC/Update for DB2 for z/OS

Issue/Introduction

INCLUDE COLUMNS using Update

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

Environment

z/os

Resolution

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