When using RPG stored procedures that use arrays for result sets, it can return untranslated EBCDIC in Java when...
By submitting your email address, you agree to receive emails regarding relevant topic offers from TechTarget and its partners. You can withdraw your consent at any time. Contact TechTarget at 275 Grove Street, Newton, MA.
using the native JDBC Driver on different operating system versions. To fix this problem, add ";translate binary=true" to the end of the URL. For example, if the URL passed to getConnection method of DriverManager is "jdbc:db2:myas400" the new URL would be "jdbc:db2:myas400;translate binary=true".
This problem is that the RPG Array is returning CCSID 65535.