HP3000-L Archives

June 2001, Week 4

HP3000-L@RAVEN.UTC.EDU
Options: Use Monospaced Font
Show Text Part by Default
Show All Mail Headers

Message: [<< First] [< Prev] [Next >] [Last >>]
Topic: [<< First] [< Prev] [Next >] [Last >>]
Author: [<< First] [< Prev] [Next >] [Last >>]

Print Reply
Subject:
Re: Query and TPI
From:
Michael Berkowitz <[log in to unmask]>
Reply To:
Michael Berkowitz <[log in to unmask]>
Date:
Fri, 22 Jun 2001 09:48:59 -0700
Content-Type:
text/plain
Parts/Attachments:
text/plain (105 lines) 
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 *

ATOM RSS1 RSS2