InfoSphere Optim

 View Only
  • 1.  Creation of Primary Keys not detecting while conversion

    Posted Sun November 27, 2022 09:12 PM
    Hello All -

    I have created optim primary key and relationship between tables. I have created ADS based on the relation and extracted data from both the tables in Optim Z/OS 11.7, however when I try to propagate employee id and apply conversion using prop(SEQ('32324322',1)) I see below error

    Reported FK/PK errors may be caused by other types of errors
    Set :1 No related tables  (Column Map Specification)
    Set:2 Not a FK/PK, missing rel (Column Map Specification)

    appreciate if you can respond to this thread.


    ------------------------------
    Sampath Gelli
    ------------------------------

    #InfoSphereOptim
    #Optim


  • 2.  RE: Creation of Primary Keys not detecting while conversion

    Posted Mon November 28, 2022 03:14 PM
    Your issue could be related to not using a numeric value for your SEQuence. The quotes around the number make it alphanumeric when it should be an integer. 

    Try this: PROP(SEQ(32324322, 1))

    Hope this helps....





    ------------------------------
    Keith Tidball
    Progressive Insurance
    ------------------------------



  • 3.  RE: Creation of Primary Keys not detecting while conversion

    Posted Mon November 28, 2022 03:29 PM
    Edited by System 9 days ago
    That's a good suggestion! But I think Optim did not get to PROP(SEQ,...)) validation at all. My suspicion is that it stumbled upon another error, first.
    The most likely offender would be "No related tables".

    To determine if this is the case, one can perform the BROWSE of the EXTRACT file (7.B) of the table whose column is being propagated. The browse panel will highlight the table key, if there is one. If there is none, that would be possibly a problem.
    Then, one can enter the JOIN command and see if Optim finds any tables available for joining, based on the presence of relationships. If JOIN does not find any tables to join (in the EXTRACT file) then this is the actual problem which indicates that there are no relationships defined for the table with the PROP column.

    ------------------------------
    Greg Czaja
    Optim for z/OS Developer
    ------------------------------



  • 4.  RE: Creation of Primary Keys not detecting while conversion

    Posted Tue November 29, 2022 09:47 PM
    Thanks Greg. How can I create a PK/FK relation. I have created a relation between tables and when I check the same in Create Promary Key they are aleady there. is there any way to create a FK explicitly?

    ------------------------------
    Sampath Gelli
    ------------------------------



  • 5.  RE: Creation of Primary Keys not detecting while conversion

    Posted Wed November 30, 2022 11:56 AM
    You may want to consult Optim for z/OS manuals at https://www.ibm.com/docs/en/iotdmfz/11.7.

    I would start with using the DB2 table BROWSE function and verify that a JOIN command is able to relate any table(s) for which you want to use the value propagation.

    ------------------------------
    Greg Czaja
    Optim for z/OS Developer
    ------------------------------