If the length of the routine definition exceeds 2000 characters this value is null.

SQL_PATH

VARCHAR(2000)

The search path for the routine.

IS_DETERMINISTIC

CHAR(3)

One of:'"NO" = The routine is not deterministic. i.e. invoking the routine with the same input values is not guaranteed to return the same result"YES" = The routine is deterministic, i.e. when invoked with same input values it will always return the same result.

ROUTINE_BODY

CHAR(20)

One of:"SQL" = The routine is a SQL routine"EXTERNAL" = The routine is external

EXTERNAL_NAME

VARCHAR(128)

The name of the program that implements the routine if it is an external routine otherwise null.

EXTERNAL_LANGUAGE

CHAR(20)

The language for the routine if it is external otherwise null.

PARAMETER_STYLE

CHAR(20)

The parameter passing style for the routine if it is an external routine, otherwise null.

SCHEMA_LEVEL_ROU

CHAR(3)

One of:"NO" = The routine is defined within a module"YES" = The routine is defined in a module.