The field procedure parameter value list (FPPVL)

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

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

The following tables describe the FPPVL:

Table 1. sqlfpFieldProcedureParameterList_T
Name Offset Data Type Description
sqlfpOptParmValueListLength 0 4-byte integer Length in bytes of this structure
sqlfpNumberOfOptionalParms 4 4-byte integer Number of value descriptors that follow. Equal to the number of parameters in the FIELDPROC clause. Zero if no parameters were listed.
sqlfpParmList 8 structure sqlfpOptionalParameterValueDescriptor_T A list containing sqlfpNumberOfOptionalParms count of sqlfpOptionalParameterValueDescriptor_T items.
Table 2. sqlfpOptionalParameterValueDescriptor_T
Name Offset Data Type Description
sqlfpOptDescLength 0 4-byte integer Length in bytes of this structure
sqlfpParmDesc 4 structure sqlfpParameterDescription_T Parameter description
reserved2 38 character(12) Not used
sqlfpParmData 40   The optional parameter data value.
  • If the value is a varying-length string, the first 2 bytes contains its length.
  • If the value is a LOB or XML string, the first 4 bytes contains its length.
  • If this value is numeric, the internal numeric representation of the data.
  • If a datetime value, the value is in *ISO format.