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:
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. |
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.
|