My team and working with AS400 data and we need to know how to convert binary data (CCSID 65535) becuase we aren't getting this data when we try to query. We get the following error:
BINARY data can't be displayed.
Dylan Wan Dan Brock Ari Gnanam
Specifically being able to bring in an CHAR () FOR BIT DATA column.
joseph. delpercio The AS400 DB2 driver you're using isn't a productized driver so we don't have a lot of experience with it. Does it support CAST() to have the DB2 database convert the datatype in your SELECT statement?
Hey Dan, we were able to figure it out with adding additional details into the connection string
joseph. delpercio Great! Can you post what those additional details were so we can refer others to this thread down the road?
You bet: Connection Properties: jdbc:as400://"Server or IP"/"DB";translate binary=true
© Incorta, Inc. All Rights Reserved.
A new community experience is coming! If you would like to have beta access to provide feedback, please contact us at firstname.lastname@example.org.