Centerfield’s User Defined Functions (UDFs) supplement built-in SQL functions and make it simpler to write applications and reports. These functions work with legacy iSeries date and time types, provide more convenient string-handling, and allow straight-forward access to system information. Because most of these UDFs are based on widely used but non-standard functions, they allow IT shops to leverage personnel familiar with other databases like Oracle, SQL Server, and MySQL.
For a limited time you can get Centerfield’s SQL UDFs for free with the purchase of software maintenance (users will get new functions for free as they are added). Download and try them now free for 90 days.
» More information
Centerfield Technology, Inc. provides a wide range of software products and services for IBM's System i that optimize SQL and DB2 performance, provide real-time diagnostic tools for IT, and help control end-user access to an organization's business critical information.