Articles & Content

Archives

F11 - PARLEZ-VOUS KLINGON - DB2 RECURSION SQL FOR DATABASE MAGICIANS

Topic: 2014 EMEA

Subtopic: Cross Platform DB2 for z/OS & LUW



Often when the words 'recursive query' are spoken, a shiver of fear runs down the spines of application developers and DBAs. Fear not! In your near-future work life, you may also hear “Data Disguise Required” meaning that “use of data derived from relationships for purposes of testing, research, training, or publication will be confined to content that is disguised to ensure the anonymity of the individuals involved”. This session provides an easy, step by step, explanation of SQL “recursive queries” that can be used to spin thru tables.views and to quickly generate test data. Learn how recursive queries can be used to generate and refresh data without the need to write and compile C, COBOL, or Java programs. We begin by explaining “recursive queries” in simple terms and give lots of examples to use in your office, and then the session progresses to showing data masking techniques and to help you become a “Master of Data Disguise”.



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.