Hi all,

I was doing partitioning in webfocus (version 7.1.4) using FOCUS database. Using these partitions in the report decreases the performance of the reports. For increasing the performance I tried converting FOCUS database to XFOCUS database, for this I Changed the SUFFIX = XFOCUS in Mas file and used SET XFOCUS = ON.

When I queried these partitions in XFOCUS-

-SET &PNAME1 = 'temp_part1';

-SET &PNAME2 = 'temp_part2';

-SET &PNAME3 = 'temp_part3';

-SET &PNAME4 = 'temp_part4';

USE

&P_PATH/&PNAME1.FOC AS TEMP1

&P_PATH/&PNAME2.FOC AS TEMP1

&P_PATH/&PNAME3.FOC AS TEMP1

&P_PATH/&PNAME4.FOC AS TEMP1

END

TABLE FILE TEMP1

PRINT

*

WHERE RECORDLIMIT EQ 1

END

-EXIT

I am getting following error: “Physical File @0000001 does not match FDT for the USE list. ”

Please tell me how can I convert a exixiting file in FOCUS to XFOCUS database.


Thanks
cdprasad
WF 7.1.4 WIN2K PROF

You must REBUILD the data structure with the REORG option. The FOCUS data structure has a 4k page and the XFOCUS a 16k page.

Also I have had probs with a mix of FOCUS and XFOCUS - all our stuff is XFOCUS now.