Force an index retrieval

[Paul Howard]

Hi Listers,
One of my customers is using PH 733d3 on hpux accessing a sybase database.

Here is a sample of the code

> procedure FIND
> ;-----------------
> begin
>   for missing CUSTOMERS
>     begin
>       get CUSTOMERS &
>           viaindex idx02 &
>       using &
>           T_DEBTORS_MONTH, &
>           T_SURNAME
>     end
> end 

He finds that this does a sequential table scan instead of using an indexed
read.  In ISQL you can force it to use an index with special syntax.  Does
anyone know how to do this from within PowerHouse?

Regards
Paul Howard
= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu
Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
This list is closed, thus to post to the list, you must be a subscriber.