Articles & Content

Archives

Developing Cross Platform SQL Routines - Do's and Don'ts (F06)

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

OBJECTIVES:

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!

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.