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     [CLOSED] Using external files in where clause in report painter

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[CLOSED] Using external files in where clause in report painter
 Login/Join
 
Kitty Philips
Member
posted
I want to use an external text file - the entire file - in a where clause in Report Painter. I've tried several things but with no success. I did search the forums and found one that indicated I should use the Import Values option. However, that requires that I select each value. I want to use the entire list not just certain values.

I also tried creating an APP FI but have had no luck with that either.

Any ideas?

Thanks,
Kitty

This message has been edited. Last edited by: Kerry,


WebFOCUS 7.6.9
Windows
all output (Excel, HTML, PDF)
 
Posts: 3 | Registered: July 15, 2010Report This Post
Tom Flynn
Expert
posted Hide Post
Kitty,

Welcome!

My suggestion is to filedef the text file with attributes, and to place it on the Reporting Server:

APP FI TEXTFILE DISK c:\ibi\apps\temparea\textfile.txt (lrecl 80 recfm f

change the lrecl to the actual length of the file.

Then DECODE, example

hth

Tom


Tom Flynn
WebFOCUS 8.1.05 - PROD/QA
DB2 - AS400 - Mainframe
 
Posts: 1972 | Location: Centennial, CO | Registered: January 31, 2006Report This Post
Kitty Philips
Member
posted Hide Post
Tom,

Thanks.

While that would be nice, we are running this in a different environment. We actually have our clients running the application. We do not allow them to write to the reporting server so unless I can put a APP FILEDEF on my desktop or another server, this method won't work in our situation.

Any other ideas?

Kitty


WebFOCUS 7.6.9
Windows
all output (Excel, HTML, PDF)
 
Posts: 3 | Registered: July 15, 2010Report This Post
mrguru
Gold member
posted Hide Post
If you make the file accessible in your application then you can table off the results which would then make the file available to test against. Here is an example using the car file:

  
TABLE FILE CAR
PRINT CAR
IF COUNTRY EQ 'ENGLAND'
ON TABLE HOLD AS KITTY FORMAT ALPHA
END
-RUN

TABLE FILE CAR
PRINT CAR COUNTRY
IF CAR IS (KITTY)
END
-RUN


WF 8.2.01M
8.2.01M Reporting Server
Windows 2012 Srvr R2
PDF,Excel, HTML
Graphs - a lot of graphs
 
Posts: 60 | Location: Atlanta, GA | Registered: October 30, 2003Report This Post
Waz
Expert
posted Hide Post
FYI...

There are limitations on IF {field} EQ ({ddname}) and WHERE {field} IN FILE {ddname}.

What is the size of your file, in kb.

There are also limitations on the number of values that can be screened on against an RDBMS.

What is the data source ?


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
Dr. Nick
Gold member
posted Hide Post
Hi Kitty,
Another approach is to create a Master File that defines the Values File. Then, Join the Base File to the Values File. For example,
Join Field in Values to Field in Base as J1.

A second alternate approach is to define the Values File with a Master File, Table that file Holding as a Focus file and Index the Value field. Then Join the Focus Values file to the Base File. For example, Join Field in Base to Field in Values as J1. You will have to test for a non-blank Value in order to insure the test condition is true.
Hope this helps.
Nick


WebFOCUS 7.7.03 & 8.0.7
Windows
HTML, Excel, PDF, etc.
Also, using Maintain, etc.
 
Posts: 83 | Registered: February 26, 2009Report This Post
Kitty Philips
Member
posted Hide Post
quote:
Reply

Thanks for all the responses.

We have a unique situation. We are marketing the product to our clients and not allowing them to create master files.

As far as the size and source, the files can be small or large, depending on the client. These are lists of say order numbers that they want to use throughout their organization to run reports against. They are text files with a single column that are stored on their servers or desktops. They can change these at will. Some may contain 10K+ rows.

Thoughts?

Kitty


WebFOCUS 7.6.9
Windows
all output (Excel, HTML, PDF)
 
Posts: 3 | Registered: July 15, 2010Report This Post
Waz
Expert
posted Hide Post
The safest way to use these files, is to have them in a location accessible to the WF server. Then as Nick says, create a master so you can join or match to it.

Just be aware, that if these files are updated from time to time, then there is a possibility that an update may happen while processing, and this may cause problems.


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
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] Using external files in where clause in report painter

Copyright © 1996-2020 Information Builders