0

Using Rational Application Developer for Websphere 9.1.0 to make a data connection to a DB2 iseries file, the column data displays a Hex(I think).

I have added the "translateBinary=true" property to the url connection but is does not change the display results.

jdbc:as400:host;translateBinary=true

Machavity
  • 30,841
  • 27
  • 92
  • 100
Steve Dyke
  • 155
  • 3
  • 14
  • All columns or just one? If the latter, what's the data type of the affected column? – F Rowe Oct 30 '17 at 17:14
  • Several columns but not all. Looking at it closer I do not think the connection driver is even considering the translateBinary property. – Steve Dyke Nov 01 '17 at 12:16

1 Answers1

1

DB2 for iSeries uses EBCDIC natively but the Toolbox JDBC driver will automatically attempt to translate EBCDIC to unicode for you. Since only some fields are not being translated, it is likely those fields are tagged with CCSID 65535 indicating to the Toolbox driver not to translate them. You can either tag those fields with a CCSID indicating to translate, or use the translate binary driver property, which you're attempting to. The property is not working because you mis-typed it. According to this faq, it should be ";translate binary=true" instead of what you've tried.

F Rowe
  • 2,042
  • 1
  • 11
  • 12