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] Questions about HOLD FORMAT XFOCUS
Go
New
Search
Notify
Tools
Reply
  
[CLOSED] Questions about HOLD FORMAT XFOCUS
 Login/Join
 
Master
posted
I'm guessing there is not a way to build the MDI for an XFOCUS hold file, for example,
TABLE FILE CAR
  SUM MAX.LENGTH
      MAX.WIDTH
   BY COUNTRY
   BY CAR
   BY MODEL
   BY BODYTYPE
   ON TABLE HOLD AS XCAR FORMAT XFOCUS INDEX COUNTRY+CAR+MODEL+BODYTYPE
END


Does this exist or would this be a NFR request. Any interest besides me? Wouldn't it be nice if this syntax would create the MDI?

I know I can use -WRITE to build the MDI, then use REBUILD to build the index, but this would be a lot simpler.

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


In FOCUS since 1985. Prod WF 8.0.08 (z90/Suse Linux) DB (Oracle 11g), Self Serv, Report Caster, WebServer Intel/Linux.
 
Posts: 919 | Location: Oklahoma City | Registered: October 27, 2006Reply With QuoteReport This Post
Master
posted Hide Post
I see a some views but no replies. I've submitted a NFR just in case IBI would like to do this but not holding my breath.


In FOCUS since 1985. Prod WF 8.0.08 (z90/Suse Linux) DB (Oracle 11g), Self Serv, Report Caster, WebServer Intel/Linux.
 
Posts: 919 | Location: Oklahoma City | Registered: October 27, 2006Reply With QuoteReport This Post
Virtuoso
posted Hide Post
You should use the following
TABLE FILE CAR
  SUM MAX.LENGTH
      MAX.WIDTH
   BY COUNTRY
   BY CAR
   BY MODEL
   BY BODYTYPE
   ON TABLE HOLD AS XCAR FORMAT XFOCUS INDEX COUNTRY CAR MODEL BODYTYPE
END

That will result in the below. Notice the FIELDTYPE=I which mean that these fields are indexed fields. So, WF does not need a MDI (acx)
FILENAME=XCAR    , SUFFIX=XFOC    , $
  SEGMENT=SEG01, SEGTYPE=S4, $
    FIELDNAME=COUNTRY, ALIAS=E01, USAGE=A10, FIELDTYPE=I, $
    FIELDNAME=CAR, ALIAS=E02, USAGE=A16, FIELDTYPE=I, $
    FIELDNAME=MODEL, ALIAS=E03, USAGE=A24, FIELDTYPE=I, $
    FIELDNAME=BODYTYPE, ALIAS=E04, USAGE=A12, FIELDTYPE=I, $
    FIELDNAME=LENGTH, ALIAS=E05, USAGE=D5, $
    FIELDNAME=WIDTH, ALIAS=E06, USAGE=D5, $

The following
TABLE FILE CAR
  SUM MAX.LENGTH
      MAX.WIDTH
   BY COUNTRY
   BY CAR
   BY MODEL
   BY BODYTYPE
   ON TABLE HOLD AS XCAR FORMAT XFOCUS
END

Result in the below.
FILENAME=XCAR    , SUFFIX=XFOC    , $
  SEGMENT=SEG01, SEGTYPE=S4, $
    FIELDNAME=COUNTRY, ALIAS=E01, USAGE=A10, $
    FIELDNAME=CAR, ALIAS=E02, USAGE=A16, $
    FIELDNAME=MODEL, ALIAS=E03, USAGE=A24, $
    FIELDNAME=BODYTYPE, ALIAS=E04, USAGE=A12, $
    FIELDNAME=LENGTH, ALIAS=E05, USAGE=D5, $
    FIELDNAME=WIDTH, ALIAS=E06, USAGE=D5, $


WF versions : Prod 8.2.0.1M gen 240, Dev 8.2.04 gen 48, OS : Windows, DB : MSSQL, Outputs : HTML, Excel, PDF
In Focus since 2007
 
Posts: 2168 | Location: Montreal Area, Qc, CA | Registered: September 25, 2013Reply With QuoteReport This Post
Master
posted Hide Post
Martin, that syntax creates internal indexes not the MDI. The MDI would create a single index on COUNTRY, CAR, MODEL and BODYTYPE.


In FOCUS since 1985. Prod WF 8.0.08 (z90/Suse Linux) DB (Oracle 11g), Self Serv, Report Caster, WebServer Intel/Linux.
 
Posts: 919 | Location: Oklahoma City | Registered: October 27, 2006Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] Questions about HOLD FORMAT XFOCUS

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