Quiz - record selection problem

[Shelley Snyder]

All,  
I am a new powerhouse user.  The following is the job log from a job I ran
this morning.  I do not see any error's and I do not have a clue why my
record selection only retrieves 22 records.  I have verified that subfile
QS424C0 does contain records for the customer id's keyed in job QZ424C1.  I
tested the job 2 weeks ago and had no problems. The customer id's
highlighted in blue are the records that were received.  Any suggestions
would be appreciated.  

Priority = DS; Inpri = 10; Time = UNLIMITED seconds.
Job number = #j224.
MON, OCT 29, 2001,  6:13 AM.
HP3000  Release: C.55.00   User Version: C.55.07
MPE/iX  HP31900 C.05.08  Copyright Hewlett-Packard 1987.
All rights reserved.
STREAMED BY MISPAWP,SHELLEY.MANMANJ (#S129) ON LDEV# 61
   STREAM DATE:   MON, OCT 29, 2001,  6:13 AM
Welcome!  You are now signed on.
COMMENT------------------------------------------------------
COMMENT
COMMENT  CREATED 09/26/01 - BY SHELLEY SNYDER
COMMENT  MONTHLY SALES REPORT - USED TO MEET CUSTOMER
COMMENT  REPORTING REQUIREMENTS
COMMENT  THIS JOB SHOULD BE RUN ON A MONTHLY BASIS
COMMENT
COMMENT------------------------------------------------------
FILE QZ424M;DEV=LP,9,1
QUIZ ,,50
Q U I Z   (PowerHouse  8.19.C4)
Copyright 1999 COGNOS INCORPORATED
20TH CENTURY PLASTIC

 USE QZ424C0.OMQZSRC.MANMANJ
 ACCESS BILMAS

 SET REPORT LIMIT 5000000

 DEF BILIDX CHAR*10 = BILNO IF NOT MATCHPATTERN(BILTLX,"O-*") ELSE &
     BILTLX[1:10]

 SET SUBFILE NAME QS424C0 INDEX BILIDX REPEATING &
      SEGMENT BILIDX

 :PURGE QS424C0
File "" not found.  No purge done. (CIWARN 383) (PARM=-7)
 REPORT SUMMARY BILIDX BILNO BILNAM BILTLX
 GO
Records selected:  3315    I have verified that file QS424C0 contains all of
the records I need
Records written:   3315

 USE QZ424C1.OMQZSRC.MANMANJ
 ACCESS *QS424C0

 CHOOSE BILIDX PARM PROMPT "ENTER BILL-TO CUST# OR 10 CHAR. BILTLX ('O-'): "
Choose viaindex BILIDX.

 SET REPORT LIMIT 5000000

 SORT ON BILIDX ON BILNO

 REPORT SUMMARY BILNO BILNAM BILTLX BILIDX

 SET SUBFILE NAME QS424C1
 :PURGE QS424C1
File "" not found.  No purge done. (CIWARN 383) (PARM=-7)
 GO

ENTER BILL-TO CUST# OR 10 CHAR. BILTLX ('O-'): O-ALBERTSN
ENTER BILL-TO CUST# OR 10 CHAR. BILTLX ('O-'): O-ALDI
ENTER BILL-TO CUST# OR 10 CHAR. BILTLX ('O-'): O-ALLIEDOS
NTER BILL-TO CUST# OR 10 CHAR. BILTLX ('O-'): O-AMW
ENTER BILL-TO CUST# OR 10 CHAR. BILTLX ('O-'): O-DSN
ENTER BILL-TO CUST# OR 10 CHAR. BILTLX ('O-'): O-AGA
ENTER BILL-TO CUST# OR 10 CHAR. BILTLX ('O-'): O-BAPARGH
ENTER BILL-TO CUST# OR 10 CHAR. BILTLX ('O-'): O-BCOP
ENTER BILL-TO CUST# OR 10 CHAR. BILTLX ('O-'): O-CSO
ENTER BILL-TO CUST# OR 10 CHAR. BILTLX ('O-'): O-CE-CN
ENTER BILL-TO CUST# OR 10 CHAR. BILTLX ('O-'): O-CE-US
ENTER BILL-TO CUST# OR 10 CHAR. BILTLX ('O-'): O-CE-USOP
ENTER BILL-TO CUST# OR 10 CHAR. BILTLX ('O-'): O-FLEMING
ENTER BILL-TO CUST# OR 10 CHAR. BILTLX ('O-'): O-HEB
ENTER BILL-TO CUST# OR 10 CHAR. BILTLX ('O-'): O-IS
ENTER BILL-TO CUST# OR 10 CHAR. BILTLX ('O-'): O-INTER CO
ENTER BILL-TO CUST# OR 10 CHAR. BILTLX ('O-'): O-MEIJER
ENTER BILL-TO CUST# OR 10 CHAR. BILTLX ('O-'): O-MIC
ENTER BILL-TO CUST# OR 10 CHAR. BILTLX ('O-'): O-NAMD
ENTER BILL-TO CUST# OR 10 CHAR. BILTLX ('O-'): O-NPA
ENTER BILL-TO CUST# OR 10 CHAR. BILTLX ('O-'): O-OD-BSD
ENTER BILL-TO CUST# OR 10 CHAR. BILTLX ('O-'): O-OD-R
ENTER BILL-TO CUST# OR 10 CHAR. BILTLX ('O-'): O-OFFMX
ENTER BILL-TO CUST# OR 10 CHAR. BILTLX ('O-'): O-OSCO
ENTER BILL-TO CUST# OR 10 CHAR. BILTLX ('O-'): O-PROMOUNL
ENTER BILL-TO CUST# OR 10 CHAR. BILTLX ('O-'): O-SAM'S
ENTER BILL-TO CUST# OR 10 CHAR. BILTLX ('O-'): O-SSR
ENTER BILL-TO CUST# OR 10 CHAR. BILTLX ('O-'): O-SHOPKO
ENTER BILL-TO CUST# OR 10 CHAR. BILTLX ('O-'): O-SPR
ENTER BILL-TO CUST# OR 10 CHAR. BILTLX ('O-'): O-SPR-ADV
ENTER BILL-TO CUST# OR 10 CHAR. BILTLX ('O-'): O-STAP
ENTER BILL-TO CUST# OR 10 CHAR. BILTLX ('O-'): O-SBA
ENTER BILL-TO CUST# OR 10 CHAR. BILTLX ('O-'): O-TRI-MEGA
ENTER BILL-TO CUST# OR 10 CHAR. BILTLX ('O-'): O-UNITED
ENTER BILL-TO CUST# OR 10 CHAR. BILTLX ('O-'): O-WAL-MART
ENTER BILL-TO CUST# OR 10 CHAR. BILTLX ('O-'): O-WMA
ENTER BILL-TO CUST# OR 10 CHAR. BILTLX ('O-'): O-XPEDX
ENTER BILL-TO CUST# OR 10 CHAR. BILTLX ('O-'): 91327
ENTER BILL-TO CUST# OR 10 CHAR. BILTLX ('O-'): 14679
ENTER BILL-TO CUST# OR 10 CHAR. BILTLX ('O-'): 91328
ENTER BILL-TO CUST# OR 10 CHAR. BILTLX ('O-'): 86631
ENTER BILL-TO CUST# OR 10 CHAR. BILTLX ('O-'): 31750
ENTER BILL-TO CUST# OR 10 CHAR. BILTLX ('O-'): 37510
ENTER BILL-TO CUST# OR 10 CHAR. BILTLX ('O-'): 91325
ENTER BILL-TO CUST# OR 10 CHAR. BILTLX ('O-'): 27859
ENTER BILL-TO CUST# OR 10 CHAR. BILTLX ('O-'): 86779
ENTER BILL-TO CUST# OR 10 CHAR. BILTLX ('O-'): 41878
ENTER BILL-TO CUST# OR 10 CHAR. BILTLX ('O-'): 46647
ENTER BILL-TO CUST# OR 10 CHAR. BILTLX ('O-'): 79352
ENTER BILL-TO CUST# OR 10 CHAR. BILTLX ('O-'): 91496
ENTER BILL-TO CUST# OR 10 CHAR. BILTLX ('O-'): 64022
ENTER BILL-TO CUST# OR 10 CHAR. BILTLX ('O-'): 64244
ENTER BILL-TO CUST# OR 10 CHAR. BILTLX ('O-'): 64388
ENTER BILL-TO CUST# OR 10 CHAR. BILTLX ('O-'): 66190 This was grouped with
O-SSR
ENTER BILL-TO CUST# OR 10 CHAR. BILTLX ('O-'): 67926
ENTER BILL-TO CUST# OR 10 CHAR. BILTLX ('O-'): 69715 This was grouped with
O-SSR
ENTER BILL-TO CUST# OR 10 CHAR. BILTLX ('O-'): 86694
ENTER BILL-TO CUST# OR 10 CHAR. BILTLX ('O-'): 77580
ENTER BILL-TO CUST# OR 10 CHAR. BILTLX ('O-'): 83416
ENTER BILL-TO CUST# OR 10 CHAR. BILTLX ('O-'):

Records selected:  22
Records sorted:    22
Records written:   22



Thank you, 

Shelley Snyder	
Business Analyst,
Centis CPD, Inc
828 Duo-Tang Rd	
Paw Paw, MI 49079
P:616-655-3293
E:ssnyder@Centiscpd.com