Articles & Content
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
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
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!Click to Download
NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.