Records procedures and user-defined functions in the database.
System identifier of the function or procedure. System identifier of the module to which the routine belongs. One of:
"READS SQL DATA"
"MODIFIES SQL DATA".
Offset for routine within module definition.This value is zero if the routine ins not defined in a module. Length of routine definition The total number of routine parameters. The number of result parameters. The number of input parameters. The number of output parameters. Routine definition.If the length of the routine definition exceeds 2000 characters this value is null. The search path for the routine. 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.
"SQL" = The routine is a SQL routine
"EXTERNAL" = The routine is external
The name of the program that implements the routine if it is an external routine otherwise null. The language for the routine if it is external otherwise null. The parameter passing style for the routine if it is an external routine, otherwise null. One of:
"NO" = The routine is defined within a module
"YES" = The routine is defined in a module.
The maximal number of result sets that the routine may return.
Primary key: ROUTINE_SYSID
Secondary index: MODULE_SYSID
Upright Database Technology AB
Voice: +46 18 780 92 00
Fax: +46 18 780 92 40