SQL/MX 2.x Reference Manual (H06.10+, J06.03+)

Metadata Tables
HP NonStop SQL/MX Reference Manual—544517-008
10-25
TEXT Table
Grant information for individual columns is stored separately in the COL_PRIVILEGES
table.
All character columns store letters in uppercase except for GRANTOR and GRANTEE.
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.
*6 PRIVILEGE_TYPE CHAR(2) Privilege type:
S SELECT
I INSERT
D DELETE
U UPDATE
R REFERENCES
7 IS_GRANTABLE CHAR(2) Y if granted with grant option
N if not
* Indicates primary key
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
Column Name Data Type Description