| |
- Causa
- YOU CANNOT INSERT A VALUE INTO A COLUMN THAT IS DEFINED WITH THE OPTION GENERATED ALWAYS COLUMN column-name.
When inserting into a table, a value was specified for column column-name with the GENERATE ALWAYS attribute.
GENERATED ALWAYS columns should not be specified in the column-list for an insertion unless the corresponding entry in the VALUES list is DEFAULT.
- Ação do sistema
- The INSERT is not performed.
- Resposta ao Desenvolvedor
- Remove the column from the column-list or specify DEFAULT for the GENERATED ALWAYS column in the VALUES clause.
You may also use the OVERRIDING clause as a possible solution for this situation.
See INSERT in DB2 SQL Reference for more information about the OVERRIDING USER VALUE clause.
SQLSTATE: 428C9
© Copyright IBM Corp.
|
| |
