RE: DDL Record Select

I would just use

CREATE INDEX V40NISCOF/NSCHGRQFL1 ON V40NISCOF/NSCHGRQF
(NCSTAT, NCNPROD) WITH 1 DISTINCT VALUES;

And change any native I/O (assuming this is possible ?) to use 'D' as
the first key.



-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of
daparnin@xxxxxxxxxxxxxx
Sent: 12 March 2010 20:35
To: midrange-l@xxxxxxxxxxxx
Subject: DDL Record Select

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;



Dave Parnin