DSXchange

Strange. The parameter marker the ODBC stage uses in not numbered - Oracle, yes but not ODBC. It uses a simple question mark, so you would need to change all references to colon-anything to '?' - and then ensure they are listed in the same order as your columns are defined in the stage.

The Dynamic Relational Stage always displays SQL with Oracle (positional) parameter markers, even though it uses the correct ones "under the covers".

However, the poster specifies that an ODBC stage has been used. The SQL was passed through to DB2 (the message came back from the database, not from the driver), so it contained only valid parameter markers.

Your diagnosis, therefore, is not correct. DB2 is complaining about some other 1 in the SQL. Have you, for example, used 1 in a WHERE clause when the data type is Char or VarChar, and you should have used '1'?