Articles & Content
Topic: 2006 EU
Subtopic: Cross Platform DB2 for z/OS & LUW
DATE: 2006-10-3 (14:00 - 15:00)
SPEAKERS: Sathyaram Sannasi (KAM Technology Ltd)
The powerful SQL PL language is used to store the business logic in the db2 catalog, the heart of the database in the form of triggers, UDFs and Stored Procedures, collectively known as routines. With the cross-platform programming languages and applications increasing in popularity, it is no surprise that db2's routines are also expected to be cross-platform compliant. This presentation highlights the similarities and differences between SQL PL on DB2 ZOS, DB2 LUW and DB2 iseries and explains best practices and work-arounds/techniques for developing cross platform routines. The discussion is based on real life experience of rewriting routines developed for DB2 LUW to be compliant on DB2 zOS.
EXP. LEVEL: Beginner,Intermediate,Advanced
Compare and Contrast CREATE PROCEDURE Statement Options
Compare and Contract SQL PL language features in the Stored Procedure body
User Defined Functions and Triggers feature comparison between the two platforms
Do's and Don't of the above SQL PL features to ensure cross-platform compatabiltiy
Examples of cross-platform compatible code. Tips and tricks to 'simulate' non-supported features.
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.