Re: DDL Record Select

[Alan Campin <alan0307d@xxxxxxxxx>]

The ability to create a drived index(Having it include only selected
fields)  was only added in V6R1.

On Fri, Mar 12, 2010 at 2:38 PM, <Michael_Schutte@xxxxxxxxxxxx> wrote:

> Shouldn't he be creating a view instead?
>
> Dave,
>
> You cannot tell an index to select certain records.  You will need to
> create a view selecting where NCSTAT = 'D' and you may want to create an
> index over NCSTAT.    Then you can use that view in sql statement as if it
> was a file.
>
>
> --
>
> Michael Schutte
> Admin Professional
>
>
>
> Bob Evans Holiday Farmhouse Feast, Serves 6-8 l $74.99
> A complete homestyle meal TO GO, ready to heat at home, serve & enjoy!
> Perfect for Thanksgiving, Christmas or holiday entertaining.
> For more information, visit www.FarmhouseFeast.com
>
>
>
> midrange-l-bounces@xxxxxxxxxxxx wrote on 03/12/2010 04:07:12 PM:
>
> > 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
> > --
> > Nishikawa Standard Company
> > Topeka, IN  46571
> > daparnin@xxxxxxxxxxxxxx
> > --
> > This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
> > list
> > To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> > To subscribe, unsubscribe, or change list options,
> > visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> > or email: MIDRANGE-L-request@xxxxxxxxxxxx
> > Before posting, please take a moment to review the archives
> > at http://archive.midrange.com/midrange-l.
> >
> > --
> > This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
> list
> > To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> > To subscribe, unsubscribe, or change list options,
> > visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> > or email: MIDRANGE-L-request@xxxxxxxxxxxx
> > Before posting, please take a moment to review the archives
> > at http://archive.midrange.com/midrange-l.
>
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.