Re: [EXTERNAL] Create view or index with a constraint

[Vernon Hamberg <vhamberg@xxxxxxxxxxxxxxx>]

This doesn't work if Tim really means a constraint - if he means 
selectivity through the index, then this is cool! But they aren't the 
same thing, conceptually.

Vern

On 10/12/2020 4:11 PM, Dexter Thompson wrote:
> CREATE INDEX indexxx
>   ON tablexxx
>   ( NewKey ASC )
>   WHERE Acct# > 5000000
>
>   ;
>
> On Mon, Oct 12, 2020 at 5:04 PM Tim Feldmeier <Tim.Feldmeier@xxxxxxxx>
> wrote:
>
> > Hello, I wanted to create an Index of a table with a different key as well
> > as have a constraint to account# > 500000 .
> > Does anyone have an example for this.
> >
> >
> >
> >
> > Thank You
> >
> > Tim Felmeier
> > Programmer Analyst For Coyote System
> > Roadrunner Transportation Systems
> > 1431 Opus Place, Suite 530
> > Downers Grove, IL 60515
> > Phone# (331)-2337921
> >
> >
> > The information transmitted is intended only for the person or entity to
> > which it is addressed and may contain proprietary, business-confidential
> > and/or privileged material. If you are not the intended recipient of this
> > message you are hereby notified that any use, review, retransmission,
> > dissemination, distribution, reproduction or any action taken in reliance
> > upon this message is prohibited. If you received this in error, please
> > contact the sender and delete the material from any computer.
> > --
> > This is the RPG programming on IBM i (RPG400-L) mailing list
> > To post a message email: RPG400-L@xxxxxxxxxxxxxxxxxx
> > To subscribe, unsubscribe, or change list options,
> > visit: https://lists.midrange.com/mailman/listinfo/rpg400-l
> > or email: RPG400-L-request@xxxxxxxxxxxxxxxxxx
> > Before posting, please take a moment to review the archives
> > at https://archive.midrange.com/rpg400-l.
> >
> > Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
> > questions.
> >
> > Help support midrange.com by shopping at amazon.com with our affiliate
> > link: https://amazon.midrange.com