I spent a lot of time with this and finally traced the calls that
Powerhouse was making.  Turns out the b-trees work, but then powerhouse
checks the value of the key that is returned to what you entered, and
because the value you entered has the wild card in it, it doesn't match
what is returned from the database.

In typical Cognos fashion, they have no current plans to support b-tree's
(at least last time I talked to them).  If they would just take out the
darn error checking then it would work.  You will have to write a stub
routine to return the values to a temp file and feed them to the powerhouse
stuff.

shawn





Neil Harvey <[log in to unmask]> on 09/20/99 08:00:15 AM

Please respond to Neil Harvey <[log in to unmask]>

To:   [log in to unmask]
cc:    (bcc: Shawn Gordon/IS/FHM/FHS)

Subject:  B-TREES and PowerHouse




Greetings

Can anyone tell me if the B-TREE indices in Image are useable from
PowerHouse 8?
I may be missing something, but I'm not able to get them to work.

Here are the steps I took :-

DBUTIL
        addindex <database> for <dataset>

the dataset was a master, with an x(10) key, and the index was duly built.

        set <database> btreemode1=on

and DBUTIL faithfully reports that btreemode1 is on, and wildcard is @


Then Quiz

access <dataset>
choose <key> "030@"
rep all
go

and nothing is returned, although there are hundreds of entries that start
with 030 and run for 10 chars.

Also, it doesn't seem to work from Quick.

All help appreciated


Regards

Neil