Articles & Content


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

Topic: Cross Platform DB2 for z/OS & LUW

Subtopic: 2008

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

Live Demonstation

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.