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
TABLE FILE SUMRY
RC1 IN FILE LIM
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...
sure,you need to create your file with each element in quotes.
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.
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.
|Powered by Social Strata|