Is your lookup field (Z-ACCT-STATE) a Omnidex only field, or is it also an
Image item in the data set?
Mike Berkowitz
Guess? Inc.
-----Original Message-----
From: Chuck Ryan [mailto:[log in to unmask]]
Sent: Friday, June 22, 2001 9:54 AM
To: 'Michael Berkowitz'; [log in to unmask]
Subject: RE: [HP3000-L] Query and TPI
Sorry, that was real dumb... I recently answered that question for someone
on an older machine still using CM Query... and the fingers kicked in before
the brain.
I just tried it and have no problem when I specify the Omnidex key name in
the find:
: PUB > query
HP32216N.03.15 QUERY/NM FRI, JUN 22, 2001, 11:43 AM
COPYRIGHT HEWLETT-PACKARD CO. 1976
>base=dbsvm.prod
PASSWORD = >>
MODE = >>1
>s=account-master
>f z-acct-state="KY"
385 ENTRIES QUALIFIED
>
> -----Original Message-----
> From: Michael Berkowitz [mailto:[log in to unmask]]
> Sent: Friday, June 22, 2001 11:49 AM
> To: [log in to unmask]
> Subject: Re: [HP3000-L] Query and TPI
>
>
> Chuck Ryan writes:
>
>
> I believe teh easiest way to use Omnidex indexes with Query is to copy
> Query.pub.sys to Query.OQ.DISC and then issue the run command as:
>
> RUN QUERY.OQ.DISC;LIB=G
> ---------------------------------------------------------
> Not necessary if TPI is enabled. It's not that Query won't
> use TPI indexes,
> it's that it won't use them unless it is a unique name, not
> the name of a
> standard image item, in this case "INV-DATE". The
> "CUST/INV-DATE" key is a
> concatenated index and works fine.
>
> Mike Berkowitz
> Guess? Inc.
>
> > -----Original Message-----
> > From: Michael Berkowitz [mailto:[log in to unmask]]
> > Sent: Friday, June 22, 2001 11:24 AM
> > To: [log in to unmask]
> > Subject: [HP3000-L] Query and TPI
> >
> >
> > I'm trying to use Query to search for a value on an Omnidex
> > (IMSAM) chain.
> > Query, keeps trying to use a serial read and will not use the
> > TPI index. Is
> > there any way to force using the index, via a command, or a
> > structuring of
> > the find statement. See details below.
> >
> > Mike Berkowitz
> > Guess? Inc.
> >
> > :QUERY
> > HP32216D.03.20 QUERY/NM FRI, JUN 22, 2001, 9:18 AM
> > COPYRIGHT HEWLETT-PACKARD CO. 1976
> >
> > >B=AMSAUX
> > PASSWORD = >>
> > MODE = >>1
> > >S=INV-MAST
> > >FO INV-MAST
> >
> >
> > DATA BASE: AMSAUX FRI, JUN 22, 2001, 9:18 AM
> >
> >
> > DATA BASE LANGUAGE ATTRIBUTE: NATIVE-3000
> >
> >
> > SET NAME:
> > INV-MAST,DETAIL
> >
> > ITEMS:
> > INV-NO, X6 <<SEARCH ITEM>>
> > CUST/LOG, X12 <<SEARCH ITEM>>
> > CUST-NO, X6 <<SEARCH ITEM>>
> > INV-DATE, X6
> > AS-OF-DATE, X6
> > DUE-DATE, X6
> > SHIP-VIA, X12
> > INV-GROUP, X2
> > SEQ-NO, J1
> > WEIGHT, J2
> > BOXES, J1
> > MERCH-AMT, J2
> > DISC-AMT, J2
> > FREIGHT-AMT, J2
> > INS-AMT, J2
> > MISC-AMT, J2
> > TAX-AMT, J2
> > TOT-AMT, J2
> > INV-QTY, J2
> > REC-TYPE, X2
> > FILLER20, X20
> >
> > TPI INDEXES:
> > INV-DATE, G6
> > CUST/INV-DATE, G12
> > LOG-NO, G6
> >
> > CAPACITY: 242648 ENTRIES: 235259
> > MAXIMUM CAPACITY: 10006976 INITIAL CAP.: 202216
> > INCREMENT: 10108
> >
> >
> >
> > >F INV-DATE=911210
> > USING SERIAL READ
> >
> > < CONTROL Y >
> >
> > 0 ENTRIES HAVE QUALIFIED, DO YOU WANT TO CONTINUE SEARCHING?
> > >>NO
> > 0 ENTRIES QUALIFIED
> > >
> >
> > * To join/leave the list, search archives, change list settings, *
> > * etc., please visit http://raven.utc.edu/archives/hp3000-l.html *
> >
>
> * To join/leave the list, search archives, change list settings, *
> * etc., please visit http://raven.utc.edu/archives/hp3000-l.html *
>
* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *
|