The following table provides a summary of indicator variable usage.
| Indicator value | Supplying value to database | Receiving value from database |
|---|---|---|
| > 0 | Host variable value | Retrieved value was truncated—actual length in indicator variable |
| 0 | Host variable value | Fetch successful, or conversion_error set to On |
| -1 | NULL value | NULL result |
| -2 | NULL value | Conversion error (when conversion_error is set to Off only). SQLCODE indicates a CANNOT_CONVERT warning |
| < -2 | NULL value | NULL result |
For more information about retrieving long values, see GET DATA statement [ESQL].
| Send feedback about this page via email or DocCommentXchange | Copyright © 2008, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.0 |