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.
A slightly less simple pictorial example ... – Lance – 2019-07-01T05:11:19.583