written entirely in SQL PL, compiled by DB2 into a package. No COBOL involved. 2. **External stored procedures** — written in a host language (COBOL, PL/I, C, Java), compiled by the language compiler, and called by DB2 at runtime.