Wow. So the JDBC driver knew he was talking to a CCSID 37 program and a CCSID 297 (or whatever the appropriate French CCSID is) machine and was smart enough to convert column names from English to French. That's quite impressive. I'd be interested to see what happens if you run the following statement on a dummy file name FILE with a single field names FIELD: UPDATE FILE SET FIELD = '#' Would the database get x'7B' (CP037 hashcode) or x'B1' (CP297 hashcode)? Joe -----Original Message----- From: David Gibbs Changing the user profile we used to connect to the iSeries to use CCSID 37 and LANGID ENU worked.
As an Amazon Associate we earn from qualifying purchases.
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.