Character/Text Column Corruption in Returned Data from DB2 12 via an ODBC connection on macOS

0

Executing a SQL query using Excel against DB2 for z/OS 12 via ODBC on macOS.
Problem is returned character column data contains corrupted (or unsubstituted) bytes in column names and result content.

IBM Data Server:

DB21085I  This instance or install (instance name, where applicable: "*") uses  "64" bits and DB2 code release "SQL11011" with level identifier "0202010F". Informational tokens are "DB2 v11.1.1.1", "s1612051900", "DARWIN64111", and Fix  Pack "1". Product is installed at "/Applications/dsdriver".

Simplest Query Example: select count(*) as colcount from sysibm.syscolumns

Example of Column Name Corruption

The bytes after the expected value of "COLCOUNT" appear as "?" which are substitution errors?

DB2 on z/OS code page is EBCDIC/37, and mac uses a derivative of ASCII. What do I need to code in my odbc.ini definition for locale and/or charset to fix these extraneous bytes at the end of a character column label and character column content?

I am new to macOS ... is this a known issue? Experiencing difficulty finding similar postings.

Lance

Posted 2019-07-01T05:10:35.963

Reputation: 1

A slightly less simple pictorial example ... – Lance – 2019-07-01T05:11:19.583

No answers