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.
April 26, 2019, 11:42 AM
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.
In FOCUS since 1985. Prod WF 8.0.08 (z90/Suse Linux) DB (Oracle 11g), Self Serv, Report Caster, WebServer Intel/Linux.
April 26, 2019, 11:47 AM
MartinY
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)