Starting in V10.1 you can declare user-defined data types and procedures that are local to a compound SQL (compiled) statement
Information about declared data types and procedures is not stored in the DB2® catalog. Data types can be used and procedures invoked only in the compound SQL (compiled) statements where they are declared or in nested compound SQL (compiled) statements.