Property | S/T | Description |
|---|---|---|
Binary Format | T | Specifies how to represent Binary data within your target SQL script. The default is SQL Hexadecimal Literal. The other available options are C/C++ Literal and Hexadecimal Number. |
ByteOrder | T | Allows you to specify the byte order of Unicode (wide) characters. The default is Auto and is determined by the architecture of your computer. The other list box options are Little Endian and Big Endian. Little Endian byte order is 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 byte order is used by IBM 370 computers, Motorola microprocessors and most RISC-based systems and stores the values in the same order as the binary representation. |
Date Format | T | Specifies how to format dates within your target SQL script. The default format is month/day/four-digit year (or mm/dd/yyyy). If you wish your date formats to appear in another format, highlight the default value and change it to the format you wish (for example, yyyy/mm/dd). |
Date Time Format | T | Specifies how to format dates that include times within your target SQL script. The default format is mm/dd/yyyy H24:MM:SS. If you wish to use another format, highlight the default value and change it to the format you wish (for example, yyyy/mm/dd H12:MM:SS). |
Encoding | T | This allows you to select the type of encoding used with your source and target files. • Shift-JIS encoding is meaningful only in Japanese operating systems. • UCS-2 is no longer considered a valid encoding name, but you may use UCS2. In the XML file, change UCS-2 to UCS2. • The Encoding property is not the encoding of the database that you connect to, but rather the encoding in which the connector expects to receive SQL query statements to be sent to the database. |
Line Break | T | Specifies which character(s) to write to the target SQL script as line breaks. The default is CR-LF. The available options are CR-LF (default), LF, CR, LF-CR, Empty Line, and None. |
Name Quote | T | Specifies how to delimit the table and column names within the target SQL script. The default is double quotes. The available options are double quotes, single quote, and None. |
Order Mark | T | The Order Mark is a special character value that is sometimes written to a Unicode text file to indicate the byte order used for encoding each of the Unicode characters. You have the option of writing byte order mark at the beginning of Unicode (wide) output or not. The default is false. If you wish to have the byte order mark placed at the beginning of the output, change this option to true. |
UpdateNullFields | T | Null values are sent to the database when inserting or updating records. The default is true. If you select False, null values are not sent to the database when you insert or update records. When set to false, this property forces the connector to operate in unbound mode, which may cause slower performance. Best Practice — If fields in the target record are not mapped, then the null values are passed to the target. If you do not want to write to these fields, then it is recommended to set the value for UpdateNullFields to False. |
Statement Separator | T | Specifies what characters to output as a statement separator to your target SQL script. The default value is a semicolon ( ; ). The available options are semicolon and None. |
String Quote | T | Specifies how to delimit strings within your target SQL script. The default is a single quote ('). The available options are double quote ("), single quote (") and None. |
Time Format | T | Specifies how to format times within the target SQL script. The default format is H24:MM:SS. If you wish your time format to appear in another form, highlight the default value and change it to the format you wish. |
Time Stamp Format | T | Specifies how to format times within the target SQL script. The default format is H24:MM:SS. If you wish the time to appear in another form, highlight the default value and change it to the format you wish. This format may not have a Null value. |