Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2004
    Posts
    1

    Unanswered: IBM UniVerse ODBC access

    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!

  2. #2
    Join Date
    Feb 2004
    Location
    Pittsburgh, PA
    Posts
    41

    ODBC Access to mv fields in UniVerse

    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •