Inconsistent USING clauses
Having data types changing at each execute is no longer supported.
Important: This issue applies to non-Informix databases
only.
Before version 2.00, it was possible to execute a prepared statement with the variable list
changing at each EXECUTE
statement:
DEFINE var1 DECIMAL(6,2)
DEFINE var2 CHAR(10)
DEFINE var3 DATE
PREPARE st1 FROM "INSERT INTO tab1 VALUES ( ?. ?, ? )"
EXECUTE st1 USING var1, var2, var3
EXECUTE st1 USING var2, var3, var1 -- different order = different data types
The database interface of version 2.00 has been rewritten for better performance. Having data types changing at each execute is no longer supported.
Error -254 will be raised if different data types are used in subsequent EXECUTE statements (with the same statement name).