The CREATE FUNCTION StatementFunction Name and ParametersReturns Function OutputSpecific NameLanguage SQLDETERMINISTIC or NOT DETERMINISTICEXTERNAL ACTION or NO EXTERNAL ACTIONCONTAINS SQL, READS SQL DATA, MODIFIES SQL DATASTATIC DISPATCHCALLED ON NULL INPUTINHERIT SPECIAL REGISTERS (LUW and iSeries Only)PREDICATES (LUW only)SQL Function BodyUser-Defined Functions by ExamplesA Simple Scalar UDF ExampleA Complex Scalar UDF ExampleA Table UDF Example (LUW and iSeries)Invoking SQL Procedures in UDFs (LUW and iSeries Only)The CREATE TRIGGER StatementTrigger NameBEFORE, AFTER, or INSTEAD OFINSERT, DELETE, or UPDATEREFERENCING ClausesFOR EACH ROW or FOR EACH STATEMENTMODE DB2SQLTriggered ActionTriggers by ExamplesA BEFORE Trigger ExampleAn AFTER Trigger ExampleA Complex AFTER Trigger ExampleAn INSTEAD OF Trigger Example (for LUW Only)A Comparison of View Triggers and Table Triggers (LUW only)Invoking UDFs and SQL Procedures from TriggersConsiderations for Invoking SQL Procedures from UDFs and TriggersData Access RestrictionsTransaction Control in SQL ProceduresTable Read or Write Conflict in SQL Procedures on LUWDB2 for iSeries ConsiderationsDB2 for zSeries ConsiderationsThe CREATE FUNCTION StatementTrigger ConsiderationsInvoking UDFs and SQL Procedures from TriggersNesting SQL StatementsSummary