Microframe Corporation 3007 Series Guía de usuario descargar pdf (Pagina 20)

1-12

Status Codes

-3014: Trigger already exists

You are trying to create a trigger, but a trigger with the specified

name already exists. Either use a different name, or drop the existing

trigger before creating the new one.

-3015: Procedure already exists

You are trying to create a stored procedure, but a stored procedure

with the specified name already exists. Either use a different name, or

drop the existing stored procedure before creating the new one.

-3016: The fixed-portion size of a record exceeds 65535

bytes

The total size of the fixed-length portion of a record has exceeded

65535 bytes. The total size of the fixed-length portion of any data

record may not exceed 65535 bytes. The fixed-length portion of any

data record is made up of the following:

 all the columns that have a fixed sized (all columns except for

LONGVARCHAR and LONGVARBINARY)

 one byte for each column that allows null values

 8 bytes for each variable-length column (column of type

LONGVARCHAR or LONGVARBINARY).

Status code -3016 is returned if you attempt to create a table that

exceeds this limit, or if you attempt modifications that would cause

a table to exceed the limit.

To determine the size in bytes of the fixed-length portion of a record

before you attempt to create a new table, you can use the following

calculation:

(sum of the fixed-length column sizes in bytes) + (number of

nullable columns) + (8 * number of variable-length columns) =

record size in bytes

If you want to determine the size of the fixed-length portion of the

record for an existing data file, you can use the BUTIL -STAT

command to display a report that includes this information.

-3017: Invalid path/filename

The path/filename for the data file is too long.

1 2 ... 15 16 17 18 19 20 21 22 23 24 25 ... 251 252

Sin comentarios

Microframe Corporation 3007 Series Guía de usuario Pagina 20