Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     WHERE IN FILE errors on spaces
Go
New
Search
Notify
Tools
Reply
  
WHERE IN FILE errors on spaces
 Login/Join
 
<Pooch>
posted
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
 
Reply With QuoteReport This Post
Expert
posted Hide Post
sure,you need to create your file with each element in quotes.
'Unknown'
'Customer Site'
 
Posts: 3811 | Location: Manhattan | Registered: October 28, 2003Reply With QuoteReport This Post
Platinum Member
posted Hide Post
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.
 
Posts: 226 | Registered: June 08, 2003Reply With QuoteReport This Post
<Pooch>
posted
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
 
Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     WHERE IN FILE errors on spaces

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.