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] Default Segment Names in Automatically Generated Master Files
Go
New
Search
Notify
Tools
Reply
  
[SOLVED] Default Segment Names in Automatically Generated Master Files
 Login/Join
 
Member
posted
I have a number of Focus files in my APP folder that I am trying to join together in a single master file. Each file is generated nightly by ReportCaster running a fex with APP HOLD in it. The master file for each looks something like this:
FILENAME=DEPARTMENT_EXTRACT, SUFFIX=FOC     , $
  SEGMENT=SEG01, SEGTYPE=S1, $
    FIELDNAME=DEPARTMENT, ALIAS=E01, USAGE=A50, FIELDTYPE=I,
      MISSING=ON,
      TITLE='DEPARTMENT', $
    FIELDNAME=DEPARTMENT_DESC, ALIAS=E02, USAGE=A2000,
      MISSING=ON,
      TITLE='DEPARTMENT_DESC', $ 


For every single file, the segment is named "SEG01." Is there a way to specify what I want the segment name to be rather than letting WebFOCUS automagically supply a default name?

Here's the code that generates the master file described above:
TABLE FILE VALIDATION
SUM VALUE_DESC AS DEPARTMENT_DESC
BY VALUE AS DEPARTMENT
WHERE TABLE_NAME EQ 'STVDEPT'
ON TABLE HOLD AS DEPARTMENT_EXTRACT FORMAT FOCUS INDEX VALUE
END
-RUN
  


Any suggestions for changing it so that my master file contains SEGMENT=DEPT, rather than SEGMENT=SEG01?

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


WebFOCUS 8201
Excel, PDF, HTML
 
Posts: 5 | Location: Charlotte, NC | Registered: February 02, 2018Reply With QuoteReport This Post
Member
posted Hide Post
Hi Steven,

I believe that yes we are able to change.

In Master File Just update it to SEGMENT=DEPT and if you have folder structure in Master file then you have to UPDATE it as well to BELONGS_TO_SEGMENT=DEPT otherwise you can skip this.
In Access file you have to update it to SEGNAME=DEPT.

Update SEGMENT=DEPT in .mas(Master file)
Update SEGNAME=DEPT in .acx(Access file).


WebFOCUS 7x and 8x
Windows, All Outputs
 
Posts: 8 | Location: Bangalore | Registered: June 12, 2012Reply With QuoteReport This Post
Gold member
posted Hide Post
Hi,
Try the following code:
having "ON TABLE SET EXTRACT ON" will add segment names to your master file.

APP HOLD [YOUR FOLDER NAME]
TABLE FILE CAR
PRINT
CAR 
MODEL
SALES
BY COUNTRY
ON TABLE SET EXTRACT ON
ON TABLE HOLD AS CHECK_SEG FORMAT FOCUS
END 


WF 8.2.04
Windows/Unix
All Formats
In Focus since 2006
 
Posts: 74 | Location: UK | Registered: September 17, 2018Reply With QuoteReport This Post
Member
posted Hide Post
Thanks, Addy.
SET EXTRACT ON worked.


WebFOCUS 8201
Excel, PDF, HTML
 
Posts: 5 | Location: Charlotte, NC | Registered: February 02, 2018Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] Default Segment Names in Automatically Generated Master Files

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