Db2

 View Only

column specification

  • 1.  column specification

    Posted Fri August 26, 2022 12:00 PM
    I have a table with a column :
    "T_MODIFIED_ON" TIMESTAMP NOT NULL GENERATED ALWAYS FOR EACH ROW ON UPDATE AS ROW CHANGE TIMESTAMP
    I did a select of all columns in sysibm.syscolumns and syscat.columns, but the information "for each row...." is not present. do you know where this is kept ? maybe in the tabledescriptor ?
    the column text keeps the setting in case of always as...


    ------------------------------
    Thanks for all answers
    Best Regards,
    Guy Przytula
    ------------------------------

    #Db2