Version
All versions
Explanation
Unable to select data.
Cause
This error message is output when:
1. the CHAR data type value returned from the SELECT statement is larger than the declared host variable.
2. a parsing error occurs in the executed query due to NULL values or special characters.
Action
1. Connect to the database
2. Check the table column size.
3. Declare the host variable used in the statement with the length (column size + 1 byte).
4. Check whether rpad was used in the statement where the error occurred.
5. If so, rewrite the query.
Reference
N/A