DB2 Performance DB2Advis command an idiots Guide
JOIN Conditions with Unicode and ASCII I cannot stress the dangers of copying data from Excel or HTML and assuming that it’s ASCII. For example U+0040 is the unicode version of @. We ingested the unicode version and couldn’t see why a JOIN condition on the data table wasn’t working. I looked at the source […]
How to remove CTRL-M (^M) characters from a file in Linux Removing the ^M character in VIM / VI :%s/^M//g Coalesce When you have an unexpected bad data coalesce it. IF NULL, THEN the alternative in COALESCE
I had dupe data in my OLAP table, where the columnar data can be duplicated based on event id. (I loaded data 2x). I had to differentiate the data and remove the duplicates, so I assigned row_numbers over a partition ordered by. I hope this helps you. db2 “update (select OME.*, row_number() over(partition by IDN_EVENT_ID […]
I lost my changelog tables and the lock table for Liquibase I was able to Dump Change Log in Liquibase, and then load the resulting inserts into the changelog.