| |
- Causa
- Tipo de coluna inválida para opção FIELDPROC, column-name.
A especificação para coluna , tipo DISTINCT, FUNCTION, ou PROCEDURE data-item contém cláusulas incompátiveis.
There is an error in the data item specification in a CREATE or ALTER statement.
Incompatible specifications are present such as "INTEGER and FOR BIT DATA".
The location of the error is given by data-item as follows:
- For a CREATE or ALTER TABLE statement, data-item gives the name of the column containing the error.
The error could be an invalid specification of FOR BIT DATA, FOR SBCS DATA, FOR MIXED DATA, or FIELDPROC for column data-item.
- For a CREATE FUNCTION or CREATE PROCEDURE statement, data-item is a token that identifies the area of the problem in the statement.
For example, "PARAMETER 3" or "RETURNS" or "CAST FROM".
- For a CREATE DISTINCT TYPE statement, data-item gives the name of the type being defined.
- Ação do sistema
- The statement cannot be executed.
- Resposta ao Desenvolvedor
- Correct the SQL statement by removing the incompatible specification.
SQLSTATE: 42842
© Copyright IBM Corp.
|
| |