Writing Database Procedures › Coding Database Procedures › Specifying When to Call Database Procedures

Specifying When to Call Database Procedures

Using CALL

To specify when a database procedure is to be called at runtime, you use the CALL statement in the schema DDL for areas and records. You can use database procedures with any number of DML commands for any number of areas or records. For example, to compress/decompress JOB records with the CA IDMS/DB-supplied procedures, specify the following CALL statements for the JOB record type:

call idmscomp before store.

call idmscomp before modify.

call idmsdcom after get.

Note: If the schema contains any records for which IDMSCOMP or IDMSDCOM is called, IDMSDCOMP and IDMSDCOM must be called as area procedures 'BEFORE FINISH' and 'BEFORE ROLLBACK' to release the storage used for internal compression/decompression work areas.