Issue XII
Our Virtual Latin America Seminars Kick Off Today!
Register for the IDUG Brazil Seminar kicking off today, or the IDUG Mexico Seminar starting this Thursday. These are great opportunities to hear from Db2 experts and gain technical knowledge. An IBM complimentary certification or badging voucher worth $200 is available with each registration.
2020 IDUG EMEA Virtual Conference Highlights!
Last month more than 750 people joined us for the 2020 IDUG Virtual EMEA Db2 Tech Conference. If you missed the event, you can still unlock all of the incredible technical sessions for on-demand viewing by registering. Read more in our latest blog.
Access the full conference agenda on demand.
Be a Speaker at the IDUG Australasia Conference
IDUG is accepting abstracts for our virtual Australasia event which will be held March 15–19, 2021. This is a great chance to share your expertise with the global IDUG community without having to leave your home or office.
SQL Tricks - Part 3 Using ROW_NUMBER to Assist in Deleting Duplicates
By Tony Andrews
Often times we have all seen duplicate rows in table data that occurred thru some incorrect SQL or program logic. In this example the timestamp column makes up part of the composite key along with the employee number. So how do we delete the duplicates?

  • Write a program and order the data through a cursor by primary key and execute deletes?
  • Write a single SQL statement to fix the problem?
This year, IDUG has hosted some incredible virtual events, including our marquee North America and EMEA Conferences. Attendees can still access the recordings via our Presentation Archive. If you didn't attend the events, you can still register to unlock the content. Register for NA 2020 | Register for EMEA 2020
Look out in the year ahead for IDUG Conferences in Australia, India, Scotland, Mexico, Brazil, and more. Join the IDUG LinkedIn Group so you don't miss a thing!
December 8–9, 2020
December 10, 2020
March 15–19, 2021
Coming soon
Featured Presentation
Db2 Time Travel in the Data Warehouse World - Challenges and Solutions
by Michael Tiefenbacher
Data Warehouses store historical data and Db2 Temporal Tables offer time travel queries to dig the gems. Sounds like a perfect match? Db2 Temporal Tables have been developed for operational systems and applying them to the Data Warehouse environment will provide some challenges you might have not expected. This presentation explains details as well as the challenges and shows possible solutions for a successful Data Warehouse implementation with Db2 and Db2 BLU.
For more exclusive content like this, sign up for a premium membership.
President's Letter
This month, IDUG President Bob Vargo considers how the challenges of 2020 have made us stronger as we look toward 2021 and beyond.
Upcoming Webcasts & Community Events
December 9, 2020
Novi, Michigan
December 10, 2020
Helsinki, Finland
Enhance your Db2 for z/OS skills this summer! Check out all webcasts replays for Db2 for z/OS 2020 and increase your skills. Get ready for Db2 12 for z/OS certification test.
Stay Connected