Binary Data Types

Omnidex supports several binary data types. The length is implied in these Data types, eliminating the need to express the number of bytes. All of these data types are IEEE standard data types.

[SIGNED] TINYINT

Binary data stored in one byte from -128 to 127. This is equivalent to a data type [SIGNED] INTEGER length 1.

At this time, Omnidex is unable to index a negative value of type TINY INT. To get around this limitation, you can declare the column as a SMALL INT in the Omnidex Environment Catalog.

COLUMN "ACTIVE" PHYSICAL "ACTIVE" DATATYPE TINYINT

UNSIGNED TINYINT

Binary data stored in one byte from 0 to 255. This is equivalent to a datatype UNSIGNED INTEGER length 1.

COLUMN "COMPUTER" PHYSICAL "COMPUTER" DATATYPE UNSIGNED TINYINT

[SIGNED] SMALLINT

Binary data stored in 2 bytes from -32768 to 32767. This is equivalent to a datatype [SIGNED] INTEGER length 2.

COLUMN "TYPECODE" PHYSICAL "TYPECODE" DATATYPE SMALLINT

UNSIGNED SMALLINT

Binary data stored in 2 bytes from 0 to 65535. This is equivalent to a datatype UNSIGNED INTEGER length 2.

COLUMN "DEPTID" PHYSICAL "DEPTID" DATATYPE UNSIGNED SMALLINT

[SIGNED] BIGINT

Binary data stored in 8 bytes from -( 2 ^ 63 ) to ( 2 ^ 63 ) - 1. This is equivalent to datatype [SIGNED] INTEGER length 8.

COLUMN "ACCT" PHYSICAL "ACCT" DATATYPE BIGINT

UNSIGNED BIGINT

Binary data stored in 8 bytes from 0 to ( 2 ^ 64 ) - 1. This is equivalent to datatype UNSIGNED INTEGER length 8.

COLUMN "LICENSEE" PHYSICAL "LICENSEE" DATATYPE UNSIGNED BIGINT

[SIGNED] INTEGER

Binary data stored in 4 bytes from -2147483648 to 2147483647. This is equivalent to datatype [SIGNED] INTEGER length 4.

COLUMN "CUSTOMER_NO" PHYSICAL "CUSTOMER_NO" DATATYPE INTEGER

UNSIGNED INTEGER

Binary data stored in 4 bytes from 0 to 4294967296. This is equivalent to datatype UNSIGNED INTEGER length 4.

COLUMN "ACCT" PHYSICAL "ACCT" DATATYPE UNSIGNED INTEGER

FLOAT

Floating point data stored in 4 bytes. This is equivalent to datatype FLOAT length 4.

COLUMN "RETAILPRICE" PHYSICAL "RETAILPRICE" DATATYPE FLOAT

DOUBLE

Double-precision floating point data stored in 8 bytes. This is equivalent to datatype FLOAT length 8.

COLUMN "DISCOUNT" PHYSICAL "DISCOUNT" DATATYPE DOUBLE

Top