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,

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.

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, $

Martin, that syntax creates internal indexes not the MDI. The MDI would create a single index on COUNTRY, CAR, MODEL and BODYTYPE.