Microframe Corporation 3007 Series Uživatelská příručka stáhnout pdf (Strana 77)

1-69

1 to 199

 The length of the entire key (all segments) is so large that less

than 4 keys fit on a key page. For example, a 200 byte key on a

512 byte page.

 A key segment length is 0 or greater than 255 bytes. The length

of a key segment must agree with its key type if the key type

implies a length (for example, an integer key must have a length

evenly divisible by two). Each key page in the file must be large

enough to hold at least four keys. If the page size is too small to

accommodate four occurrences of the specified key length (plus

overhead), you must increase the file page size or decrease the

key length.

An additional byte of storage space is needed for the null

indicator for the column. This error occurs through a SQL

CREATE INDEX statement, or through the creation of a SQL

PRIMARY KEY or FOREIGN KEY, if the index, or key,

references a null CHAR column of 255 characters (or VARCHAR

of 254). This additional byte causes the actual length of the index

to be one byte longer, or 256 bytes. To resolve the error, reduce

the size of the column or create the column as NOT NULL and

try again. For a foreign key, if you decrease the size of the

column, you must decrease both the referencing column and the

referenced column.

 A key segment length is greater than 4 and the key segment data

type is AUTOINCREMENT.

 A key segment data type is DATE, TIME, BFLOAT, or

AUTOINCREMENT and the segment length is an odd number.

 A key segment data type is NUMERICSTS and the segment

length is less than 2.

 A key segment data type is CURRENCY or TIMESTAMP and

the segment length is not 8.

 A key segment data type is DATE, TIME, BFLOAT, or

AUTOINCREMENT and the segment length is an odd number.

 A key segment data type is NULL INDICATOR SEGMENT and

the segment length is not 1.

 A key segment data type is GUID and the segment length is not

16.

 A key segment data type is BINARY (“Use Old Style Binary Data

Type” flag is “on”) and the segment length is odd.

1 2 ... 72 73 74 75 76 77 78 79 80 81 82 ... 251 252

Žádné komentáře

Microframe Corporation 3007 Series Uživatelská příručka Strana 77