Developing Portable Applications : 3. Application Considerations : Implementation Differences : Object Name Length
 
Share this page                  
Object Name Length
Different objects have different limits on the maximum length of names.
256 Bytes
32 Bytes
Table
Column
Partition
Procedure
Procedure parameter
Rule
Sequence
Synonym
Constraint
Database
User, owner, group, role, schema
Location
Event, alarm
Profile
Node
Password
In Ingres 10.0, the maximum supported length of some object names was increased to 256 bytes. The system catalog iidbcapabilities reports the maximum length of object names for the host DBMS.
Unless buffers are too small, long names are passed as-is to the host DBMS. The DBMS is therefore responsible for length checks and error reporting. Enterprise Access checks only whether the names are too long for OpenSQL (maximum 256 bytes, like Ingres 10.0). No checks are made for DBMS-specific maximum lengths. This means that DBMS-specific errors will be raised.
This approach is used in all cases, for example, CREATE TABLE, SELECT, UPDATE, INSERT, DELETE. It also applies to REGISTER PROCEDURE and EXECUTE PROCEDURE, which means that long names could be used by the client if the REGISTER PROCEDURE is written to use short names in the host DBMS.
Note:  For maximum portability, limit names to a maximum of 18 characters.