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     [SOLVED] READFILE not working in 8203?
Go
New
Search
Notify
Tools
Reply
  
[SOLVED] READFILE not working in 8203?
 Login/Join
 
Platinum Member
posted
I have a fex I wrote in AppStudio using -READFILE to pull in fields from a master file, but since we upgraded to 8.2.03 (from 8105M), it doesn't work. I get prompted for the variables. The master file is a synonym to a single row MS-SQL table.



-READFILE MAINT_REPORTING_DATES
-RUN
-SET &ME_DATE = EDIT(&CURR_REPORTING_MTH_END, '99/99/9999');


Am I missing something?

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


WebFOCUS 8.2.03 (production), 8.2.06 (testing)
AppStudio, InfoAssist
Windows, All Outputs
 
Posts: 180 | Location: Indiana | Registered: December 05, 2017Reply With QuoteReport This Post
Expert
posted Hide Post
I guessing that "MAINT_REPORTING_DATES" is the name of your HOLD file, right? If so, add the following immediately after your HOLD... End...
  -RUN
?FF MAINT_REPORTING_DATES
to verify that "CURR_REPORTING_MTH_END' is the name of the field.
 
Posts: 3124 | Location: Tennessee, Nashville area | Registered: February 23, 2005Reply With QuoteReport This Post
Virtuoso
posted Hide Post
Try this

-DEFAULTH &CURR_REPORTING_MTH_END = ''
TABLE FILE abc
BY CURR_REPORTING_MTH_END
WHERE .....
ON TABLE HOLD AS MAINT_REPORTING_DATES
END
-RUN
-READFILE MAINT_REPORTING_DATES
-RUN
-SET &ME_DATE = EDIT(&CURR_REPORTING_MTH_END, '99/99/9999');


WF versions : Prod 8.2.04M gen 33, Dev 8.2.04M gen 33, OS : Windows, DB : MSSQL, Outputs : HTML, Excel, PDF
In Focus since 2007
 
Posts: 2388 | Location: Montreal Area, Qc, CA | Registered: September 25, 2013Reply With QuoteReport This Post
Expert
posted Hide Post
quote:
-DEFAULTH &CURR_REPORTING_MTH_END = ''
That's important. It'll be prompted for if it's not included.
 
Posts: 3124 | Location: Tennessee, Nashville area | Registered: February 23, 2005Reply With QuoteReport This Post
Platinum Member
posted Hide Post
quote:
-DEFAULTH &CURR_REPORTING_MTH_END = ''

Ah! the DEFAULTH line was key.
THANKS!!!


WebFOCUS 8.2.03 (production), 8.2.06 (testing)
AppStudio, InfoAssist
Windows, All Outputs
 
Posts: 180 | Location: Indiana | Registered: December 05, 2017Reply With QuoteReport This Post
Virtuoso
posted Hide Post
From a similar post, I have picked up the habit of definging those -DEFAULT's right after the -READFILE statement:
TABLE FILE abc
BY CURR_REPORTING_MTH_END
WHERE .....
ON TABLE HOLD AS MAINT_REPORTING_DATES
END
-RUN
-READFILE MAINT_REPORTING_DATES
-DEFAULTH &CURR_REPORTING_MTH_END = '';
-SET &CURR_REPORTING_MTH_END = TRUNCATE(&CURR_REPORTING_MTH_END);
-SET &ME_DATE = EDIT(&CURR_REPORTING_MTH_END, '99/99/9999');


That has the benefit that WebFOCUS does not warn you that you are overwriting a variable's value.

I also got into the habit of TRUNCATE()-ing values from -READFILE. Or LTRIM() in the case of numeric values. The extra spaces can cause surprises Wink

Also, a couple of implicit nits I picked: You don't need -RUN after Dialog Manager statements (-READFILE) and -DEFAULT(H) is supposed to end with a semi-colon these days, I've been told.


WebFOCUS 8.1.03, Windows 7-64/2008-64, IBM DB2/400, Oracle 11g & RDB, MS SQL-Server 2005, SAP, PostgreSQL 11, Output: HTML, PDF, Excel 2010
: Member of User Group Benelux :
 
Posts: 1665 | Location: Enschede, Netherlands | Registered: August 12, 2010Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] READFILE not working in 8203?

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