Incorrect Table Definition in WmDB using ODBC

IS version 6.1 SP1, is running on Windows 2000 Platform x86 version 5.0.

I am using a WmDB adapter to connect to a catalog using the driver sun.jdbc.odbc.JdbcOdbcDriver. One of the tables contains a field which is broken down into an array of 4 items which occur 7 times. The items display in the table definition once, and when I try to read the table, I get the error “Numeric value out of range.” I am able to read this table in Impromptu, however the table definition has the items defined individually (ie. item1-1 item2-1 item3-1 item4-1 item1-2, etc.). In IS, the table only shows item1 item2 item3 item4. Both Impromptu and IS are using the same catalog.

I don’t know if it helps, but the catalog is defined in a production called Relativity, by Liant (Cobol 6.60), and is directed at a set of ISAM files on a Unix Platform running AIX 4.2. This allows the files to be accessed using SQL statements. A simple Select statements fails on the table, but works on others.

I would appreciate any help on this.


Just wanted to post an update, since I am unable to delete the initial posting.