THE NAME IS TOO LONG. MAXIMUM ALLOWABLE SIZE IS size

Explanation: The name is too long. The maximum permissible length for names of that type is indicated by size.

Names for the following cannot contain more than 128 characters:

• Savepoint-name

Names for the following cannot contain more than 64 characters:

• Version-id

Names for the following cannot contain more than 18 characters (20 including SQL escape characters, if present):

• SQL columns
• SQL tables
• SQL views
• SQL indexes
• SQL aliases
• SQL synonyms
• Collection-ids
• Check constraints
• Functions
• Stored procedures
• User-defined types

Names for the following cannot contain more than 16 characters:

• Location-name

The following cannot contain more than 8 characters:

• Table qualifiers
• View qualifiers
• Library member names specified in an INCLUDE statement
• Storage group names
• Database names
• Table space names
• Application plans
• Database request modules (DBRMs)
• Referential constraint names specified in CREATE or ALTER TABLE statements
• Package-ids
• Schema names
• Trigger names

Host variable names cannot contain more than 64 characters. Volume serial numbers cannot contain more than 6 characters. Labels cannot contain more than 30 characters.

System Action: The statement cannot be processed.

Programmer Response: Choose a shorter name for the object.

SQLSTATE: 42622