| Table of Contents |
|---|
Version
All versions
Explanation
This error occurs when using a precompiler in the development environment.
Cause
When the INDICATOR variable is not specified while NULL is returned as the return value of a column in the SELECT statement, this error occurs with SQL_SUCCESS_WITH_INFO.
Action
| Code Block | ||
|---|---|---|
| ||
int IND_C1; int IND_C2; EXEC SELECT C1, C2 INTO :H_C1 INDICATOR :IND_C1 , :H_C2 INDICATOR :IND_C2; |
This error can be avoided by using the option ‘unsafe_null’ in the precompiler option or using the INDICATOR variable as in the above example.
Reference
N/A