Centerfield's SQL UDFs extend DB2 for i5/OS by providing a set of useful SQL functions. These functions can be installed in a matter of minutes and immediately simplify complex SQL accessing tables or legacy DDS files.

• Simple
  The SQL UDFs utility allows the system operator to easily install the tool and use them right away. UDFs (User Defined Functions) work just like the built in functions your already use (substring(), date(), etc.)
  
  
• Commonly used functions from other databases
  Many functions are popular on other database which makes it easier for developers familiar with those databases to adapt to the iSeries.
  
  
• Documented
  Each SQL UDF is Documented, on the centerfieldtools.com website, making each function easy to learn and simpler to use!
  
  
• Submit New Functions
  With SQL UDF, users can drive our new function releases. By using our Submit Function Form or UDF Voting, you can let us know what new functions you'd like to see implemented in future releases.
  
  
• Examples of UDFs
  
  • Date functions
    
    • cvtdat
      Returns an SQL date given a date value in character form.
      
      
    • dateDiff
      Calculates the difference between two datetime values in the given units.
      
      
    • datePart
      Returns the given part of a DATE, TIME, or TIMESTAMP value.
      
      
  • String functions
    
    • charindex
      Returns index of the first occurrence of a substring in a targetString.
      
      
    • initCap
      Returns a string with the first letter of each word capitalized and all other letters are lowercase.
      
      
    • rpad
      Returns the inputString, right-padded with the padString.
      
      
  • System i functions
    
    • usersSignedOn
      Returns an integer containing the number of users currently signed on to the system.
      
      
    • activeJobsInSystem
      Returns an integer containing the number of active jobs on the system.
      
      
    • processUnitUsed
      Returns a decimal value containing the percentage of the processor that is currently being used on the system.