Case Study: Using SQL to Overcome Challenges When Consuming XML - Vern Hamberg

Recorded On: 07/30/2020

In this new world of mobile data collection by our field specialists, we ran head-on into special characters as well as emojis. This case study tells the tale of overcoming the hurdles we were stumbling over to deal with them. Learning objectives:

1. Learn what issues can be raised when using mobile devices to collect information from the field

2. Learn how XML support in Db2 for i was used to resolve these issues

Vern Hamberg

Senior IT Developer, Ecolab

Vern has worked on IBM midrange systems for over 30 years, beginning with the System/38 and AS/400. At present he is a Senior Software Engineer for the Pest Elimination division at Ecolab. He also serves on the COMMON Americas Advisory Council (CAAC) and SET and is one of the SMEs for Db2. He is degreed in both music and mathematics, which gives him a distinct approach to the art and science of programming. In his spare time he has participated in various musical pursuits, such as playing trumpet in a community band, singing in a pretty-good a capella choral group, working with local musical theater productions, and most recently playing keyboard in the Zuhrah Shrine Flames big band and accordion in a weekly jazz workshop - quite a stretch!