InfoSphere Optim

 View Only
Expand all | Collapse all

Primary Key Creation - Legacy Tables ( VSAM)

  • 1.  Primary Key Creation - Legacy Tables ( VSAM)

    Posted Wed December 04, 2019 08:40 AM
    Hello ,

    We are using Optim V11.7.0  Z/OS version and trying to create a legacy table ( VSAM file) with multiple copybooks . As part of this , I'm trying to create the primary keys for the legacy table. Optim is not detecting the legacy tables in the primary key option (6.1).  However , these legacy tables are getting detected when I try to create a relationship between these tables.  Need your expertise in finding out the resolution here.

    ------------------------------
    Hari
    ------------------------------

    #InfoSphereOptim
    #Optim


  • 2.  RE: Primary Key Creation - Legacy Tables ( VSAM)

    Posted Thu December 05, 2019 10:13 AM
    Hi Hari,

            When you go into 'Primary Keys' option, and give creator id and table name (for which you want to create primary key) and hit enter, you will see option to create Primary Key. Once you create it and then try fetching list in 'Primary Keys' option using wild card, it will list your newly created table as you just created primary key on new legacy table. Hope this helps.

    Thanks,
    Vamsi

    ------------------------------
    Venkata Vamsi Krishna Thalluri
    ------------------------------