InfoSphere Optim

 View Only

  • 1.  Insert service into a table without primary key

    Posted Wed April 26, 2023 06:39 PM

    Hi all,

    Im using optim designer and Im tryng to excecute a insert service into a table without primary key,

    The insert service is updating the data so i have this issue:


    Is there a way to execute the insert or the only way is to create the primary key in the db? 



    ------------------------------
    Anthony García
    ------------------------------


  • 2.  RE: Insert service into a table without primary key

    IBM Champion
    Posted Wed April 26, 2023 06:41 PM

    Anthony,

    Please look at creating an Optim Primary Key for the table in question.  This doesn't reside in the database and it is not enforced at the database level.  It is only for Optim to use.

    Jimmy



    ------------------------------
    Jimmy Wilson
    ------------------------------

    Original Message


  • 3.  RE: Insert service into a table without primary key

    Posted Thu April 27, 2023 05:08 PM

    Can you create a PK in optim designer. Not necessary into db.



    ------------------------------
    Waldo Reinaud
    ------------------------------

    Original Message


  • 4.  RE: Insert service into a table without primary key

    IBM Champion
    Posted Thu April 27, 2023 05:10 PM
    Yes.  In the Directory Explorer of Designer, there is a topic for Optim Primary Keys.  Create a new PK and it is not stored in the database but only enforced within Optim.

    --

    Jimmy Wilson


    1999 S. Bascom Ste 700

    Campbell, CA 95008

    Phone +1(972) 567-5558

    jwilson@abmartin.com

     

    Unstructured Data Masking

    Data Privacy/Test data Management - fabrication, optimization, obfuscation




    Original Message