Articles & Content

Archives

E04 - A Tricky Conversion with Just (Advanced?) SQL

Topic: Cross Platform DB2 for z/OS & LUW

Subtopic: 2015



Converting from a heavy RI'd DB to a more managable DB with some interesting changes in the data. The hardest parts took several days of thinking, trying and using colleagues to figure out how to do it. Learned to use CTEs and had to use some XML - no animals were hurt during this excercise and no Cobol was needed. Just SQL.



Click Here to Download

NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.