Problem:

RTS114 when using Dynamic SQL with SQLDA and IBM DB2.

Application code failed with an RTS114 error. The same code executed on a IBM Mainframe with no errors.

Resolution:

This was caused by the use of COMP-4 in the SQLDA field definitions.

This was valid on an IBM platform but DB2 on the Intel platform needs to use COMP-5. This is reverse byte ordering from COMP-4.

The invalid data in the COMP-4 fields caused the the application code to fail with a RTS114.

The solution is to amend the SQLDA defintion to use COMP-5 or use the MAKESYN directive to force the COMP-4 to be treated as COMP-5.