Allbase will indeed pick up the TPI indexes that you generate in Image.
however you have to remember certain things. Key-word indexes are not used.
I would normally recommend that you use generic access, sorted keys, when
you wish to use the indexes in Allbase.

Gerry Johnson


-----Original Message-----
From: HP-3000 Systems Discussion [mailto:[log in to unmask]]On
Behalf Of Rich Trapp
Sent: Wednesday, August 09, 2000 11:29 AM
To: [log in to unmask]
Subject: Re: [HP3000-L] SQL Access to a Master Dataset


Todd,
  If you've got Omnidex or Suprdex indexes already on the last name field,
just enable the database for third party indexing (TPI) and do an  "update
statistics for table <tablename>;" on the SQL side (so it knows about the
indexes) and you should be all set.

  If you create indexes on the TurboImage side, you can accomplish the same
thing without the third parties. You may have to do the update statistics
after that also.

RAT

_______________________________________________________________________
 Rich Trapp "RAT"
 Managed Business Solutions   [log in to unmask]   http://www.mbsnav.com
 Assigned to Design Automation Support at Agilent Technologies
 Telnet or 970-679-2221 [log in to unmask]  Loveland, CO USA

_______________________________________________________________________


-----Original Message-----
From: Matteson, Todd [mailto:[log in to unmask]]
Sent: Wednesday, August 09, 2000 9:25 AM
To: [log in to unmask]
Subject: SQL Access to a Master Dataset


Although this may seem obvious to some, I have yet to become a novice on
ODBC/ISQL/SQL and access to IMAGE DB's using SQL.  My question is this:  I
have a Manual Master dataset with DBE attached.  I wish to produce a query
for a subset of the manual master.  For this examples sake:

Employees is my Manual master.  SS# is the key.  The DB is enabled for
IMAGE/SQL and the query is working (although slowly).

In an effort to improve access speed online, I want to do an SQL through
ODBC that doesn't read all records in the IMAGE DB serially.  For example,
all last names starting with 'MA'.  In IMAGE, this would require a serial
read.

Having said that...On the HP3000 (all on the 3000) I could accomplish this
through a 3rd party indexing product such as Superdex or Omnidex and build
my key as I see fit.  My programming would take care of the rest of the
details.  I've done this before and response times are good.

With ODBC using an SQL statement, I am afraid that I might not be able to do
this in an efficient manner.  Testing this method seems to read all records
serially.  Do I need to read the Allbase/SQL(Create Index) manual or where
would I go to research how to get to my desired result.  If I were to create
an index using ISQL, is this index maintained in the DBE only?  Any broad
direction on where to look for research material would help.  Thanks in
advance.

Todd Matteson
Business Application Manager
Huffy Service First
8521 Gander Creek Drive
Miamisburg, OH 45342
E-Mail:[log in to unmask]
Phone:(937) 436-5141