Parameter value list (FPPVL) for field procedures

The field procedure parameter value list communicates the literal list to the field procedure during the field-definition process. The literal list is supplied in the CREATE TABLE or ALTER TABLE statement.

Begin program-specific programming interface information.

At that time, the field procedure can reformat the FPPVL; it is the reformatted FPPVL that is stored in SYSIBM.SYSFIELDS and communicated to the field procedure during field-encoding and field-decoding as the modified FPPVL.

The FPPVL has the following formats:

Table 1. Format of FPPVL, defined in copy macro DSNDFPPB
Name Hex offset Data type Description
FPPVLEN 0 Signed 2-byte integer Length in bytes of the area containing FPPVCNT and FPPVVDS. At least 254 for field-definition.
FPPVCNT 2 Signed 2-byte integer Number of value descriptors that follow, equal to the number of parameters in the FIELDPROC clause. Zero if no parameters were listed.
FPPVVDS 4 Structure Each parameter in the FIELDPROC clause has:
  1. A signed 4-byte integer giving the length of the following value descriptor, which includes the lengths of FPVDTYPE, FPVDVLEN, and FPVDVALE.
  2. A value descriptor
End program-specific programming interface information.