Articles & Content

Archives

Parlez-Vous Klingon? Recursion SQL for Generating Test Data (F15)

Topic: 2008 EU

Subtopic: Cross Platform DB2 for z/OS & LUW



DATE: 2008-10-16 (10:30 - 11:30)
SPEAKERS: Alexander Kopac (DBI)

Recursive SQL now runs on most DB2 versions. Often when the words 'recursive query' are heard, application developers/DBA's may hear a 'klingon' or guttural groan. Here's a step-by-step explaination of SQL "recursive queries" to quickly generate DB2 test data. See how recursive Stored Procedures /CLP scripts generates/refreshes DB2 data without a programmer to compile a C/COBOL/Java pgms. Parts 1-3 explain "recursive queries" in simple terms and give lots of examples to take back to the office. In your near-future work life, you may 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". Part 4 shows masking data techniques and helps you become a 'Master of Data Disguise' for both distributed & mainframe. Commitment issues & recursion techniques between other relational databases will be discussed.

EXP. LEVEL: Beginner,Intermediate

OBJECTIVES:

Learn how to create simple SQL recursive queries replacing hundreds of lines of SQL code

SQL recursive queries for overall performance and database efficiency

Learn how to quickly create ‘safe’ test data in order to meet auditing and compliance requirements

Learnwhy data type selection in SQL is important for overall performance anddatabase efficiency; various physical design techniques for improvingdatabase performance and efficiency are discussed

Live Demonstation



This file is being provided by IDUG. We would encourage you to join IDUG to get full access to all of our files and resources. Joining IDUG is FREE and signing up is simple. Click here to join! or login!

Download File
Click to Download

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