Was this helpful?
DIF
DIF is an acronym for Data Interchange Format. DIF is a somewhat universal format and is similar to a delimited ASCII file in that it contains fields and records of data that are separated by specific field and record separators. Many applications can read or write a DIF file. Therefore, it may be used as an intermediate format when transforming data to or from applications that may not be supported "directly." With the DIF connector, you can read and write DIF data files.
Connector-Specific Notes
No known limitations.
Connector Parts
Connector parts are the fields you configure to connect with a data source or target. The fields that are available depend on the connector you select.
For a list of all parts for source connectors, see Specifying Source Connector, Parts, and Properties.
For a list of all parts for target connectors, see Specifying Target Connector, Parts, and Properties.
Property Options
You can specify the following source (S) and target (T) properties:
Property
S/T
Description
Header
S
If the first data record in your source file contains column names, you can read this record and use the information as field names. The default is false. To change the setting to true, click the Value cell, highlight the default value, and type the required value.
Note:  If the Header property is set to true, the first row of data is used as field names. If the property is false and the source file contains header labels, these labels are used. If the property is false and there are no header labels, the column headings appear as Field1, Field2, and so on.
StyleSampleSize
S
This is the number of records to examine for automatic sizing. The default is 1000.
Reverse
T
By default, DIF vectors are written before the tuples, therefore the default is false. If you want to reverse the vectors and tuples, change this option to true.
TableTitle
T
The default text reads "created by third party conversion product." According to the DIF specifications, this property is not a table name; instead, it is a "title that describes the data." To change the default text, click the text box, and replace the original text with your own description.
Use Cr-LF
T
By default, this option is set to true and a carriage return-line feed is returned at the end of each line in your DIF file.
CodePage
S/T
This translation table determines which encoding to use for reading and writing data. The default is ANSI, the standard in the US.
Supported Data Types
Only two data types are available for DIF data files.
Text
Numeric
Last modified date: 10/22/2024