SQL/MX 3.1 Reference Manual (H06.23+, J06.12+)

Metadata Tables
HP NonStop SQL/MX Release 3.1 Reference Manual—663850-001
10-31
TEXT Table
5. TABLE_UID
6. PRIVILEGE_TYPE
In version 3000 schemas, the primary key consists of the columns in the following
order:
1. TABLE_UID
2. GRANTOR
3. GRANTOR_TYPE
4. GRANTEE
5. GRANTEE_TYPE
6. PRIVILEGE_TYPE
TEXT Table
TEXT is a metadata table in DEFINITION_SCHEMA_VERSION_vernum that stores
text for objects in the catalog:
The TEXT table stores text for objects in the catalog such as check constraint text,
view text, or the Java signature of stored procedures in Java (SPJ). The text is stored
in increments of up to 3000 bytes. Text with more than 3000 bytes has multiple entries,
ordered as indicated by the SEQUENCE_NUM column.
The format of a compressed Java signature differs when a stored procedure returns
result sets because the Java parameters representing result sets do not map with any
of the procedure’s SQL parameters.
Column Name Data Type Description
*1 OBJECT_UID LARGEINT UID for object.
*2 OBJECT_SUB_ID INT Value to differentiate between text items
associated with the same object
*3 SEQUENCE_NUM INT 0 if part 1 of text, 1 if part 2 of text, 2 if part
3, and so on
4 TEXT VARCHAR (3000) Text associated with object.
* Indicates primary key