table name size

Sets the maximum size of table names in the database.

USYS$Mnemonic_PARAMS = table name size : Number

USYS$Mnemonic_PARAMS = tblnmsize : Number

Arguments

Number—maximum number of characters allowed for table names.

Use

Applies to	Mnemonic	Connector Syntax
DB2 connector	DB2	`USYS$DB2_PARAMS`
ODBC connector	ODx	`USYS$ODx_PARAM`

Description

When specified, the connector truncates table names to the specified size.

DB2

When specified, the connector truncates table and index names to the specified size. Index names are truncated in such a way that when an "I" followed by the index number is appended, the name will still not exceed the specified size.

The minimum size is 8; if a lower value is specified, no truncation occurs.

USYS$DB2_PARAMS table name size : 18