Error Messages (I)

A B C D E F G H I J K L M N O P Q R S T U V W X Y Z #

Identifier too long -- maximum length is 18 (-253)

"Identifier too long" error messages arise when a SQL identifier exceeds the maximum number of characters. Informix Dynamic Server 2000 sets maximum identifier length at 128 characters. Other Informix databases set the maximum length at 18 characters. If you experience "Identifier" errors, insure that you have not violated this standard. Additionally, insure that punctuation errors do not cause two identifiers to combine into one.

Note: The SQL Identifier is the catalog.schema.tablename combination which specifies or "qualifies" the table against which you want to query.

Evidence

Session Rules Book
Request Broker Log
DBMS Version