Hello tlm,
J'ai un SQLCODE -408 lors de la compilation de mon programme.
Voici la description officielle de l'erreur :
Je fais un select into d'un décimal dans un integer (en fait l'équivalent d'un integer en cobol : généré par DCLGEN) et l'erreur survient lors de l'INSERT qui suit (alors que la colonne est en integer et que la variable hote aussi, DCLGEN oblige).SQL0408N A value is not compatible with the data type of its assignment target. Target name is "<name>".
Explanation: The data type of the value to be assigned to the column, parameter, SQL variable, or transition variable by the SQL statement is incompatible with the declared data type of the assignment target. Both must be:The statement cannot be processed.
- Numeric
- Character
- Graphic
- Dates or character
- Times or character
- Timestamps or character
- Datalinks
- The same distinct types
- Reference types where the target type of the value is a subtype of the target type of the column.
- The same user-defined structured types. Or, the static type of the value must be a subtype of the static type (declared type) of the target.
User Response: Examine the statement and possibly the target table or view to determine the target data type. Ensure the variable, expression, or literal value assigned has the proper data type for the assignment target.
Vous avez une idée parce que là je sais plus quoi faire
merci
Partager