PCOMMA
The PCOMMA parameter controls the retrieval of comma-delimited files.
By default, when a Master File specifies SUFFIX=COM, incoming alphanumeric values are not enclosed in double quotation marks, and each record is terminated with a comma and dollar sign (,$) character combination. This format does not support retrieval of most comma-delimited files produced by a PC application.
The syntax is:
SET PCOMMA = option
where:
option
Can be one of the following:
- ON, which enables the retrieval of comma-delimited data sources created by a PC application, in which alphanumeric data is enclosed in double quotation marks and each record is completely contained on one line and is terminated with a carriage return and line feed. It can also retrieve comma-delimited data sources in which alphanumeric data is not enclosed in double quotation marks and each record is terminated with a comma and dollar sign.
- OFF, which does not enable the retrieval of comma-delimited data sources created by a PC application. It indicates that alphanumeric data is not enclosed in double quotation marks and each record is terminated with a comma and dollar sign. OFF is the default value.
- DFIX, which causes delimited files with SUFFIX=COM, COMT, TAB, and TABT to be processed through the Adapter for DFIX. This processing provides more complete and meaningful messages and some changes to the processing of missing values when two delimiters in a row are encountered. With DFIX processing, a missing value is assigned to the field.
In order to be eligible for DFIX processing, the delimited file must satisfy the following requirements.
- Each record must be completely contained on one line and terminated with the crlf (carriage return/linefeed) character combination.
- The ENCLOSURE can be only in the first position after the delimiter for COM (new) and COMT records. Otherwise, it will not be recognized.
- The number of fields on a line cannot exceed the number of fields defined in the Master File.