No Subject

[ANTHONY_JACKSON@xxxxxxxxxxxxxx]

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
+---