Return to the SQL Tips
Sample UDFs for Migration
Ready to port your app from Oracle or Sybase to DB2? This handy set of SQL UDFs can help make that move a little bit easier by providing the same or similar functionality in DB2 for certain functions available in Oracle or Sybase. These sample files work to help analyze information gathered from snapshot monitoring sample code files.
Many of the UDFs have been rewritten for DB2 UDB V8 by using SQL CONTROL statements. You'll see over 30 functions including ADD_MONTHS, BITAND, FORMAT, GREATEST, and many more. These samples are useful in learning design and coding techniques for DB2 SQL.
http://www.ibm.com/developerworks/data/library/samples/db2/0205udfs/index.html
[report a broken link by clicking here]