Results 1 to 4 of 4
  1. #1
    Join Date
    Sep 2004
    Posts
    1

    Unanswered: Modelling table realations of a database (z/OS)

    Hi,

    is there a product, that can model the relations between tables in a database? I would see the relations of a particular table visualised in a GUI on a workstation. The DBMS (DB2) is running on a mainframe.

    I don't know, whether the product just exists, but maybe you can tell me that?

    Thanks,
    Sven

  2. #2
    Join Date
    Jan 2004
    Location
    Europe, Finland, Helsinki
    Posts
    64
    Hi!

    We use a product, named ErWIN - it is from the CA's product bag. You need to have proper connection, ODBC or otherwise - but no other worries, ErWIN understand DB2 z/OS syntax.

    Probably there are many others, but I don't remember any.

    Cheers, Bill

  3. #3
    Join Date
    Feb 2002
    Location
    Philippines
    Posts
    41
    Quote Originally Posted by hurmavi
    Hi!

    We use a product, named ErWIN - it is from the CA's product bag. You need to have proper connection, ODBC or otherwise - but no other worries, ErWIN understand DB2 z/OS syntax.

    Probably there are many others, but I don't remember any.

    Cheers, Bill
    yup... CA's Allfusion ERwin is a very good product

    i'm not sure if IBM's Rational Rose has this feature and supports z/OS
    There are 10 kinds of people,
    those who know binary and those who don't.

    http://www.linkedin.com/in/rtitong

  4. #4
    Join Date
    Jun 2003
    Posts
    16

    Thumbs up

    You can use Sybase's PowerDesigner 10.0..its a real good modelling tool. You just need to point to the database in question and the model will be displayed for your use.

    Cheers,

Posting Permissions

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