Informix Error -11075: Invalid scale value.
Cause and resolution
Invalid scale value.
The value that the argument ibScale specifies is outside the range of values supported by the data source for a column of the SQL data type that the fSqlType argument specifies. For a list of supported values for the column type that fSqlType specifies, check the Informix CLI Programmer's Manual.
This Informix CLI error code is the same as SQLSTATE value S1094. The following function can return this error code: SQLBindParameter().
The ibScale value was invalid for the Informix CLI SQL data type (fSqlType) argument. Set ibScale to a valid value.
Oninit® Troubleshooting Guidance
Reasons / Common Causes
-11075 fires when SQLBindParameter()'s ibScale argument is outside the range the data
source supports for the column type fSqlType specifies — per the official guidance, this
is the same as SQLSTATE value S1094.
ibScaleoutside the supported range for thefSqlTypecolumn type, per the official guidance — the direct, only cause.
Solutions / Resolution
- Check the Informix CLI Programmer's Manual for the supported scale values for that column type, per the official guidance.
Examples
N/A
No specific triggering statement is documented beyond an out-of-range scale value.
Diagnostic Checks
- Check the
ibScaleargument against the valid range for thefSqlTypecolumn type named in the same call.
Related Errors / Related Topics
No closely related error codes are cross-referenced for -11075 in this set yet.
SQLBindParameter()'s ibScale argument was outside the supported range for its column
type — check the CLI manual for valid scale values.