A DB2 SQLExecute CLI call works fine when I run it against a database in a remote DB2 instance on node A. However, if I switch to a remote DB2 instance on node B, I get the following error from the SQLExecute call:

CLI0109E: String data right truncation.

Can anyone explain why the same code executed on the same local machine would give an error when going against one remote instance and not against another ?

Both remote instances are DB2 8.1.4. Their db2 variables (db2set -all) are the same, and their db2cli.ini files are identical. There is one difference - the DB2CODEPAGE variable is a global variable in node A and an instance variable at node B.

Thanks for any input,
Colm.