SQL/MX 2.x Reference Manual (H06.04+)

Metadata Tables
HP NonStop SQL/MX Reference Manual—540440-003
10-23
ROUTINES Table
ROUTINES Table
ROUTINES is a metadata table in DEFINITION_SCHEMA_VERSION_vernum that
contains SPJ-level attributes, one row for each stored procedure in Java (SPJ) created
in this catalog.
VARCHAR columns store letters as is (not converted to uppercase).
Column Name Data Type Description
*1 UDR_UID LARGEINT 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 Reserved for future use
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
* Indicates primary key