SYSCAT.FUNCMAPPARMOPTIONS catalog view

Each row represents a function mapping parameter option value.

Table 1. SYSCAT.FUNCMAPPARMOPTIONS Catalog View
Column Name Data Type Nullable Description
FUNCTION_MAPPING VARCHAR (128)   Name of the function mapping.
ORDINAL SMALLINT   Position of the parameter.
LOCATION CHAR (1)   Location of the parameter.
  • L = Local parameter
  • R = Remote parameter
OPTION VARCHAR (128)   Name of the function mapping parameter option.
SETTING VARCHAR (2048)   Value of the function mapping parameter option.