OidFieldSeparator

Character

. (the period, or dot, character)

Purpose

Set the OidFieldSeparator parameter in the JADE initialization file on the server to a single punctuation or similar character (for example, @) if you want to customize the OID field separator. This can be useful when the default OID String values that are produced are misinterpreted by a third‑party tool as a different ODBC type such as a Decimal.

The JADE ODBC driver formats and parses OID strings using the specified field separator.

One character only can be specified. You can specify only a punctuation or similar character; alphanumeric (alphabetic and numeric) characters and whitespace are not allowed. When the value of this parameter is set to an invalid character or a whitespace, a message is logged and the default value is used.

Notes

When using the JADE ODBC thin client driver, this parameter must be set in the JADE initialization file for the server application.

This parameter is global; that is, it takes effect for every ODBC query made in your JADE system.

Parameter is read when …

The ODBC connection is established.

2016.0.03 (Service Pack 2) and higher