DB2 Version 9.7 for Linux, UNIX, and Windows

SYSCAT.FUNCMAPPINGS catalog view

Each row represents a function mapping.

Table 1. SYSCAT.FUNCMAPPINGS Catalog View
Column Name Data Type Nullable Description
FUNCTION_MAPPING VARCHAR (128)   Name of the function mapping (might be system-generated).
FUNCSCHEMA VARCHAR (128) Y Schema name of the function. If the null value, the function is assumed to be a built-in function.
FUNCNAME VARCHAR (1024) Y Unqualified name of the user-defined or built-in function.
FUNCID INTEGER Y Identifier for the function.
SPECIFICNAME VARCHAR (128) Y Name of the routine instance (might be system-generated).
OWNER VARCHAR (128)   Authorization ID of the owner of the mapping. 'SYSIBM' indicates that this is a built-in function.
OWNERTYPE CHAR (1)  
  • S = The owner is the system
  • U = The owner is an individual user
WRAPNAME VARCHAR (128) Y Wrapper to which this mapping applies.
SERVERNAME VARCHAR (128) Y Name of the data source.
SERVERTYPE VARCHAR (30) Y Type of data source to which this mapping applies.
SERVERVERSION VARCHAR (18) Y Version of the server type to which this mapping applies.
CREATE_TIME TIMESTAMP   Time at which the mapping was created.
DEFINER1 VARCHAR (128)   Authorization ID of the owner of the mapping. 'SYSIBM' indicates that this is a built-in function.
REMARKS VARCHAR (254) Y User-provided comments, or the null value.
Note:
  1. The DEFINER column is included for backwards compatibility. See OWNER.