| |
- Causa
- THE NAME AT ORDINAL POSITION position-number IN THE STATEMENT, WITH NAME object-name, WAS TRUNCATED.
At least one object name in the described statement was truncated.
The object name was either too long, or became too long after code page conversion.
- position-number
- The ordinal position number of the name that was truncated.
For the describe output of a prepared query, the ordinal position is relative to the order of columns in the select list of the query:
- For DESCRIBE TABLE, the position is relative to the order of the columns in the table definition.
- When describing the output of a CALL statement, the position is relative to the OUT or INOUT parameters of the procedure to which
the CALL resolved.
- When describing the input of a CALL statement, the position is relative to the IN or INOUT parameters of the procedure to which the
CALL resolved.
- object-name
- The name of the column, distinct type, or distinct type schema that was truncated.
The length of the column name, distinct type name, and user defined type schema name are limited when using the SQLDA structure.
- Resposta ao Desenvolvedor
- If the exact name is significant, do one of the following:
- For the name of a result column that is specified in an AS clause, change the name in the AS clause so that the result column has a shorter
name.
- For the name of a column in a table or view, drop and re-create the table or view so that the column has a shorter name, or provide
a shorter name for the result column in the query with an AS clause.
- For the name of a column in a table, use the ALTER TABLE statement to rename the column so that it has a shorter name.
SQLSTATE: 01665
|
| |
