Sample COBOL Procedure › Sample Procedure Definition

Sample Procedure Definition

The following example shows an SQL-invoked procedure definition.

create procedure demoempl.get_bonus
 ( emp_id          unsigned numeric(4)        with default,
   bonus           unsigned numeric(10)       with default,
   currency_bonus char (3)                    with default )
 external name getbonus
 protocol idms;