Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Migrated to Confluence 4.0
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
languagesql
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