FP_NBIT_IQ15_COMPATIBILITY Option

Allowed Values

ON, OFF

Default

FP_NBIT_IQ15_COMPATIBILITY='OFF' in all new 16.0 databases. FP_NBIT_IQ15_COMPATIBILITY='ON' in upgraded SAP Sybase IQ 15 databases.

Scope

Option can be set at the database (PUBLIC) or user level. When set at the database level, the value becomes the default for any new user, but has no impact on existing users. When set at the user level, overrides the PUBLIC value for that user only. No system privilege is required to set option for self. System privilege is required to set at database level or at user level for any user other than self.

Requires the SET ANY PUBLIC OPTION system privilege to set this option. Can be set temporary for an individual connection or for the PUBLIC role. Takes effect immediately.

Remarks

The FP_NBIT_IQ15_COMPATIBILITY option provides tokenized FP support similar to that available in SAP Sybase IQ 15. All newly created and modified tokenized FP indexes in 16.0 will be NBit. The only 15 style FP(1),FP(2), and FP(3) byte FP indexes available in 16.0 are those from an upgraded database that have had only Read-Only activity.

The FP_NBIT_IQ15_COMPATIBILITY ON/OFF setting only pertains to tokenized FP creation and cut-off behavior:

If FP_NBIT_IQ15_COMPATIBILITY='ON', the database engine:

Enables the MINIMIZE_STORAGE, FP_LOOKUP_SIZE, FP_LOOKUP_SIZE_PPM options
Creates DATE datatypes as NBit FP, even if IQ UNIQUE(0) is specified
Rolls over to Flat FP at the 3 byte FP cutoff (16,777,216 distinct)
Can tokenize data widths <= 255

If FP_NBIT_IQ15_COMPATIBILITY='OFF':

MINIMIZE_STORAGE, FP_LOOKUP_SIZE, FP_LOOKUP_SIZE_PPM options are ignored.
DATE datatypes are not automatically NBit
Data widths <=32767 may be tokenized
NBit FP (tokenized) upper bound limit is NBit 31 (2,147,483,648 distinct values)
NBit sizing options determine rollover behavior:
- IQ UNIQUE(0) loads a column as Flat FP
- Columns without IQ UNIQUE load as NBit up to the auto-size limits
- Columns where IQ UNIQUE(n) is less than the auto-size limit load as NBit

Important: The FP_NBIT_IQ15_COMPATIBILITY option provides tokenized FP support similar to that available in SAP Sybase IQ 15, not complete database compatibility. All SAP Sybase IQ 15 runtime behavior is available using the 16.0 interface. Avoid running a 16.0 database with FP_NBIT_IQ15_COMPATIBILITY='ON'.