WebFOCUS Online Help > ReportCaster Development and Administration > ReportCaster Formats for Scheduled Output > DFIX

Format: DFIX (.ftm, .txt)

Description: Allows you to define any character to act as the delimiter (DELIMITER = your choice of character), include quotation marks around alpha fields (ENCLOSURE = “), and include column titles (HEADER = YES/NO).

The following is an example of a HOLD statement that specifies the pipe character (|) as the delimiter, adds quotation marks around alpha fields, and does not include column titles or headings.

ON TABLE HOLD AS OUT1 FORMAT DFIX DELIMITER | ENCLOSURE “ HEADER NO

Suggested Uses: Use in files that require custom (non-standard) delimiters.

Considerations:

• Missing data is indicated by showing no data. If you specified an enclosure, then missing alpha fields are indicated by ““. Missing numeric fields are indicated by two delimiters.
• Bursting is supported.