Articles & Content

Archives

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

Topic: Cross Platform DB2 for z/OS & LUW

Subtopic: 2006



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.



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.