Format Options Dialog Box

The following fields and controls are used in the Format Options dialog box:

String Delimiter

The type of quotes (single or double) used to represent constant string values that are referenced by the SQL in the DBRM. This option should match the option used to delimit the literal strings referenced by your embedded SQL.

Note: When you are binding the default DBRM for XDB Link, you must use the Single Quote option.

Decimal Delimiter

You must set this field if the DBRM file contains a decimal literal that does not match the host system's default value.

• Period indicates that the decimal point is represented with a period (for example 3.17).
• Comma indicates that the decimal point is represented with a comma (for example 3,17).

Default Decimal Precision

One of the following options:

• 0 uses the system default value.
• 15 specifies a decimal precision of 15 places.
• 31 specifies a decimal precision of 31 places.

Default Char Subtype

Options for storing ambiguous character data in the database:

• System Default specifies the system default value of the DB2 location to which you are binding.
• SBCS specifies a single-byte character set.