Focal Point Banner


As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only.

Join the TIBCO Community
TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.

  • From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
  • Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
  • Request access to the private WebFOCUS User Group (login required) to network with fellow members.

Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community.


Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED]WHERE FIELDNAME IN FILE (text file)

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[SOLVED]WHERE FIELDNAME IN FILE (text file)
 Login/Join
 
Michele Brooks
Guru
posted
I am doing a Table File request in WF 761 that joins two Oracle views. I want to include only records that have bill ids that match the values of the bill ids that are in a text file. The text file has only 220 bills and the longest length of the bill ids is about 13 alphanumeric characters. The bill ids can vary in length. Pasted below is the syntax that I am using in my Table File Request, in addition to the filedef that I am using. Thanks.


 
FILEDEF IDFILE DISK /home/wfadmin/ibi/apps/dev_mnb_rpts/idfile.txt

WHERE ID_NUMBER IN FILE(idfile) 

I am getting the error message (FOC258) FIELDNAME OR COMPUTATIONAL ELEMENT NOT RECOGNIZED: idfile

This message has been edited. Last edited by: Michele Brooks,


WF 8205, Windows 10
Oracle DBMS
EXL07/PDF Output
 
Posts: 244 | Registered: August 27, 2012Report This Post
Ram Prasad E
Master
posted Hide Post
To my knowledge WF is case sensitive. idfile is different from IDFILE. Also the syntax for IN FILE. Try with below syntax.

WHERE PRODUCT_ID IN FILE EXPER

Thanks,
Ram


WebFOCUS 8.1.05
Windows
http://ibiwebfocus.wordpress.com
https://www.facebook.com/groups/ibi.webfocus/
 
Posts: 542 | Location: Dearborn, MI | Registered: June 03, 2009Report This Post
Waz
Expert
posted Hide Post
You may be thinking of IF in file syntax, that uses ().


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

 
Posts: 6347 | Location: 33°49'23.0"S, 151°11'41.0"E | Registered: October 31, 2006Report This Post
Michele Brooks
Guru
posted Hide Post
quote:
Originally posted by Ram Prasad E:
To my knowledge WF is case sensitive. idfile is different from IDFILE. Also the syntax for IN FILE. Try with below syntax.

WHERE PRODUCT_ID IN FILE EXPER

Thanks,
Ram


Worked like a charm. Thanks a million. I will close this case.


WF 8205, Windows 10
Oracle DBMS
EXL07/PDF Output
 
Posts: 244 | Registered: August 27, 2012Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED]WHERE FIELDNAME IN FILE (text file)

Copyright © 1996-2020 Information Builders