Locate reusable pieces of SQL code into the IFS. Then, use INCLUDE to pull those segments into your SQL routines or triggers, and even ACS's Run SQL Scripts or RUNSQLSTM.

Reuseable SQL code segments with INCLUDE

--
-- Use INCLUDE (SQL) to maintain reusable code segments.
-- and incorporate in scripts or SQL Procedures, Functions, and Triggers
-- Reference: http://ibm.biz/DB2fori_INCLUDE
--

--
-- description: Use the INCLUDE statement to pull
--              in and execute common pieces 
--              of SQL
--
begin
include sql '/home/SCOTTF/create objects.sql';
include sql '/home/SCOTTF/insert data.sql';
end;