Here's what's happening: The file has 1,059,119 records, when run without exclusions my query returns 1,046,296 records. So somehow it's dropping 12,823 records. I don't believe it's the master file definition because the query is returning data and if the M.F.D was the problem it shouldn't work.

The code is a simple pull

-*******************************************************************************
-* TITLE : FOCEXEC (HSSPRO)
-* SYSTEM : HEALTH
-* AUTHOR : GLENDA STURM
-* DATE WRITTEN : 09/07/2006
-* DESCRIPTION : STANDARD LIFE CLAIMS DATA
-* INPUT FILES : /edadata/taxes/devl/srec2006
-* OUTPUT FILES : LOTUS FILE
-*******************************************************************************
-* --------- PURPOSE ---------
-*
-* This report contains the programmer's pull by provider tin#.
-* It will be joined to the output from the FOCUS report
-* gp5b02.focexec.data(box61099) to tie tin#'s to the ledger data.
-*
-*******************************************************************************
-* --------- CHANGE LOG ---------
-*******************************************************************************
-* G/H Q/L
-*******************************************************************************
-SET &NOW = &YYMD;
-SET &TODAY = CHGDAT('YYMD', 'MDYYX', &YYMD, '17');
-*******************************************************************************
-* 2(Detail) or 2(Summary)
-SET &OUTPUT='1';
-* A(ntex Med Sup) or S(LAICO)
-SET &SYSDET='S';
-SET &PRD = 'PROD'||&SYSDET;
-GOTO &PRD
-PRODA
FILEDEF ARCN1099 DISK /edadata/taxes/devl/arec2006
-GOTO BODY
-PRODS
FILEDEF ARCN1099 DISK /edadata/taxes/devl/srec2006
-GOTO BODY
-BODY


TABLE FILE ARCN1099
PRINT
RECTYP
PROVTP
TIN
TRANTP
PAYNAM
CHECKNO
CHKAMT
CHKDTE
ADDRESS1
ADDRESS2
CITY
STATE
ZIP
CLMNO
WHAMT
-*WHERE RECTYP EQ '&OUTPUT'
ON TABLE PCHOLD FORMAT LOTUS
END

try using Recordformat and recordlength in your FILEDEF

..... (REC F LRECL 233

Sub your values