ERR-51041

Indicator variable required but not supplied

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

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

Copyright ⓒ 2000~2016 Altibase Corporation. All Rights Reserved.

These documents are for informational purposes only. These information contained herein is not warranted to be error-free and is subject to change without notice. Decisions pertaining to Altibase’s product characteristics, features and development roadmap are at the sole discretion of Altibase. Altibase may own related patents, trademarks, copyright or other intellectual property rights of products and/or features discussed in this document.