Skip to Content
0
Former Member
Nov 24, 2008 at 05:32 PM

CR XI displays only the first 2 characters retrieved from DB2 table

36 Views

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