IBM Books

Administration Guide


OBJCAT.FUNCTIONS

Contains a row for each user-defined function (scalar, table or sourced). Does not include built-in functions.

Table 108. OBJCAT.FUNCTIONS Catalog View
Column Name Data Type Nullable Description
FUNCSCHEMA CHAR(8)
Qualified function name.
FUNCNAME VARCHAR(18)
SPECIFICNAME VARCHAR(18)
The name of the function instance (may be system-generated).
DEFINER CHAR(8)
Authorization ID of function definer.
FUNCID INTEGER
Internally-assigned function ID.
RETURN_TYPE SMALLINT
Internal type code of return type of function.
ORIGIN CHAR(1)
  B=Built-in
  E=User-defined, external
  U=User-defined, based on a source
  S=System-generated

TYPE CHAR(1)
  S=Scalar function
  C=Column function
  T=Table function

METHOD CHAR(1)
  N=Not a method
  Y=Method

EFFECT CHAR(2)
  MU=mutator method
  OB=observer method
  CN=constructor method
  blanks=not a method

PARM_COUNT SMALLINT
Number of function parameters.
PARM_SIGNATURE VARCHAR(180) FOR BIT DATA
Concatenation of up to 90 parameter types, in internal format. Zero length if function takes no parameters.
CREATE_TIME TIMESTAMP
Timestamp of function creation. Set to 0 for Version 1 functions.
FUNC_PATH VARCHAR(254) Yes Function path at the time the function was defined.
TYPE_PRESERVING CHAR(1)
Always blank.
VARIANT CHAR(1)
  Y=Variant (results may differ)
  N=Invariant (results are consistent)
  Blank if ORIGIN is not E

SIDE_EFFECTS CHAR(1)
  E=Function has external side-effects
    (number of invocations is important)
  N=No side-effects
  Blank if ORIGIN is not E

FENCED CHAR(1)
  Y=Fenced
  N=Not fenced
  Blank if ORIGIN is not E

NULLCALL CHAR(1)
  Y=Nullcall
  N=No nullcall (function result is
    implicitly null if operand(s) are null).
  Blank if ORIGIN is not E.

CAST_FUNCTION CHAR(1)
  Y=This is a cast function
  N=This is not a cast function

ASSIGN_FUNCTION CHAR(1)
  Y=Implicit assignment function
  N=Not an assignment function

SCRATCHPAD CHAR(1)
  Y=This function has a scratch pad
  N=This function does not have a scratch pad
  Blank if ORIGIN is not E

FINAL_CALL CHAR(1)
  Y=Final call is made to this function at run time
    end-of-statement.
  N=No final call is made.
  Blank if ORIGIN is not E

PARALLELIZABLE CHAR(1)
  Y=Function can be executed in parallel
  N=Function cannot be executed in parallel
  Blank if ORIGIN is not E

CONTAINS_SQL CHAR(1)
Indicates wheter an external function contains SQL.
  N=Function does not contain SQL statements.
  R=Contains read-only SQL statements.
  M=Contains SQL statements that modify data.
  Blank if ORIGIN is not E
DBINFO CHAR(1)
Indicates whether a DBINFO parameter is passed to an external function.
  Y=DBINFO is passed.
  N=DBINFO is not passed.
  Blank if ORIGIN is not E
RESULT_COLS SMALLINT
For a table function (TYPE=T) contains the number of columns in the result table; otherwise contains 1.
LANGUAGE CHAR(8)
Implementation language of function body. Possible values are C, JAVA or OLE. Blank if ORIGIN is not E.
IMPLEMENTATION VARCHAR(254) Yes If ORIGIN=E, identifies the path/module/function that implements this function. If ORIGIN=U and the source function is built-in, this column contains the name and signature of the source function. Null otherwise.
PARM_STYLE CHAR(8)
Indicates the parameter style declared in the CREATE FUNCTION statement. Values:
        DB2SQL
        DB2GENRL
SOURCE_SCHEMA CHAR(8) Yes If ORIGIN=U and the source function is a user-defined function, contains the qualified name of the source function. If ORIGIN=U and the source function is built-in, SOURCE_SCHEMA is 'SYSIBM' and SOURCE_SPECIFIC is 'N/A for built-in'. Null if ORIGIN is not U.
SOURCE_SPECIFIC VARCHAR(18) Yes
IOS_PER_INVOC DOUBLE
Estimated number of I/Os per invocation; -1 if not known (0 default).
INSTS_PER_INVOC DOUBLE
Estimated number of instructions per invocation; -1 if not known (450 default).
IOS_PER_ARGBYTE DOUBLE
Estimated number of I/O's per input argument byte; -1 if not known (0 default).
INSTS_PER_ARGBYTE DOUBLE
Estimated number of instructions per input argument byte; -1 if not known (0 default).
PERCENT_ARGBYTES SMALLINT
Estimated average percent of input argument bytes that the function will actually read; -1 if not known (100 default).
INITIAL_IOS DOUBLE
Estimated number of I/O's performed the first/last time the function is invoked; -1 if not known (0 default).
INITIAL_INSTS DOUBLE
Estimated number of instructions executed the first/last time the function is invoked; -1 if not known (0 default).
CARDINALITY INTEGER Yes The predicted cardinality of a table function. -1 if not known or if function is not a table function.
BODY CLOB(1M) Yes Always null (future use).
REMARKS VARCHAR(254) Yes User-supplied comment, or null.


[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]

[ DB2 List of Books | Search the DB2 Books ]