Re:

["Andrew Gaskin" <gemstone.solutions@xxxxxxxxxxxxxx>]

I'd guess an index with RCUST, RCURR, RCOMP would be most useful as they are
most selective.

Have you tried STRDBMON to see if an index is advised?


----- Original Message -----
From: <ANTHONY_JACKSON@dcsgroup.co.uk>
To: <BPCS-L@midrange.com>
Sent: Tuesday, February 15, 2000 10:59 AM


>
> Hi folks.....anybody out there...ever compiled a logical on rar..which
will be
> used by
> (see sqlinf below)...I have tried numerous qddssrc/LF specs/...and none
got
> picked up by
> ACR500D2....bpcs ver=6.1 full client...on AS400...its the last piece of
the
> performance
> improvements we have made on 'cash/memo posting'
>      File  . . . . . :   ACR500D2                         Page/Line   2/42
>
>  Control . . . . .   W6                               Columns     6 - 83
>  Find  . . . . . .
>
....1....+....2....+....3....+....4....+....5....+....6....+....7....+....8.
..
>  A1
>   A1
>  A1
>  DECLARE C1 CURSOR FOR SELECT * FROM RAR WHERE RCOMP = : CRCMPY AND RCURR
= :
>
>  RCURR AND RCCUS = : CRCUST AND ARPTYP <> : W8PTP1 AND ARPTYP <> : W8PTP2
AND (
>  RPTYP BETWEEN : W8FRTP AND : W8TOTP ) AND SUBSTR ( RRID , 1 , 1 ) IN
 'R' ,
>  T' ) AND ARWSID IN ( : W8WSID , : ZZSWS ) AND RSEQ = 0 AND RREM <> 0
ORDER BY
>  DDTE , RCUST , ARODPX , RINVC FOR FETCH ONLY
>  4021  Access plan last saved on 18/05/99 at 08:15:58.
>  4020  Estimated query run time is 12 seconds.
>  4017  Host variables implemented as reusable ODP.
>  4006  All access paths considered for file 1.
>  4009  Access path created for file 1.
>  S1 V4R3M0 980729     Print SQL information          Program
*LIBL/ACR500D2
>
****************************************************************************
****
>
> BPCS Support
> DCS Industry Solutions
> Caledonia House                         office    0113 2043300
> Lawnswood Business Park                 fax       0113 2043333
> Redvers Close
> leeds LS16 6QY
> The information contained in this electronic mail message is confidential.
It is
> intended  solely for the use of the individual or entity to whom it is
addressed
> and  others  authorised  to receive it. If the reader of this message is
not the
> intended recipient, you are hereby notified that any use, copying,
dissemination
> or disclosure of this information is strictly prohibited.
>
>
>
>
>
> +---
> | This is the BPCS Users Mailing List!
> | To submit a new message, send your mail to BPCS-L@midrange.com.
> | To subscribe to this list send email to BPCS-L-SUB@midrange.com.
> | To unsubscribe from this list send email to BPCS-L-UNSUB@midrange.com.
> | Questions should be directed to the list owner: dasmussen@aol.com
> +---
>

+---
| This is the BPCS Users Mailing List!
| To submit a new message, send your mail to BPCS-L@midrange.com.
| To subscribe to this list send email to BPCS-L-SUB@midrange.com.
| To unsubscribe from this list send email to BPCS-L-UNSUB@midrange.com.
| Questions should be directed to the list owner: dasmussen@aol.com
+---