IBM Optim

IBM Optim

Enable Data Operations with Optim for AI and Cloud - accelerating innovation, reducing costs, ensuring data sovereignty


#Dataintegration
#Databases
#InfoSphereOptim
#Analyticstools
 View Only

  • 1.  Creation of Primary Keys not detecting while conversion

    Posted 11/27/22 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 11/28/22 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 11/28/22 03:29 PM
    Edited by System Admin 01/20/23 04:19 PM
    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
    ------------------------------

    Original Message


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

    Posted 11/29/22 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
    ------------------------------

    Original Message


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

    Posted 11/30/22 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
    ------------------------------

    Original Message


Related Content