Property | S/T | Description |
|---|---|---|
Encoding | T | Type of encoding to use with target files. The default value is OEM. Shift-JIS encoding is used only in Japanese operating systems. UCS-2 is no longer considered a valid encoding name, but you may use UCS2. In the data file, change UCS-2 to UCS2. Note: This property is not encoding of the database that you connect to, but it is the encoding in which the connector expects to receive SQL query statements that must be sent to the database. |
ByteOrder | T | Byte order of Unicode (wide) characters: • Auto (default): Byte order is determined by the system architecture. • Little Endian: Generally used by Intel machines and DEC Alphas and places the least significant portion of a byte value in the left portion of the memory used to store the value. • Big Endian: Used by IBM 370 computers, Motorola microprocessors and most RISC-based systems and stores the values in the same order as the binary representation. |
OrderMark | T | Special character value sometimes written to a Unicode text file to indicate the byte order used for encoding each of the Unicode characters. In the integration platform, you have the option of writing byte order mark at the beginning of Unicode (wide) output or not. The default is false. If you want to have the byte order mark placed at the beginning of your output, change this option to true. |
RecordSeparator | T | Record separator between records. Most delimited ASCII files have a carriage return-line feed (CR-LF) between records. The system default setting enables the same transformation to run with CR-LF on Windows and with LF on Linux systems without having to change this property. If the record separator is not a printable character, enter escape CR-LF with a backslash, an X, and the hexadecimal value for the separator. |
FieldSeparator | T | Field separator between fields. The available options are: • , (default) • tab • space • CR-LF • LINESEP • LF • CR • LF-CR • | • None If you need an alternate field separator other than one from the list, you can type the value. If the field separator is not a printable character, replace CR-LF with a backslash, an X, and the hexadecimal value for the separator. The connector reads the data from the file as Unicode and looks for the Unicode characters specified as the separators to break the data into fields or records. After this, the actual Unicode data is assigned to fields or records. |
FieldStartDelimiter | T | Delimited Unicode files are presumed to have beginning-of-field delimiter. The default delimiter is a quotation mark (“). However, some files do not contain field delimiters, so this option is available for both source files and your target files. To read from or write to a file with no delimiters, set FieldEndDelimiter to None. |
FieldEndDelimiter | T | Delimited Unicode files are presumed to have end-of-field delimiter. The default delimiter is a quotation mark (“). However, some files do not contain field delimiters, so this option is available for both source files and target files. To read from or write to a file with no delimiters, set FieldStartDelimiter to None. |
Header | T | In some files, the first record is a header record. For source data, you can remove it from the input data and cause the header titles to be used automatically as field names. For target data, you can cause the field names in your source data to automatically create a header record in your target file. To identify a header record, set Header to true. The default is false. Note: If you are appending data to an existing file, set Header to false. |
FieldDelimitStyle | T | Determines whether the specified FieldStartDelimiter and the FieldEndDelimiter is used for all fields, only for fields containing a separator, or only for text fields as follows: • All (default): Places the delimiters specified in FieldStartDelimiter and FieldEndDelimiter before and after every field. For example, "Smith","12345","Houston". • Partial: Places the specified delimiters before and after fields only where necessary. A field that contains a character that is the same as the field separator will have the field delimiters placed around it. A common example is a memo field that contains quotes within the data, "Customer responded with "No thank you" to my offer" • Text: Places delimiters before and after text and name fields (non-numeric fields). Numeric and date fields do not have FieldStartDelimiter or FieldEndDelimiter. For example, "Smith", 12345,"Houston", 11/13/04 • Non-numeric: Places delimiters before and after all non-numeric types, such as date fields. An important difference between non-numeric and text is that non-numeric delimits date fields, while text does not. |
StripLeadingBlanks | T | By default, the integration platform strips leading blanks in delimited Unicode data. To leave the leading blanks, set StripLeadingBlanks to false. |
StripTrailingBlanks | T | For a Unicode target file, by default the integration platform strips trailing blanks in the data. To leave the trailing blanks, set StripTrailingBlanks to false. |
TransliterationIn | T | Character or a set of characters that must be filtered from the source data. For any character in TransliterateIn, the corresponding character from the TransliterateOut property is substituted. If there is no corresponding character, the source character is filtered completely. TransliterateIn supports C-style escape sequences such as \n (new line), \r (carriage return), and \t (tab). |
TransliterationOut | T | Character that must be substituted for another character from the source data. For any character in TransliterateIn, the corresponding character from the TransliterateOut property is substituted. If you want the source character to be filtered completely, leave this field blank. If there are no characters to be transliterated, leave this field blank. The TransliterateOut property supports C-style escape sequences such as \n (new line), \r (carriage return), and \t (tab). |
MaxDataLen | T | Maximum number of characters to write to a field. If this value is set to 0 (the default), the number of characters written to a field is determined by the field length. If you set this value to a number other than zero, data may be truncated. |
NullIndicator | T | Special string used to represent null values. Select predefined values or type any other string. When writing a null value, the contents of the null indicator string are written. |