One minor clarification regarding IMAGE/SQL and Third Party Indexes: Kumar wrote: ---------- >From: K N Kumar >To: HP3000-L >Subject: Re: Image/SQL >Date: Wednesday, October 16, 1996 3:39PM > >Jim Keohane wrote: [snip] >> 3. There is no SQL (imbedded or API) that handles the special Image >> datatypes (I3,J3,etc.). [snip] >When an Image DB is attached to a DBE, all TPIs are registered in the >system catalog of the DBE if the DB is enabled for TPI. So Allbase knows >about Image TPIs and will use them to optimize performance whenever >appropriate. *** Note: only some of the third party indexes are registered. There are 2 types: Sorted & Multiple and only the Sorted indexes are registered. And, of these, only the keys on actual fields are indexed; composite (or segmented) sorted keys are not. Rich Trapp [log in to unmask]