Ever want to update your modification timestamp field any time an update is made to the row without having to add application logic? Well, DB2 makes it relatively painless…<\/p>\n\n\n\n

alter table XX.MY_TABLE add column last_updated_ts timestamp not null\ngenerated by default for each row on update as row change timestamp<\/code><\/pre>\n\n\n\n
Check out these resources for additional information…<\/p>\n\n\n\n
https:\/\/www.ibm.com\/support\/knowledgecenter\/SSEPGG_11.1.0\/com.ibm.db2.luw.admin.dbobj.doc\/doc\/c0051498.html<\/li>
https:\/\/www.ibm.com\/support\/knowledgecenter\/SSEPGG_11.1.0\/com.ibm.db2.luw.sql.ref.doc\/doc\/r0000888.html<\/li><\/ul>\nPlease remember to subscribe to the newsletter<\/a> to stay up to date!<\/i>\n\nYou or someone you know looking to buy or sell?<\/i>\n<\/a>\nDisclaimer: Thoughts and opinions are my own, and do not reflect the views of any employer, family member, friend, or anyone else. Some links may be affiliate links, but I don't link to anything I don't use myself. You would think this should be self evident these days, but apparently not...<\/small><\/i>","protected":false},"excerpt":{"rendered":"
Ever want to update your modification timestamp field any time an update is made to the row without having to add application logic? Well, DB2 makes it relatively painless… Check out these resources for additional information… https:\/\/www.ibm.com\/support\/knowledgecenter\/SSEPGG_11.1.0\/com.ibm.db2.luw.admin.dbobj.doc\/doc\/c0051498.html https:\/\/www.ibm.com\/support\/knowledgecenter\/SSEPGG_11.1.0\/com.ibm.db2.luw.sql.ref.doc\/doc\/r0000888.html Please remember to subscribe to the newsletter to stay up to date! You or someone you know … Continue reading Update modification timestamp on DB2 table automatically<\/span> →<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"footnotes":"","_jetpack_memberships_contains_paid_content":false,"jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","enabled":false},"version":2}},"categories":[3],"tags":[22],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/p2UXeD-w2","jetpack_sharing_enabled":true,"jetpack-related-posts":[],"jetpack_likes_enabled":false,"_links":{"self":[{"href":"https:\/\/markjacobsen.net\/wp-json\/wp\/v2\/posts\/1986"}],"collection":[{"href":"https:\/\/markjacobsen.net\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/markjacobsen.net\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/markjacobsen.net\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/markjacobsen.net\/wp-json\/wp\/v2\/comments?post=1986"}],"version-history":[{"count":1,"href":"https:\/\/markjacobsen.net\/wp-json\/wp\/v2\/posts\/1986\/revisions"}],"predecessor-version":[{"id":1987,"href":"https:\/\/markjacobsen.net\/wp-json\/wp\/v2\/posts\/1986\/revisions\/1987"}],"wp:attachment":[{"href":"https:\/\/markjacobsen.net\/wp-json\/wp\/v2\/media?parent=1986"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/markjacobsen.net\/wp-json\/wp\/v2\/categories?post=1986"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/markjacobsen.net\/wp-json\/wp\/v2\/tags?post=1986"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}