Both are DB2 code.
Stored procedures are created and stored in SYSPROC catalogue table. These are static and whenever user wants they can call in th program.
How to call stored procedures? Syntax is as follows:
SAMPLE is stored procedure name.
Triggers are dynamic. When particular situation happens to the data due to program logic, Triggers will execute dynamically (automatically).
Just read on I will give more details in my next posts……