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 30 days ago
    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 30 days ago
    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 30 days ago
    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 25 days ago
    Thank you Cihan. It's working.