Exit routines

DB2® provides installation-wide exit points to the routines that you provide.

Edit procedures
An edit procedure is assigned to a table by the EDITPROC clause of the CREATE TABLE statement. An edit procedure receives the entire row of a base table in internal DB2 format. It can transform the row when it is stored by an INSERT or UPDATE SQL statement or by the LOAD utility.
Validation routines
Validation routines are assigned to a table by the VALIDPROC clause of the CREATE TABLE and ALTER TABLE statement. A validation routine receives an entire row of a base table as input. The routine can return an indication of whether to allow a subsequent INSERT, UPDATE, DELETE, FETCH, or SELECT operation.
Date and time routines
A date routine is a user-written exit routine to change date values from a locally defined format to a format that is recognized by DB2 and from the ISO format to the locally defined format. Similarly, a time routine changes time values from a locally defined format to one that is recognized by DB2and from the ISO format to the locally-defined format.
Conversion procedures
A conversion procedure is a user-written exit routine that converts characters from one coded character set to another coded character set.
Field procedures
A field procedure is a user-written exit routine that is used to transform values in a single, short string column. You can assign field procedures to a table by specifying the FIELDPROC clause of the CREATE TABLE or ALTER TABLE statement.
Log capture routines
A log capture exit routine makes DB2 log data available for recovery purposes in real time.
Routines for dynamic plan selection in CICS
You can create application packages and plans that allow application programs to access DB2 data at execution time. In a CICS® environment, you can design CICS transactions around the application packages and plans or use dynamic plan allocation.
General guidelines for writing exit routines
When you use the exit routines that DB2 supplies, consider some of the general rules, requirements, and guidelines for using exit routines.
Row formats for edit and validation routines
In writing an edit or validation routine, you must be aware of the format in which DB2 stores the rows of tables.

Related information

Managing access through exit routines