Test Data Manager

Expand all | Collapse all

DB2 Data Generation - functions for Generated Always columns

Jump to Best Answer
  • 1.  DB2 Data Generation - functions for Generated Always columns

    Posted 07-18-2019 10:10 AM
    Hi,

    Which function should i use for a GENERATED ALWAYS column on a DB2 database?

    For example,
    for an id column, i can use ~NEXT~ function without GENERATED ALWAYS rule. But i cannot use the same rule when its GENERATED ALWAYS. I'm getting error when i publish it.

    Is there any function to use for this or how can i pass over this error?

    Do you have any suggestions on this?

    Thank you.


  • 2.  RE: DB2 Data Generation - functions for Generated Always columns
    Best Answer

    Posted 07-19-2019 10:59 AM
    Have you tried publishing the other fields and ignoring the ID column?
    The DB2 should generate the ID value when a row is inserted via TDM


  • 3.  RE: DB2 Data Generation - functions for Generated Always columns

    Posted 07-19-2019 03:52 PM
    Hi Navin,

    Thank you for your answer. How can i ignore columns from publish?

    Regards.


  • 4.  RE: DB2 Data Generation - functions for Generated Always columns

    Posted 07-20-2019 01:46 AM
    Hi,

    You can ignore columns on Actions for registered Objects->Maintain Table.

    Best,


    ------------------------------
    Managing Consultant
    GUNITTECH
    ------------------------------



  • 5.  RE: DB2 Data Generation - functions for Generated Always columns

    Posted 07-24-2019 04:21 AM
    Thank you Cihan. It's working.