Database object name lengths
The limit of the lengths of SQL database objects names varies with different database server versions.
HCL
OneDB™ Version
9.2 and later allows you to use long identifiers for database object
names. Most object names can have 128 characters. The following table
lists the objects whose names must be fewer than 128 characters.
| Object | Maximum characters |
|---|---|
| Project | 32 |
| Error code | 5 |
| Interface | 64 |
| Opaque data type (C) | 110 |
| Opaque data type (ActiveX) | 80 |
| Client file | 64 |
Tip: The object name fields in BladeSmith
are not 128 characters wide; therefore, you might not be able to distinguish
between objects on a list if they have similar names. You can display
the full name of an object with a tooltip. Select the object and place
the cursor over it to display the tooltip.
HCL
OneDB Version 9.14 limits
database object names to 18 characters, except for error codes, which
are always five characters, and opaque data type names, which are
limited to 14 characters. The names of opaque data type support routines
contain the name of the opaque data type plus a four-character routine
identifier.
Important: BladeSmith does not prevent you
from specifying long identifiers if your database server version is
9.14; however, source code that contains long identifiers does not
compile if the database server version is earlier than Version 9.2.