|
SYSIBM.SYSROUTINES www.cadcobol.com - linguagem de programação COBOL |
|
|
|
|
| Desenvolvido por DORNELLES, Carlos Alberto - Analista de Sistemas - Brasília DF. |
Contains a row for every routine. (A routine can be a user-defined function, cast function, or stored procedure.)
| Nome da coluna | Tipo do dado | Descrição | Uso |
| SCHEMA | CHAR(8) NOT NULL | Schema of the routine. | G |
| OWNER | CHAR(8) NOT NULL | Owner of the routine. | G |
| NAME | CHAR(18) NOT NULL | Name of the routine. | G |
| ROUTINETYPE | CHAR(1) NOT NULL | Type of routine: F User-defined function or cast function P Stored procedure |
G |
| CREATEDBY | CHAR(8) NOT NULL | Authorization ID under which the routine was created. | G |
| SPECIFICNAME | CHAR(18) NOT NULL | Specific name of the routine. | G |
| ROUTINEID | INTEGER NOT NULL | Internal identifier of the routine. | G |
| RETURN_TYPE | INTEGER NOT NULL | Internal identifier of the result data type of the function. The column contains a -2 if the function is a table function. |
G |
| ORIGIN | CHAR(1) NOT NULL | Origin of the routine: E External user-defined function (external table or external scalar) or stored procedure Q SQL function U Sourced on user-defined function or built-in function S System-generated function |
G |
| FUNCTION_TYPE | CHAR(1) NOT NULL | Type of function: C Column function S Scalar function T Table function blank For a stored procedure (ROUTINETYPE = 'P') |
G |
| PARM_COUNT | SMALLINT NOT NULL | Number of parameters for the routine. | G |
| LANGUAGE | CHAR(8) NOT NULL | Implementation language of the routine: ASSEMBLER C COBOL COMPJAVA JAVA PLI REXX SQL blank If ROUTINETYPE='F' and ORIGIN is not 'E' or not 'Q'. |
G |
| COLLID | CHAR(18) NOT NULL | Name of the package collection to be used when the routine is executed. A blank value indicates the package collection is the same as the package collection of the program that invoked the routine. | G |
| SOURCESCHEMA | CHAR(8) NOT NULL | If ORIGIN is 'U' and ROUTINETYPE is 'F', the schema of the source user-defined function ('SYSIBM' for a source built-in function). Otherwise, the value is blank. | G |
| SOURCESPECIFIC | CHAR(18) NOT NULL | If ORIGIN is 'U' and ROUTINETYPE is 'F', the specific name of the source user-defined function or source built-in function name. Otherwise, the value is blank. |
G |
| DETERMINISTIC | CHAR(1) NOT NULL | The deterministic option of an external function or a stored procedure: N Indeterminate (results may differ with a given set of input values). Y Deterministic (results are consistent). blank ROUTINETYPE='F' and ORIGIN is not 'E' or not 'Q'(the routine is a function, but not an external function or an SQL function). |
G |
| EXTERNAL_ACTION | CHAR(1) NOT NULL | The external action option of an external function or an SQL function: N Function has no side effects. E Function has external side effects so that the number of invocations is important. blank ORIGIN is not 'E' or 'Q'for the function (ROUTINETYPE='F'), or it is a stored procedure (ROUTINETYPE='P'). |
G |
| NULL_CALL | CHAR(1) NOT NULL | The CALLED ON NOT NULL INPUT option of an external function or stored procedure: N The routine is not called if any parameter has a NULL value. Y The routine is called if any parameter has a NULL value. blank ROUTINETYPE='F' and ORIGIN is not 'E' (the routine is a function, but not an external function). |
G |
| CAST_FUNCTION | CHAR(1) NOT NULL | Whether the routine is a cast function: N The routine is not a cast function. Y The routine is a cast function. A cast function is generated by DB2 for a CREATE DISTINCT TYPE statement. |
G |
| SCRATCHPAD | CHAR(1) NOT NULL | The SCRATCHPAD option of an external function: N This function does not have a SCRATCHPAD. Y This function has a SCRATCHPAD. blank ORIGIN is not 'E' for the function (ROUTINETYPE='F'), or it is a stored procedure (ROUTINETYPE='P'). |
G |
| SCRATCHPAD_LENGTH | INTEGER NOT NULL | Length of the scratchpad if the ORIGIN is 'E' for the function (ROUTINETYPE='F') and NO SCRATCHPAD is not specified. Otherwise, the value is 0. | G |
| FINAL_CALL | CHAR(1) NOT NULL | The FINAL CALL option of an external function: N A final call will not be made to the function. Y A final call will be made to the function. blank ORIGIN is not 'E' for the function (ROUTINETYPE='F'), or it is a stored procedure (ROUTINETYPE='P'). |
G |
| PARALLEL | CHAR(1) NOT NULL | The PARALLEL option of an external function: A This function can be invoked by parallel tasks. D This function cannot be invoked by parallel tasks. blank ORIGIN is not 'E' for the function (ROUTINETYPE='F'), or it is a stored procedure (ROUTINETYPE='P'). |
G |
| PARAMETER_STYLE | CHAR(1) NOT NULL | The PARAMETER STYLE option of an external function or stored procedure: D DB2SQL. All parameters are passed to the external function or stored procedure according to the DB2SQL standard convention. G GENERAL. All parameters are passed to the stored procedure according to the GENERAL standard convention. N GENERAL CALL WITH NULLS. All parameters are passed to the stored procedure according to the GENERAL WITH NULLS convention. J JAVA. All parameters are passed to the function or procedure according to the conventions for JAVA and SQLJ specifications. blank The column is blank if the ORIGIN is not 'E' or if LANGUAGE is SQL. |
G |
| FENCED | CHAR(1) NOT NULL | Y
Indicates that this routine runs separately in the DB2 address space.
All user-defined routines run in the DB2 address space. blank ORIGIN is 'Q' . |
G |
| SQL_DATA_ACCESS | CHAR(1) NOT NULL | The SQL statements that are allowed in an external function, SQL function, or
stored procedure: C CONTAINS SQL: Only SQL that does not read or modify data is allowed. M MODIFIES SQL DATA: All SQL is allowed, including SQL that reads or modifies data. N NO SQL: SQL is not allowed. R READS SQL DATA: Only SQL that reads data is allowed. blank Not applicable. |
G |
| DBINFO | CHAR(1) NOT NULL | The DBINFO option of an external function or stored procedure: N No, the DBINFO parameter will not be passed to the external function or stored procedure. Y Yes, the DBINFO parameter will be passed to the external function or stored procedure. blank ORIGIN is not 'E' . |
G |
| STAYRESIDENT | CHAR(1) NOT NULL | The STAYRESIDENT option of the routine, which determines whether the routine
is to be deleted from memory when the routine ends. N The load module is to be deleted from memory after the routine terminates. Y The load module is to remain resident in memory after the routine terminates. blank ORIGIN is not 'E'. |
G |
| ASUTIME | INTEGER NOT NULL | Number of CPU service units permitted for any single invocation of this routine. If
ASUTIME is zero, the number of CPU service units is unlimited. If a routine consumes more CPU service units than the ASUTIME value allows, DB2 cancels the routine. The column is blank if ROUTINETYPE='F' and ORIGIN is not 'E'. |
G |
| WLM_ENVIRONMENT | CHAR(18) NOT NULL | Name of the WLM environment to be used to run this routine. If the ROUTINETYPE = 'P', the value might be blank. Blank causes the stored procedure to be run in the DB2 stored procedure address space. The column is blank if ROUTINETYPE='F' and ORIGIN is not 'E'. |
G |
| WLM_ENV_FOR_NESTED | CHAR(1) NOT NULL | For nested routine calls, indicates whether the address space of the calling stored
procedure or user-defined function is used to run the nested stored procedure or
user-defined function: N The nested stored procedure or user-defined function runs in an address space other than the specified WLM environment if the calling stored procedure or user-defined function is not running in the specified WLM environment. 'WLM ENVIRONMENT name' was specified. Y The nested stored procedure or user-defined function runs in the environment used by the calling stored procedure or user-defined function. 'WLM ENVIRONMENT(name,*)' was specified. blank If ROUTINETYPE ='F' and ORIGIN is not 'E'.WLM_ENVIRONMENT is blank. |
G |
| PROGRAM_TYPE | CHAR(1) NOT NULL | Indicates whether the routine runs as a Language Environment main routine or a subroutine: M The routine runs as a main routine. S The routine runs as a subroutine. blank ORIGIN is not 'E'. |
G |
| EXTERNAL_SECURITY | CHAR(1) NOT NULL | Specifies the authorization ID to be used if the routine accesses resources
protected by an external security product: D DB2 - The authorization ID associated with the WLM-established stored procedure address space. U USER - The authorization ID of the SQL user that invoked the routine. C DEFINER - The authorization ID of the owner of the routine. blank ORIGIN is not 'E'. |
G |
| COMMIT_ON_RETURN | CHAR(1) NOT NULL | If ROUTINETYPE = 'P', whether the transaction is always to be committed
immediately on successful return (non-negative SQLCODE) from this stored
procedure: N The unit of work is to continue. Y The unit of work is to be committed immediately. If ROUTINETYPE = 'F', the value is blank. |
G |
| RESULT_SETS | SMALLINT NOT NULL | If ROUTINETYPE = 'P', the maximum number of ad hoc result sets that this stored
procedure can return. If no ad hoc result exists or ROUTINETYPE = 'F', the value is zero. |
G |
| LOBCOLUMNS | SMALLINT NOT NULL | If ORIGIN = 'E' or 'Q', the number of LOB columns found in the parameter list for
this user-defined function. If no LOB columns are found in the parameter list or ORIGIN is not 'E' or not 'Q', the value is 0. |
G |
| CREATEDTS | TIMESTAMP NOT NULL | Time when the CREATE statement was executed for this routine. | G |
| ALTEREDTS | TIMESTAMP NOT NULL | Time when the last ALTER statement was executed for this routine. | G |
| IBMREQD | CHAR(1) NOT NULL | A value of Y indicates that the row came from the basic machine-readable material (MRM) tape. For all other values, see Release dependency indicators in topic D.0. | G |
| PARM1 | SMALLINT NOT NULL | Internal use only | I | PARM2 | SMALLINT NOT NULL | Internal use only | I | PARM3 | SMALLINT NOT NULL | Internal use only | I | PARM4 | SMALLINT NOT NULL | Internal use only | I | PARM5 | SMALLINT NOT NULL | Internal use only | I | PARM6 | SMALLINT NOT NULL | Internal use only | I | PARM7 | SMALLINT NOT NULL | Internal use only | I | PARM8 | SMALLINT NOT NULL | Internal use only | I | PARM9 | SMALLINT NOT NULL | Internal use only | I | PARM10 | SMALLINT NOT NULL | Internal use only | I | PARM11 | SMALLINT NOT NULL | Internal use only | I | PARM12 | SMALLINT NOT NULL | Internal use only | I | PARM13 | SMALLINT NOT NULL | Internal use only | I | PARM14 | SMALLINT NOT NULL | Internal use only | I | PARM15 | SMALLINT NOT NULL | Internal use only | I | PARM16 | SMALLINT NOT NULL | Internal use only | I | PARM17 | SMALLINT NOT NULL | Internal use only | I | PARM18 | SMALLINT NOT NULL | Internal use only | I | PARM19 | SMALLINT NOT NULL | Internal use only | I | PARM20 | SMALLINT NOT NULL | Internal use only | I | PARM21 | SMALLINT NOT NULL | Internal use only | I | PARM22 | SMALLINT NOT NULL | Internal use only | I | PARM23 | SMALLINT NOT NULL | Internal use only | I | PARM24 | SMALLINT NOT NULL | Internal use only | I | PARM25 | SMALLINT NOT NULL | Internal use only | I | PARM26 | SMALLINT NOT NULL | Internal use only | I | PARM27 | SMALLINT NOT NULL | Internal use only | I | PARM28 | SMALLINT NOT NULL | Internal use only | I | PARM29 | SMALLINT NOT NULL | Internal use only | I | PARM30 | SMALLINT NOT NULL | Internal use only | I |
| IOS_PER_INVOC | FLOAT NOT NULL WITH DEFAULT -1 |
Estimated number of I/Os that required to execute the routine. The value is -1 if the estimated number is not known. | S |
| INSTS_PER_INVOC | FLOAT NOT NULL WITH DEFAULT -1 |
Estimated number of machine instructions that required to execute the routine. The value is -1 if the estimated number is not known. | S |
| INITIAL_IOS | FLOAT NOT NULL WITH DEFAULT -1 |
Estimated number of I/O's that are performed the first time or the last time the routine is invoked. The value is -1 if the estimated number is not known. | S |
| INITIAL_INSTS | FLOAT NOT NULL WITH DEFAULT -1 |
Estimated number of machine instructions that are performed the first time or the last time the routine is invoked. The value is -1 if the estimated number is not known. | S |
| CARDINALITY | FLOAT NOT NULL WITH DEFAULT -1 |
The predicted cardinality of the routine, -1 to trigger DB2's use of the default value (10,000). | S |
| RESULT_COLS | SMALLINT NOT NULL DEFAULT 1 |
For a table function, the number of columns in the result table. Otherwise, the value is 1. | S |
| EXTERNAL_NAME | VARCHAR(254) NOT NULL | The path/module/function that DB2 should load to execute the routine. The column is blank if the ORIGIN is not 'E'. | G |
| PARM_SIGNATURE | VARCHAR(150) NOT NULL FOR BIT DATA |
Internal use only | I |
| RUNOPTS | VARCHAR(254) NOT NULL | The Language Environment run-time options to be used for this routine. An empty
string indicates that the installation default Language Environment run-time
options are to be used. The column is blank if ROUTINETYPE='F' and ORIGIN is not 'E'. |
G |
| REMARKS | VARCHAR(254) NOT NULL | A character string provided by the user with the COMMENT ON statement. | G |
| JAVA_SIGNATURE | VARCHAR(1024) NOT NULL WITH DEFAULT |
The signature of the jar file. The column is blank if ROUTINETYPE='F' and ORIGIN is not 'E'. |
G |
| CLASS | VARCHAR(128) NOT NULL WITH DEFAULT |
The class name contained in the jar file. The column is blank if ROUTINETYPE='F' and ORIGIN is not 'E'. |
G |
| JARSCHEMA | CHAR(8) NOT NULL WITH DEFAULT |
The schema of the jar file. The column is blank if ROUTINETYPE='F' and ORIGIN is not 'E'. |
G |
| JAR_ID | CHAR(18) NOT NULL WITH DEFAULT |
The name of the jar file. The column is blank if ROUTINETYPE='F' and ORIGIN is not 'E'. |
G |
| SPECIAL_REGS | CHAR(1) NOT NULL WITH DEFAULT 'I' |
The SPECIAL REGISTER option for a routine. I INHERIT SPECIAL REGISTERS D DEFAULT SPECIAL REGISTERS The column is blank if ROUTINETYPE='F' and ORIGIN is not 'E' or not 'Q'. |
G |