DB2 Create Function

The DB2 Create Function Tool allows users to create stored Functions for a database. The following example is output for DB2.

CREATE FUNCTION TESTUSER.test_function (param1 CHAR(25), param2 DATE, param3 DECIMAL) RETURNS INTEGER LANGUAGE SQL MODIFIES SQL DATA --READS SQL DATA --CONTAINS SQL --insert function body here

DB2 Create Function