Choosing Physical Tuning Options › Non-SQL Tuning Options › Database Procedures

Database Procedures

Database procedures are special-purpose subroutines designed to perform predefined programming functions such as data compression and decompression. You write and compile these procedures as subroutines that are executed at application runtime when a program accesses an area or entity. Database procedures have access to the entire data portion of the entity occurrence.

The time a procedure is to be called is specified in the schema. At runtime, these procedures are called automatically; the call is transparent to the application program.

Common uses

Database procedures are typically used to perform the following functions:

• Compression and decompression
• Data validation
• Privacy and security
• Data collection
• Determination of record length for variable-length native VSAM records

For complete information on coding and using database procedures, see CA IDMS Database Administration Guide.