When retrieving data from a DB2 table, one of the columns will only display the first two characters. The expected results will display a minimum of 240 characters. In DB2 the column's datatype is varChar(1000). According to a COBOL Copybook for this column/field it identifies positions 3 & 4 (of this field) as binary data. The Copybook shows - PIC S9(4) BINARY).
In HEX positions 3 and 4 are shown as 00 and 01 respectively. Here is a sample of the data shown with hexadecimal:
2R..262-OCR
FD00FFF6DCD444444444444444
29012620639000000000000000
The ODBC driver used is IBM DB2 ODBC Driver. When connecting with CR XI I've tried 'ODBC (RDO)', 'OLE DB (ADO)', and 'DB2 Unicode'. The product version is 11.0.0.1282.
If you need any additional information please let me know.
Thank you,
Bill