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     [CLOSED] How to avoid creating access file (.acx)
Go
New
Search
Notify
Tools
Reply
  
[CLOSED] How to avoid creating access file (.acx)
 Login/Join
 
Member
posted
Hi folks,

I have '|' delimited flat file that includes header row along with some special character in data.

When a master file is created, webfocus generates access file on the top of master file.

Wondering, if I could avoid additional (.acx)file and add all parameters within master file.

ACX File:

SEGNAME=TV_EMP_TEXT,
-* DELIMITER=|,
HEADER=YES,
CDN=COMMAS_DOT, $

And Master file:

FILENAME=TV_EMP_EXTRACT, SUFFIX=DFIX ,
CODEPAGE=65001,
SEGMENT=TV_EMP_EXTRACT, SEGTYPE=S0, $
FIELD=EXTRACT_DATE, ALIAS=EXTRACT_DATE, USAGE=A10, ACTUAL=A10,$
FIELD=EMPLOYEE, ALIAS=EMPLOYEE, USAGE=A8, ACTUAL=A8,$
FIELD=COMPANY_CODE, ALIAS=COMPANY_CODE, USAGE=A4, ACTUAL=A4,$
FIELD= DELIMITER, ALIAS='|', USAGE=A1, ACTUAL=A1,$

I was able to resolve Delimiter (added last row in master file) but not sure how to add Header = 'Yes' option in master file, any help would be much appreciated.

Thanks in advance!

Learner

This message has been edited. Last edited by: FP Mod Chuck,


WebFocus App Studio
Windows 10
 
Posts: 4 | Registered: August 30, 2013Reply With QuoteReport This Post
Virtuoso
posted Hide Post
A master file is to define how the data is organized where the acx file is to define how/where to access the data.
And AFAIK, HEADER=YES is telling FOCUS how to access the data by skipping the first row since it's not a data row.

If FOCUS create .acx and .mas it's for a good reason, you should not attempt to bypass that


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: 2282 | Location: Montreal Area, Qc, CA | Registered: September 25, 2013Reply With QuoteReport This Post
Expert
posted Hide Post
Yes:
quote:
it's for a good reason.




   In FOCUS Since 1983 ~ from FOCUS to WebFOCUS.
   Currently with Fidelity Investments
 
Posts: 3052 | Location: Middle Tennessee [8204M Gen48 in Test&Prod] | Registered: February 23, 2005Reply With QuoteReport This Post
Member
posted Hide Post
Thanks Martin and Doug for quick feedback!

That's helpful!


WebFocus App Studio
Windows 10
 
Posts: 4 | Registered: August 30, 2013Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] How to avoid creating access file (.acx)

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