Focal Point
[CLOSED] Redirection settings for DFIX

This topic can be found at:
http://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/4147077096

September 17, 2018, 01:44 AM
Martin vK
[CLOSED] Redirection settings for DFIX
We are migrating from 7.7 to 8.2.03M and one issue we now have is with PCHOLD DFIX output. We offer a flexible output to the customer where we can choose delimiter et cetera.

-SET &OUTPUT_NAME = 'martin.csv' ;

TABLE FILE HLDDUMP
PRINT *
ON TABLE PCHOLD AS &OUTPUT_NAME FORMAT DFIX &XCSV_HEADER DELIMITER &XCSV_DELIMITER &XCSV_ENCLOSURE
END
-RUN

Nevertheless in the browser the 'save report' is presented as 'martin.ftm' to the user, but .ftm is an unknown extension for the user.
I assume it has to do with Redirection Settings, but I checked carefully and it seems they are the same as in in our 7.7 environment.

I do see when I change Redirection settings for .ftm I might get WFServlet output name or generated filename, in stead of martin.ftm but I have not succeeded yet in changing extension to .csv

I just found out this is not a migration issue. In 7.7 it already worked the same, I just have never noted. So it is a general issue, how can I arrange for this DFIX PCHOLD I can apply a different extension?

thanks, Martin.

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


WebFocus 8206M, iWay DataMigrator, Windows, DB2 Windows V10.5, MS SQL Server, Azure SQL, Hyperstage, ReportCaster
September 17, 2018, 08:16 AM
BabakNYC
You might have to use FILEDEF to map the logical name to a physical name. https://webfocusinfocenter.inf...20.htm#dfiles1008866

However, according to doc, a DFIX file can have either an FTM (FOCUS Temp File) or DAT extension.


WebFOCUS 8206, Unix, Windows