I am setting up ODBC access to our IBM UniVerse (U2) database. I am able to select the none multi-value fields without issue. I am not able to see the multi-value fields or the view that they should create. I have run HS.SCRUB on the file - any tips or hints would be great! Thanks!

Multivalued fields need to be set up in "exploded" tables. Meaning in the ODBC account you need to setup new files to point to the multivalued fields that will group them into a new related table.

Example:
You store order numbers in a mv field in your customer table. In the odbc account you need to create a new table that will contain customer # and Order #.

Hope this helps,

John