File Attributes

The following fields are available to define the location, name, and contents of the exported data file:

Fields	Description
Export Type	Method of exporting data from the table. The available options are dependent on the Destination connection that can be specified via the Properties page.
Destination Connection	Destination to the file system to which data will be exported. The destination connection can be specified on the Properties screen.

Fields	Description
Export File Path	The full path (absolute path) of the folder/directory where the File is to be created on the Windows or UNIX/Linux system.
Export File Name	Name of the Export File to which the data will be exported. The variable $SEQUENCE$ can be used to provide a unique sequence number for the export file. Also, the data/file components YYYY, MM, HH, MI, SS can be used when enclosed with the $ character. For example, an export file name might be budget_$YYYYMMDD$.txt which would result in a file name like budget_20150520.txt.
Export Routine	Database-specific routine to use to export the data.
Export File Delimiter	Character that separates the fields within each record of the Export File for Delimited formats. The delimiter identifies the end of which field. Common field delimiters are tab, comma, colon, semi-colon, pipe. To enter a special character enter the uppercase string CHAR with the ASCII value in brackets (e.g. CHAR(9) ). This is only available if the Export Format is Delimited Text.
Optionally Enclosed by	Character that brackets text fields within each record of the Export File for Delimited formats. A common example is ". This is only available if the Export Format is Delimited Text.
Header Row in Export	If a header line is required, choose business names or column names from this drop-down list.
Export Options	Allows the entry of export utility options. If more than one option is required, then a semi-colon should be used between options.

Fields	Description
Trigger file	If a trigger file is specified then this file is created after the export file. It will normally contain a row count and a checksum.
Trigger Path	The purpose of the trigger file is to indicate that the export to the main file has completed and that it is now safe to load the file. Secondly, the trigger file may contain control sums to validate the contents of the main load file. This field should contain the full path name to the directory in which a trigger file is to be generated on the destination system.
Trigger Name	Refers to the name of the file that is to be created as a trigger file. A trigger file typically contains checksums (row count or the sum of a numeric column). The variable $SEQUENCE$ can be used to provide a unique sequence number for the trigger file. Also, the data/file components YYYY, MM, HH, MI, SS can be used when enclosed with the $ character. For example, a trigger file name might be budget_$YYYYMMDD$.txt which would result in a file name like budget_20150520.txt.
Trigger Delimiter	Multiple fields in the trigger file are to be separated by the trigger delimiter.
Trigger Parameter 1,2,3	The checksums are to be put in the trigger file. One of the row counts and the sum of any numeric fields in the source data.