Built-in routines and views

Built-in administrative routines and views provide a simplified programmatic interface to administer and use DB2® databases and database objects through structured query language (SQL).

Built-in routines encompass procedures, scalar functions, and table functions.

You can run these built-in routines and views from an SQL-based application, a DB2 command line, or a command script.

Character and graphic strings that are used as parameters of routines or returned from the routines or views are always in OCTETS even when the environment is set to CODEUNITS32.