Built-in routine implementation

Built-in routines are built into the code of the database manager. These routines are strongly typed and perform well because their logic is native to the database code.

These routines are found in the SYSIBM schema. Some examples of built-in scalar and aggregate functions include:
  • Built-in scalar functions: +, -, *, /, substr, concat, length, char, decimal, days
  • Built-in aggregate functions: avg, count, min, max, stdev, sum, variance

Built-in functions comprise most of the commonly required casting, string manipulation, and arithmetic functionality. You can immediately use these functions in your SQL statements. For a complete list of available built-in functions, see the SQL Reference.