I'm trying to use the values from a hold file to delimit a query using the 'where in file' clause.

It behaves as expected, but errors out when the value in the hold file has a space.

TABLE FILE WTF
ON TABLE HOLD AS LIM FORMAT ALPHA
PRINT RC1 AS VALID
BY HIGHEST 3 SRCNT NOPRINT
END

TABLE FILE SUMRY
SUM
LOB
RC1
SRCNT
BY
LOB NOPRINT
BY
RC1 NOPRINT
WHERE
RC1 IN FILE LIM

END


Works when RC1 = 'Unknown' but not when RC1='Customer Site' gives error:

0 ERROR AT OR NEAR LINE 223 IN PROCEDURE _ADHOCRQFOCEXEC *
(FOC272) FORMAT ERROR IN DECODE OR FILE ELEMENT: Site
(FOC009) INCOMPLETE REQUEST STATEMENT


Does anyone know a workaround?

Thanks in advance...
Jason

sure,you need to create your file with each element in quotes.
'Unknown'
'Customer Site'

Are you sure that the field RC1 has the same
format definition in the two data files?
Blanks don't make a difference, but the length
of the literal value may exceeed what you
described in the second file.

Thanks Susannah!!!

That worked perfectly (and I never would have thought of it)!!

Having seen a number of your posts and forum involvement you've definately earned your 'Platinum' status.

Jason