Db2

Db2

Where DBAs and data experts come together to stop operating and start innovating. Connect, share, and shape the AI era with us.


#Data


#Data
#Databases
#Operatingsystems
#Db2
#Databasesolutions
 View Only

  • 1.  column specification

    Posted 08/26/22 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


Related Content