Incomplete rows and edit routines

DB2® passes input rows to an edit routine. If an input row has fewer fields than the number of columns in the table, the edit routine must stop processing the row after the last input field.

Begin program-specific programming interface information.

Columns for which no input field is provided and that are not in reordered row format are always at the end of the row and are never defined as NOT NULL. In this case, the columns allow nulls, they are defined as NOT NULL WITH DEFAULT, or the columns are ROWID or DOCID columns.

Use macro DSNDEDIT to get the starting address and row length for edit exits. Add the row length to the starting address to get the first invalid address beyond the end of the input buffer; your routine must not process any address as large as that.

The following diagram shows how the parameter list points to other row information. The address of the nth column description is given by: RFMTAFLD + (n-1)*(FFMTE-FFMT).
Figure 1. How the edit exit parameter list points to row information
Begin figure description. The edit exit parameter list points to row information. End figure description
End program-specific programming interface information.