Re: DDL Record Select

[CRPence <CRPbottle@xxxxxxxxx>]

daparnin@xxxxxxxxxxxxxx wrote:
> I've got a file and index defined in DDL that I would like to
> only select records with a certain status. In DDS I would do
> something like:
>
> A          S NCSTAT                    CMP(EQ 'D')
>
>
> How would I do this in DDL?  My index is:
>
> CREATE INDEX V40NISCOF/NSCHGRQFL1
>           ON V40NISCOF/NSCHGRQF (NCNPROD)
> WITH 1 DISTINCT VALUES;

  Since DB2 for IBM i 6.1:

<code>
   CREATE INDEX V40NISCOF/NSCHGRQFL1
             ON V40NISCOF/NSCHGRQF (NCNPROD)
   WHERE NCSTAT='D'
   /* omit irrelevant clause: WITH 1 DISTINCT VALUES */
   ;
</code>

Regards, Chuck