DB2-Stored procedures & Triggers

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.

Exec SQL

CALL SAMPLE

END-EXEC.

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……

Advertisements

Author: Srini

Experienced software developer. Skills in Development, Coding, Testing and Debugging. Good Data analytic skills (Data Warehousing and BI). Also skills in Mainframe.