ROUTINES table
ROUTINES is a metadata table in DEFINITION_SCHEMA_VERSION_vernum
that contains common attributes for all types of stored procedures and functions in this catalog.
VARCHAR columns store letters as is (not converted to uppercase).
In this table, the new columns LINK_TYPE, SECURITY_TYPE, and STORED Column are added in SQL/MX 3.5.
Column Name |
Data Type |
Description |
---|---|---|
*1 UDR_UID |
LARGEINT |
The UID of procedure object |
2 UDR_TYPE |
CHAR(2) |
P for procedure |
3 LANGUAGE_TYPE |
CHAR(2) |
J for Java |
4 DETERMINISTIC_BOOL |
CHAR(2) |
Y if deterministic N if not |
5 SQL_ACCESS |
CHAR(2) |
M=MODIFIES SQL DATA N=NO SQL C=CONTAINS SQL R=READS SQL DATA |
6 CALL_ON_NULL |
CHAR(2) |
Y (call the SPJ if a parameter passed to it is null) |
7 ISOLATE_BOOL |
CHAR(2) |
Y (run in separate process) |
8 PARAM_STYLE |
CHAR(2) |
J for Java |
9 EXTRA_CALL |
CHAR(2) |
N (no extra calls) |
10 TRANSACTION_ATTRIBUTES |
CHAR(2) |
Always RQ (Reserved for future use) |
11 MAX_RESULTS |
INT |
Positive values in the range 0–255 appear with SPJ result sets |
12 STATE_AREA_SIZE |
INT |
Reserved for future use |
13 UDR_ATTRIBUTES |
VARCHAR(128) |
Reserved for future use |
14 EXTERNAL_PATH |
VARCHAR(256) |
Value of specified EXTERNAL PATH |
15 EXTERNAL_FILE |
VARCHAR(256) |
Name of the Java class, possibly prefixed by a package name |
16 EXTERNAL_NAME |
VARCHAR(128) |
Simple name of the Java method |
17 LINK_TYPE |
CHAR(2) |
Indicates if the User Defined Function (UDF) must be resolved with a static (S) link or a dynamic (D) link.
|
18 SECURITY_TYPE |
CHAR(2) |
Indicates if the UDF is executed with the rights of the Definer (D) or the Invoker (I).
|
19 STORED |
CHAR(2) |
Indicates if the UDF is stored within the database or external to the database.
|
* Indicates primary key |