This table manages HiRDB file information (relationships between HiRDB files and RDAREAs). (Each row describes information on one HiRDB file.)

The following table shows the contents of the SQL_PHYSICAL_FILES table.

Table G-2 SQL_PHYSICAL_FILES table contents

Number	Column name	Data type	Contents
1	SERVER_NAME	CHAR(8)	Server name (back-end server name or dictionary server name)
2	PHYSICAL_FILE_NAME	VARCHAR(167)	HiRDB filename
3	RDAREA_NAME	VARCHAR(30) or MVARCHAR(30)	Name of the RDAREA to which HiRDB files are allocated
4	INITIAL_SIZE	INTEGER	Number of HiRDB file segments
5	PHYSICAL_FILE_ID	INTEGER	Physical file ID

This table manages RDAREA definition information. (Each row describes information on one RDAREA.)

The following table shows the contents of the SQL_RDAREAS table.

Table G-3 SQL_RDAREAS table contents

Number	Column name	Data type	Contents
1	RDAREA_NAME	VARCHAR(30) or MVARCHAR(30)	RDAREA name
2	SERVER_NAME	CHAR(8)	Server name (back-end server name or dictionary server name)
3	RDAREA_TYPE	CHAR(1)	RDAREA type: M: Master directory RDAREA D: Data directory RDAREA S: Data dictionary RDAREA W: Work RDAREA U: User RDAREA P: Data dictionary LOB RDAREA L: User LOB RDAREA R: Registry RDAREA K: Registry LOB RDAREA A: list RDAREA
4	PAGE_SIZE	INTEGER	Page length (in bytes)
5	SEGMENT_SIZE	INTEGER	Segment size (in pages)
6	FILE_COUNT	INTEGER	Number of HiRDB files
7	N_TABLE	INTEGER	Number of tables stored (defined number) (initial value is 0). If tables and sequence generators are both defined, the maximum number of tables and sequence generators combined is 500.
8	N_INDEX	INTEGER	Number of indexes stored (defined number) (initial value is 0)
9	RDAREA_ID	INTEGER	RDAREA ID
10	REBALANCE_TABLE	CHAR(1)	Rebalance table status: Y: A rebalance table is used. Null value: No rebalance table is used.
11	MAX_ENTRIES	INTEGER	Maximum number of entries in the list NULL for any RDAREA other than the list RDAREA or if max entries is not specified
12	EXTENSION	CHAR(1)	Specification of RDAREA expansion: U: Specified. N: Not specified.
13	EXTENSION_SEGMENT_SIZE	INTEGER	Number of extension segments NULL if RDAREA expansion is not specified
14	ORIGINAL_RDAREA_NAME	VARCHAR(30) or MVARCHAR(30)	For UNIX: Name of the original RDAREA Null value if the RDAREA is not a replica RDAREA. For Windows: Used by the system (no contents)
15	ORIGINAL_RDAREA_ID	INTEGER	For UNIX: ID of the original RDAREA Null value if the RDAREA is not a replica RDAREA. For Windows: Used by the system (no contents)
16	GENERATION_NUMBER	SMALLINT	For UNIX: Generation number Null value if the RDAREA is not an original RDAREA or replica RDAREA. For Windows: Used by the system (no contents)
17	REPLICA_COUNT	SMALLINT	For UNIX: Replica counter Null value if the RDAREA is not an original RDAREA or if the RDAREA has lost its replica RDAREA. For Windows: Used by the system (no contents)
18	REPLICA_STATUS	CHAR(1)	For UNIX: Replica status C: Current RDAREA S: Sub-RDAREA Null value if the RDAREA is not an original RDAREA or replica RDAREA. For Windows: Used by the system (no contents)
19	SHARED	CHAR(1)	Shared RDAREA S: Shared RDAREA Null value: Unshared RDAREA
20	N_SEQUENCE	INT	Number of stored sequence generators. If the number of sequence generators is 0, the null value is set. If tables and sequence generators are both defined, the maximum number of tables and sequence generators combined is 500.

This table manages information of the tables found in schemas. (Each row describes information on one table.)

The rows of the SQL_TABLES table are created during table definition, and row deletion is performed during table deletion.

The following table shows the contents of the SQL_TABLES table.

Table G-4 SQL_TABLES table contents

Number	Column name	Data type	Contents
1	TABLE_SCHEMA	VARCHAR(30) or MVARCHAR(30)	Table owner or PUBLIC for a public view table
2	TABLE_NAME	VARCHAR(30) or MVARCHAR(30)	Table name
3	TABLE_TYPE	CHAR(16)	Table type BASE TABLE: Base table VIEW: View table READ ONLY VIEW: Read-only view table
4	TABLE_ID	INTEGER	Table ID Indicates an internal ID that is unique within the system.
5	N_COLS	SMALLINT	Number of structure columns
6	N_INDEX	SMALLINT	Number of defined indexes Total number of the following defined indexes: B-tree indexes (including primary keys, cluster keys, and substructure indexes) Plug-in indexes (initial value is 0)
7	DCOLUMN_NAME	VARCHAR(30) or MVARCHAR(30)	Partitioned column name (column name of the first partitioning key for multiple column partitioning or matrix partitioning) Null value for a non-partitioned table and for a view table.
8	VDEFLEN	INTEGER	Length of view analysis information Null value for a base table.
9	FREE_AREA	SMALLINT	Percentage of unused space in each page 0 for a view table.
10	FREE_PAGE	SMALLINT	Rate (%) of free pages (unused pages) inside a segment 0 for a view table.
11	TABLE_COMMENT	VARCHAR(255) or MVARCHAR(255)	Comment (initial value is NULL)
12	CREATE_TIME	CHAR(14)	Table creation date and time (YYYYMMDDHHMMSS)
13	ENQ_RESOURCE_ SIZE	CHAR(1)	Locked resource unit P: In page units Null value for locking in units of rows and for a view table.
14	DEFAULT_COLUMN	SMALLINT	Number of specified columns with the default value (DEFAULT clause or WITH DEFAULT). Null value for a view table and for a dictionary table.
15	RDAREA_NAME	VARCHAR(30) or MVARCHAR(30)	Name of storage RDAREA for non-partitioned table Null value for a partitioned table and for a view table.
16	DEFINITION_CACHE_ SIZE	INTEGER	Table definition cache size (in bytes) (Null value for dictionary tables)
17	STATISTICS_CACHE_ SIZE	INTEGER	Statistical information cache size (in bytes) (The initial value is a null value.)
18	N_RDAREA	INTEGER	Number of RDAREAs for storage of table (1 to 1,024) 0 for a view table.
19	FIX_TABLE	CHAR(1)	FIX specification F: Specified N: Not specified
20	VIEW_LEVEL	INTEGER	Number of nesting levels in view definition Null value for a base table.
21	N_BASETABLE	INTEGER	Number of base tables used for a view table Null value for a base table.
22	ROW_LENGTH	INTEGER	Row length of a FIX table Null value for a non-FIX table and for a view table.
23	N_NOTNULL	INTEGER	Number of NOT NULL values Null value for a view table and for a dictionary table.
24	COMPRESS_TYPE	VARCHAR(8)	Data compression information: Compression type (first byte) S: Data compression (SUPPRESS) Suppressed data type (byte 2 and beyond): D: DECIMAL Null value for a table without SUPPRESS specification, for a view table, and for a dictionary table.
25	DIV_TYPE	CHAR(1)	Partitioning type P: Boundary value partitioning and matrix partitioning H: Flexible hash partitioning F: FIX hash partitioning M: Hash mixed matrix partitioning Null value for a non-partitioned table, for a key range partitioning table, and for a view table.
26	HASH_NAME	VARCHAR(8) or MVARCHAR(8)	Hash function name "HASH1" "HASH2" "HASH3" "HASH4" "HASH5" "HASH6" "HASH0" "HASHA" "HASHB" "HASHC" "HASHD" "HASHE" "HASHF" Null value for a table without a HASH specification, for a matrix partitioning table, for a view table, and for a data dictionary table.
27	N_LOB_COLUMN	SMALLINT	Number of columns with BLOB-data type Null value for a view table and for a table without BLOB columns.
28	N_LOB_RDAREA	INTEGER	Number of user LOB RDAREAs for a table Null value for a view table, for a table without BLOB columns, and for a table without an abstract data type containing BLOB attributes.
29	CHANGE_TIME	CHAR(14)	Time table definition was changed (YYYYMMDDHHMMSS) Null value when a table is created initially.
30	N_DIV_COLUMN	SMALLINT	Number of partitioning key columns (216) Null value for a non-partitioned table, for a table with single column partitioning keys specified, and for a view table.
31	COLUMN_SUP_INF	CHAR(1)	Whether or not data suppression is specified for each column: Y: Specified Null value: No specification Null value for a table for which column-by-column data suppression is not specified and for a view table.
32	N_ADT_COLUMN	SMALLINT	Number of columns with an abstract data type Null value for a table in which an abstract data type is not defined.
33	WITHOUT_ ROLLBACK	CHAR(1)	Whether or not a WITHOUT ROLLBACK is specified 'Y': Specified Null value: No specification Null value for a table for which WITHOUT ROLLBACK is not defined and for a view table.
34	N_EXCEPT_VALUES	INTEGER	Number of exclusion key values in an index Null value for an index without exceptional value specifications and for a view table.
35	EXCEPT_VALUES_LEN	INTEGER	Total length of exclusion key values in an index Null value for an index without exceptional value specifications and for a view table.
36	REBALANCE	CHAR(1)	Whether or not the rebalancing facility is used: Y: Used. Null value for a table that does not use the rebalancing facility and for a view table.
37	INDEXLOCK_OPT	CHAR(1)	Information used by the system
38	N_PK_COLUMNS	SMALLINT	Number of columns for the primary key Null value if no primary key is defined.
39	FOREIGN_SERVER_ NAME	VARCHAR(30) or MVARCHAR(30)	Information used by the system
40	FOREIGN_SERVER_ ID	INTEGER	Information used by the system
41	BASE_FOREIGN_ TABLE_SCHEMA	VARCHAR(30) or MVARCHAR(30)	Information used by the system
42	BASE_FOREIGN_ TABLE_NAME	VARCHAR(30) or MVARCHAR(30)	Information used by the system
43	N_RDAREA_BEFORE_ REBALANCE	INTEGER	Number of partitioning information items before execution of ALTER TABLE ADD RDAREA (number of rows in SQL_DIV_TABLE table)#1 Null value if rebalancing is started, for a table that is not a rebalancing table, and for a view table.
44	ON_REBALANCE	CHAR(1)	Rebalancing status: Y: Under execution Null value: Execution not ongoing Becomes Y after rebalancing has started, and becomes a null value when rebalancing is normally terminated.
45	SEGMENT_REUSE	CHAR(1)	Whether or not SEGMENT REUSE is specified Y: Specified Null value: Not specified Null value if NO is specified for SEGMENT REUSE (including when its specification is omitted) and for a view table.
46	N_REUSE_SEGMENT	INTEGER	Number of segments that start reusing free areas.#2 Null value if NO is specified for SEGMENT REUSE (including when its specification is omitted) and for a view table.
47	REUSE_SEGMENT_SIZE	CHAR(10)	Specified number of segments that start reusing free areas.#3 Null value if a value other than a segment count is specified for SEGMENT REUSE and for a view table.
48	REUSE_SEGMENT_SIZE_TYPE	CHAR(1)	Unit for the number of segments that start reusing free areas. K: Specifies K. M: Specifies M. Null value: Not specified. Null value if a value other than a segment count is specified for SEGMENT REUSE and for a view table.
49	INSERT_ONLY	CHAR(1)	Whether or not the falsification prevention facility is specified Y: Specified Null value: Not specified Null value if the falsification prevention facility is not used and for a view table.
50	DELETE_PROHIBIT_TERM_TYPE	CHAR(1)	Type of deletion prevented duration I: Date interval data Y: Labeled duration (YEAR) M: Labeled duration (MONTH) D: Labeled duration (DAY) Null value: Not specified Null value if the falsification prevention facility is not used and for a view table.
51	DELETE_PROHIBIT_TERM	CHAR(10)	Specification value for the deletion prevented duration#4 Null value if the falsification prevention facility is not used, if no deletion prevented duration is specified, and for a view table.
52	SYSGEN_COLUMN_NAME	VARCHAR(30) or MVARCHAR(30)	Name of the insert history maintenance column Null value if the falsification prevention facility is not used, if no deletion prevented duration is specified, and for a view table.
53	N_TRIGGER	INTEGER	Number of defined triggers Null value if no trigger is defined, and for a view table or a data dictionary table.
54	N_DIV_DIMENSION	SMALLINT	Number of division dimensions Null value for a table that is not a matrix-partitioned table.
55	AUDIT_TABLE_OPTION	CHAR(1)	Value that specifies whether this table is an audit trail table. Y: Audit trail table V: View table based on an audit trail table Null value for a table that is not an audit trail table or a view table based on an audit trail table.
56	N_PARENTS	SMALLINT	Number of foreign keys Null value for a table without a defined referential constraint and for a view table.
57	N_CHILDREN	SMALLINT	Number of foreign keys that reference the main keys of this table Null value for an unreferenced table that is not a referenced table and for a view table.
58	N_FK_COLUMNS	SMALLINT	Total number of foreign key columns Null value for a table without defined referential constraints and for a view table.
59	CHECK_PEND	CHAR(1)	Type of check pending status for a referential constraint C: Pending status Null value: Non-pending status Null value for a view table.
60	N_CHECK	INTEGER	Number of defined check constraints Null value for a table without defined referential constraints and for a view table.
61	N_CHECK_LIMIT	INTEGER	Check constraint limit#5 Null value for a table without defined referential constraints and for a view table.
62	CHECK_PEND2	CHAR(1)	Type of check pending status for a check constraint C: Pending status Null value: Non-pending status Null value for a view table.
63	CHK_SOURCE_LEN	INTEGER	Total length of search conditions of a check constraint Null value for a table without defined referential constraints and for a view table.
64	SHARED	CHAR(1)	Shared table specification S: Shared table Null value: Unshared table
65	CHANGE_TIME_INSERT_ONLY	CHAR(14)	Update date and time of a falsification prevention table (YYYYMMDDHHMMSS) Null value when a table is defined and for a view table.
66	N_UPDATE_COLUMN	SMALLINT	Number of columns for which an updatable column attribute is specified Null value for a table without a specified updatable column attribute and for a view table.
67	TABLE_CREATOR	VARCHAR(30) or MVARCHAR(30)	Creator of a public view table Null value for a table that is not a public view table.
68	N_CONSTRUCTOR_COLUMN	SMALLINT	Used by the system; always the null value.
69	CONSTRUCTOR_TYPE	CHAR(1)	Used by the system; always the null value.
70	NONE_DFLTCST_CLMCOUNT	SMALLINT	Number of columns for which non-default character sets are specified Null value if no character set is specified.
71	CHARSET_SPECCOUNT	SMALLINT	Number of columns for which character sets are specified Null value if no character set is specified.
72	N_PARTIAL_STRUCTURE_INDEXES	SMALLINT	Number of substructure indexes defined Null value if no substructure index is defined and for a view table.
73	MEMORY_TABLE	CHAR(1)	Information on table expansion to the memory database: A: Waiting to be expanded to the memory database C: Expansion to the memory database has been completed D: Waiting to be released from expansion to the memory database Null value: Not expanded to the memory database Null value for a table that is not expanded to the memory database and for a view table.
74	DBAREA_NAME	VARCHAR(30) or MVARCHAR(30)	Name of database area for data Null value for a table that is not expanded to the memory database and for a view table.
75	XDS_NAME	CHAR(8)	XDS name of the storage for a table to be expanded to the memory database#6 Null value for a table that is not expanded to the memory database and for a view table.

#1: If an RDAREA is added to a rebalancing table by using ALTER TABLE ADD RDAREA, the number of partitioning information items (number of rows in the SQL_DIV_TABLE table) existing before the RDAREA was added is stored.

Once the number of partitioning information items has been set, it will not be updated even when an RDAREA is added by using ALTER TABLE ADD RDAREA until the rebalancing operation is completed by the rebalancing utility (pdrbal). When the rebalancing operation is completed, the null value is set.

#2: When a segment count unit is specified, the following values are stored:

When K is specified: Specified value x 1,024

When M is specified: Specified value x 1,024²

#3: Values are stored right-justified. Note that the segment count units (K and M) are not included.

#4: The following is stored depending on the type of deletion prevented duration:

When 'I' is specified: +YYYYMMDD. character format

When 'Y', 'M', or 'D' is specified: Right-justified character format

#5: The check constraint limit is the sum of the total number of logical operators specified in the search conditions of the check constraints (number of AND and OR specifications, excluding the AND and OR specifications in WHEN search conditions of CASE expressions) and the total number of check constraints.

Example

If a table is defined as follows, the check constraint limit is 4 (the total number of operators (AND and OR) is 2 and the total number of check constraints is 2):

 
CREATE TABLE "STOCK"
  ("GNO" CHAR(5),"GNAME" CHAR(8),"PRICE" INTEGER,
    "QUANTITY" INTEGER,"STOCKING DATE" DATE)
  CHECK("QUANTITY " 100 AND "QUANTITY"  1000)
  CONSTRAINT "QUANTITY RULE"
  CHECK("STOCKING DATE"=DATE('1992-08-21')
    OR "STOCKING DATE"=DATE('1992-09-21'))
  CONSTRAINT "STOCKING DATE RULE"

#6: If the left-justified length is less than 8 characters, the column is padded with spaces.

This table manages column definition information. (Each row describes information on one column.)

Rows of the SQL_COLUMNS table are created during table definition, and row deletion (including schema deletion) is performed during table deletion.

The following table shows the contents of the SQL_COLUMNS table.

Table G-5 SQL_COLUMNS table contents

Number	Column name	Data type	Contents
1	TABLE_SCHEMA	VARCHAR(30) or MVARCHAR(30)	Table owner or PUBLIC for a public view table
2	TABLE_NAME	VARCHAR(30) or MVARCHAR(30)	Name of the table that contains the column
3	COLUMN_NAME	VARCHAR(30) or MVARCHAR(30)	Column name
4	TABLE_ID	INTEGER	Table ID
5	COLUMN_ID	SMALLINT	Column ID (integer beginning with 1; values less than 1 are not allowed)
6	DATA_TYPE	CHAR(24)	Data type#1
7	DATA_LENGTH	CHAR(7)	Column data length is stored right justified in character format (spaces are used for leading zeros)
8	IS_NULLABLE	CHAR(3)	Column null information: YES: Null value allowed NO: Null values not allowed
9	DIVIDED_KEY	CHAR(1)	Partitioning key: Y: Partitioning key Empty: Not a partitioning key
10	CLUSTER_KEY	CHAR(1)	Cluster key: Y: Column used for cluster key Empty: Not a column used for cluster key
11	COLUMN_COMMENT	VARCHAR(255) or MVARCHAR(255)	Comment (The initial value is a null value.)
12	BASE_TYPE	CHAR(1)	Base column type#7: C: Column F: Function, operation E: Other Null value for a base table.
13	BASE_OWNER	VARCHAR(30) or MVARCHAR(30)	Owner of base table that contains base column Null value for a base table.
14	BASE_TABLE	VARCHAR(30) or MVARCHAR(30)	Name of base table that contains base column Null value for a base table.
15	BASE_COLUMN	VARCHAR(30) or MVARCHAR(30)	Base column name Null value for a base table.
16	DEFAULT_COLUMN	CHAR(1)	WITH DEFAULT specification Y: Specified N: Not specified Null value for view tables
17	COLUMN_OFFSET	SMALLINT	Column offset Null value for a non-FIX table and for a view table.
18	HASH_KEY	CHAR(1)	Hash key: Y: Hash key Empty: Other than hash key
19	RECOVERY_TYPE	CHAR(1)	RECOVERY specification: A: ALL P: PARTIAL N: NO Null value if the data type is not BLOB.#8
20	LOB_LENGTH	CHAR(20)	Column length specification stored right-justified in character format (spaces are used for leading zeros) Null value if the length is not for BLOB or BINARY.#8
21	LOB_LENGTH_TYPE	CHAR(1)	Column length type (in column lengths): K: K specified M: M specified G: G specified Empty: Default Null value if the data type is not BLOB.#8
22	DATA_TYPE_CODE	SMALLINT	Data type code#2
23	DATA_LENGTH_CODE	SMALLINT	Column data length code#3
24	LOB_LENGTH_CODE	CHAR(8)	BLOB column data length code#4, #5 Null value if the data type is not BLOB or BINARY.
25	DIVCOL_ORDER	SMALLINT	Partitioning key specification order (0-16) Unique values within the applicable table, beginning with 1. Partitioning key specification order +1. 0 is specified for a column that is not a partitioning key. Null value for a non-partitioned table, for a table with single column partitioning keys specified, and for a view table.
26	SUPPRESS_INF	CHAR(1)	Whether or not data suppression is specified: Y: Specified Null value: No specification Null value for a table without the data suppression specification and for a view table.
27	PLUGIN_ DESCRIPTION	VARCHAR(255)	Plug-in option contents Null value if no PLUGIN clause is specified.
28	UDT_OWNER	VARCHAR(30)	Owner of a user-defined type Null value if the type is not user-defined.
29	UDT_NAME	VARCHAR(30)	Name of the user-defined type Null value if the type is not user-defined.
30	UDT_TYPE_ID	INTEGER	User-defined type ID Null value if the type is not user-defined.
31	MAX_ELM	SMALLINT	Maximum number of repetition column elements Null value if the column is not a repetition column.
32	NO_SPLIT	CHAR(1)	Whether or not NO SPLIT is specified: Y: Specified Null value: No specification Null value for a view table and for when ALTER TABLE CHANGE SPLIT is executed.
33	PRIMARY_KEY	CHAR(1)	Primary key type Y: Primary key Empty: Other than the primary key
34	COLLATING_SEQUENCE	CHAR(1)	Information used by the system
35	TRAILING_SPACE	CHAR(1)	Information used by the system
36	SYSTEM_GENERATED	CHAR(1)	Whether or not SYSTEM GENERATED is specified Y: Specified Null value: No specification Null value if SYSTEM GENERATED is not specified and for a view table.
37	DEFAULT_CLAUSE	CHAR(1)	Whether or not the DEFAULT clause is specified Y: Specified Null value: No specification Null value if the DEFAULT clause is not specified and for a view table.
38	DEFAULT_VALUE	VARCHAR(32000) or MVARCHAR(32000)#6	Default value (character format) specified for the DEFAULT clause.#9 Null value if the DEFAULT clause is not specified and for a view table.
39	DEFAULT_VALUE2	VARCHAR(32000) or MVARCHAR(32000)#6	Default value specified for the DEFAULT clause (stores the 32,001st - 64,000th byte values in the character format when a literal is specified).#9 Null value if a literal is not specified, if the DEFAULT clause is not specified, and for a view table.
40	DEFAULT_VALUE3	VARCHAR(3) or MVARCHAR(3)	Default value specified for the DEFAULT clause (stores the 64,000th byte value and beyond in the character format when a literal is specified).#9 Null value if a literal is not specified, if the DEFAULT clause is not specified, and for a view table.
41	CHECK_COLUMN	CHAR(1)	Check constraint specification Y: Specified Null value for a table in which a check constraint is not defined and for a view table.
42	FOREIGN_KEY	CHAR(1)	Foreign key type Y: Foreign key configuration table Null value: Non-foreign key configuration table
43	UPDATABLE	CHAR(1)	Updatable column attribute U: Can be updated (UPDATE) N: Can be updated only once from a null value to a non-null value (UPDATE ONLY FROM NULL) Null value for a table without a specified updatable column attribute and for a view table.
44	CONSTRUCTOR_TYPE	CHAR(1)	Used by the system; always the null value.
45	CHARSET_SCHEMA	VARCHAR(30) or MVARCHAR(30)	Character set owner (always MASTER). Null value if no character set is specified.
46	CHARSET_NAME	VARCHAR(30) or MVARCHAR(30)	Character set name: EBCDIK: EBCDIK is specified for the character set. UTF16: UTF16 is specified for the character set. Null value if no character set is specified.
47	CHARSET_ID	INTEGER	Character set ID. Null value if no character set is specified. For details about the character set IDs, see the HiRDB Version 9 Installation and Design Guide.

#1: The stored value depends on the data type, as follows:

Data type	Value to be stored
INTEGER	INTEGER
SMALLINT	SMALLINT
DECIMAL	DECIMAL
FLOAT	FLOAT
DOUBLE PRECISION
SMALLFLT	SMALLFLT
REAL
CHAR	CHAR
VARCHAR	VARCHAR
NCHAR	NCHAR
NVARCHAR	NVARCHAR
MCHAR	MCHAR
MVARCHAR	MVARCHAR
DATE	DATE
TIME	TIME
TIMESTAMP	TIMESTAMP
INTERVAL YEAR TO DAY	INTERVAL YEAR TO DAY
INTERVAL HOUR TO SECOND	INTERVAL HOUR TO SECOND
BINARY	BINARY
BLOB	BLOB
Abstract data type	ADT
BOOLEAN	BOOLEAN

#2: The stored value depends on the data type, as follows:

Data type	Value to be stored
	When the null value can be specified	When the null value cannot be specified
INTEGER	F1	F0
SMALLINT	F5	F4
DECIMAL	E5	E4
FLOAT	E1	E0
DOUBLE PRECISION
SMALLFLT	E3	E2
REAL
CHAR	C5	C4
VARCHAR	C1	C0
NCHAR	B5	B4
NVARCHAR	B1	B0
MCHAR	A5	A4
MVARCHAR	A1	A0
DATE	71	70
TIME	79	78
TIMESTAMP	7D	7C
INTERVAL YEAR TO DAY	65	64
INTERVAL HOUR TO SECOND	6F	6E
BINARY	91	90
BLOB	93	92
Abstract data type	83	82
BOOLEAN	21	20

#3: For the DECIMAL, INTERVAL YEAR TO DAY, and INTERVAL HOUR TO SECOND types, precision and scale are each stored in 1 byte. In all other cases, size (number of characters for the NCHAR and NVARCHAR types) is stored in the 2-byte binary format. Note that the value is 0 for the BLOB, BINARY, and abstract data types.

#4: The specified column length is stored in binary format in 8 bytes divided into 4-byte segments.

#5: SQL results are not subject to endian conversion, even for connection modes with different endians. Therefore, applications must handle the endian.

#6: Specifies NO SPLIT.

#7: E (Other) is set when the selection formula is one of the following:

• Scalar operations (four arithmetic operations, data operation, time operation, CASE expression, and scalar functions)
• Literal
• CAST specification
• Function invocation (excluding plug-in functions)
• USER
• CURRENT_DATE
• CURRENT_TIME
• CURRENT_TIMESTAMP

#8: The value listed below is set for columns of a view table when a function call is specified and its resulting data type is BLOB. For this reason, the resulting format might differ from the format specified when the function was defined.

• NULL is set in a RECOVERY_TYPE column.
• An exact multiple of the largest unit (K, M, or G) is set in a LOB_LENGTH column.
• The largest divisible units are set in a LOB_LENGTH_TYPE column.

#9: The following table shows the values that are stored when the DEFAULT clause is specified.

Table G-6 Values that are stored when the DEFAULT clause is specified

Default value			Data type#1	Value stored in DEFAULT_VALUE column, DEFAULT_VALUE2 column, or DEFAULT_VALUE3 column#2
				Data size (in char format)	Default value (character format)
Omitted			All	Null value	Null value
NULL			All	4	'NULL'
USER			CHAR and MCHAR	4	'USER'
			VARCHAR and MVARCHAR
CURRENT DATE			DATE, or CHAR(10)	12	'CURRENTDATE'#3
CURRENT_DATE				12	'CURRENT_DATE'
CURRENT TIME			TIME or CHAR(8)	12	'CURRENTTIME'#3
CURRENT_TIME				12	'CURRENT_TIME'
CURRENT TIMESTAMP(p) (p: decimal seconds precision)			TIMESTAMP, CHAR(19), CHAR(22), CHAR(24), or CHAR(26)	20	'CURRENTTIMESTAMP(p)'#3, #7
CURRENT_TIMESTAMP(p) (p: decimal seconds precision)				20	'CURRENT_TIMESTAMP(p)'#7
Lit	Char string lit	Character string literal Example 1: 'HiRDB' Example 2: '2002-10-24 10:50:23.1234'	CHAR or MCHAR	def-val-size + 2#4	specified-default-value-size#4 Example: ''HiRDB''
			VARCHAR or MVARCHAR
			DATE, TIME, or TIMESTAMP	def-val-size + 2#4	specified-default-value-size#4 Example: ''2002-10-2410:50:23.1234''
		Mixed character string literal Example: M'100 years'	CHAR or MCHAR	def-val-size + 3#4	specified-default-value-size#4 Example: 'M'100 years''
			VARCHAR or MVARCHAR
		National character string literal Example: N'software'	NCHAR or NVARCHAR	def-val-size + 3#4	specified-default-value-size#4 Example: 'N'software'''
		Hexadecimal character string literal Example 1: X'48692D43' Example 2: X'2002102410502312'	CHAR, VARCHAR, MCHAR, MVARCHAR, or BINARY	def-val-size + 3#4	Example: 'X'48692D43''#4, #6
			DATE, TIME, or TIMESTAMP(p)		Example: 'X'2002102410502312''#4, #6
	Num lit	Integer literal Example: 10	INTEGER, SMALLINT, DECIMAL, FLOAT, or SMALLFLT	def-val-size#5	specified-default-value#5 Example: '10'
		Floating-point literal Example: 15e + 3	INTEGER, SMALLINT, DECIMAL, FLOAT, or SMALLFLT	22 or 23	specified-default-value#5 Example: '+1.500000000000000E+04' (From the left, 1 byte for a sign, 17 bytes for the virtual number portion (decimal literal), 1 byte for 'E', 1 byte for a sign, 2-3 bytes for the exponential part (power of 10))
		Decimal literal Example 1: 15.5 Example 2: -010101. Example 3: 00011399.	INTEGER, SMALLINT, DECIMAL, FLOAT, SMALLINT, INTERVAL YEAR TO DAY, or INTERVAL HOUR TO SECOND	def-val-size#5	specified-default-value#5 Example 1: ' 15.5' Example 2: '-010101.' Example 3: '+00020199.' for INTERVAL YEAR TO DAY ' 00011399.' for INTEGER (For INTERVAL YEAR TO DAY and INTERVAL HOUR TO SECOND, the value is corrected and a sign is added to the front (the value is empty in all other cases and for a positive value))

The following abbreviations are used in this table:

Num: Numeric

Lit: Literal

Char: Character

def: default

val: value

: 1-byte space

#1: Excludes BLOB, the abstract data type, and BINARY of 32,001 bytes or greater.

#2: If the data size is smaller than 32,001 bytes, the DEFAULT_VALUE2 column and DEFAULT_VALUE3 column become null values. If the data size is 32,001-64,000 bytes, the DEFAULT_VALUE3 column becomes a null value.

#3: Spaces between CURRENT and DATE, TIME, or TIMESTAMP are edited into a single space.

#4: The specified default value is stored as a literal expression in the character format. The data size and default value include the literal expressions M, N, X, and apostrophe ('). Therefore, the data size range is 2-32,002 bytes including ' ' for a character string literal, 3-32,003 bytes including M' ' and N' ' for a mixed character string literal and a national character string literal, and 3-64,003 bytes including X' ' for a hexadecimal character string literal.

Bytes 1-32,000 of the specified literal are stored in the DEFAULT_VALUE column; bytes 32,001-64,000 are stored in the DEFAULT_VALUE2 column; and bytes 64,000 and beyond are stored in the DEFAULT_VALUE3 column.

Example:

When 32,000 bytes worth of a default value is specified for the hexadecimal character string literal (a total of 64,003 bytes including X and an apostrophe ('))

VARCHAR(32000) DEFAULT X'C1C1C1...C1C1C1'

The first 32,000 bytes X'C1C1C1... are stored in the DEFAULT_VALUE column.

The next 32,000 bytes C1C1C1... are stored in the DEFAULT_VALUE2 column.

The remaining 3 bytes C1' are stored in the DEFAULT_VALUE3 column.

#5: The specified default value is stored as a literal expression in the character format. Size in the character format expression is stored for the data size.

Example:

When a default value is specified for the numeric literal

INTEGER DEFAULT 100

The first 3 bytes 100 are stored in the DEFAULT_VALUE column.

Null values are stored in the DEFAULT_VALUE2 and DEFAULT_VALUE3 columns.

#6: The value is all upper-case letters (upper-case letters are stored even when lower-caser letters are specified for the value).

#7: If the decimal precision (p) for the CURRENT_TIMESTAMP value to be specified for the default value is omitted, p = 0 is assumed.

This table manages information about the following indexes (each row describes information for one index):

• B-tree indexes (including primary keys, cluster keys, and substructure indexes)
• Plug-in indexes

The following table shows the contents of the SQL_INDEXES table.

Table G-7 SQL_INDEXES table contents

Number	Column name	Data type	Contents
1	TABLE_SCHEMA	VARCHAR(30) or MVARCHAR(30)	Table owner
2	TABLE_NAME	VARCHAR(30) or MVARCHAR(30)	Name of the table that contains an index
3	INDEX_NAME	VARCHAR(30) or MVARCHAR(30)	Index name
4	INDEX_ID	INTEGER	Index ID
5	TABLE_ID	INTEGER	Table ID
6	UNIQUE_TYPE	CHAR(1)	Unique type: U: Unique N: Non-unique
7	COLUMN_COUNT	SMALLINT	Number of columns comprising the index
8	CREATE_TIME	CHAR(14)	Index creation date and time (YYYYMMDDHHMMSS)
9	RDAREA_NAME	VARCHAR(30) or MVARCHAR(30)	Name of storage RDAREA for non-partitioned index Null value for a partitioning key index.
10	CLUSTER_KEY	CHAR(1)	Index type: Y: Cluster index N: Non-cluster index
11	DIV_INDEX	CHAR(1)	Type of first column of the columns that make up the index: Y: Partitioning key or plug-in index (The same order from the first key of partitioning keys specified in CREATE TABLE for multiple-partitioning keys) N: Not a partitioning key
12	FREE_AREA	SMALLINT	Percentage of unused space in each page (%)
13	COLUMN_ID_LIST	VARCHAR(64)	List of IDs of columns constituting the index# Ascending and descending orders are indicated with + and -. + is set to specify the descending order of single-column indexes (other than cluster key indexes). + is always set for plug-in indexes.
14	SPLIT_OPT	CHAR(1)	Page split option: U: Unbalanced split Null value for an index for which unbalanced split is not specified.
15	ATTR_COUNT	SMALLINT	Number of abstract data type attributes constituting an index Null value for CREATE INDEX (Format 1).
16	INDEX_TYPE_OWNER	VARCHAR(30) or MVARCHAR(30)	Owner of an index type Null value for CREATE INDEX (Format 1).
17	INDEX_TYPE_NAME	VARCHAR(30) or MVARCHAR(30)	Name of an index type Null value for CREATE INDEX (Format 1).
18	INDEX_TYPE_ID	INTEGER	Index type ID Null value for CREATE INDEX (Format 1).
19	PLUGIN_ DESCRIPTION	VARCHAR(255)	Plug-in option contents Null value if PLUGIN is not specified.
20	N_FUNCTION	INTEGER	Number of applied functions Null value for CREATE INDEX (Format 1).
21	EXCEPT_VALUES	CHAR(1)	Whether or not exclusion key values are specified: Y: Specified N: Not specified
22	N_EXCEPT_VALUES	SMALLINT	Number of exclusion key values in an index Null value for indexes without exception value specifications
23	ARRAY_TYPE	CHAR(1)	Type of the columns that make up the index: M: Includes repetition columns Null value: The columns that make up the index do not include repetition columns.
24	LOCK_OPT	CHAR(1)	Information used by the system
25	PRIMARY_KEY	CHAR(1)	Index type Y: Primary key index Null value: Not a primary key index
26	DIV_IN_SRV	CHAR(1)	Whether or not a non-partitioning key index is partitioned within the server: Y: Partitioned within the server Null value: Not partitioned within the server Null value for a partitioning key index.
27	SHARED	CHAR(1)	Shared index specification S: Shared index Null value: Unshared index
28	N_PARTIAL_STRUCTURE_PATHS	SMALLINT	Number of component substructure paths of a substructure index Null value if no substructure index is defined.
29	USING_UNIQUE_TAG	CHAR(1)	Substructure path uniqueness Y: Substructure paths are unique NULL: Other than the above Null value if no substructure index is defined or when USING UNIQUE TAG is not specified.
30	DBAREA_NAME	VARCHAR(30) or MVARCHAR(30)	Database area name for index Null value if the table is not expanded to the memory database.

#: SQL results are not subject to endian conversion, even for connection modes with different endians. Therefore, applications must handle the endian.

This table manages information about the execution and DBA (database administration) privileges of users. (Each row describes information on one user.)

This table can be referenced only by owners with the DBA privilege and auditors.

The following table shows the contents of the SQL_USERS table.

Table G-8 SQL_USERS table contents

Number	Column name	Data type	Contents
1	USER_ID	VARCHAR(30) or MVARCHAR(30)	Name of the user with privileges
2	DBA_PRIVILEGE	CHAR(1)	DBA privilege: Y: Has the DBA privilege N: Does not have the DBA privilege
3	SCHEMA_PRIVILEGE	CHAR(1)	Schema definition privilege: Y: Has the schema definition privilege S: Owns a schema N: Does not have the schema definition privilege The initial value is N.
4	CREATE_TIME	CHAR(14)	Schema creation date and time (YYYYMMDDHHMMSS) The initial value is a null value; also a null value when DROP SCHEMA is executed.
5	AUDIT_PRIVILEGE	CHAR(1)	Audit privilege status: Y: Granted Null value: Not granted Null value for any user who is not the auditor.
6	AUTH_ERR_COUNT	SMALLINT	Number of consecutive certification failures Null value if the number of consecutive certification failures is not specified, the number of consecutive user certification failures is 0, or the number of continuous certification failures has been cleared.
7	CON_LOCK_TIME	TIMESTAMP(0)	Consecutive certification failure account lock date and time Null value if the number of consecutive certification failures is not specified or if the consecutive certification failure account lock state has not occurred.#
8	PWD_LOCK_TIME	TIMESTAMP(0)	Password-invalid account lock date and time Null value if a password character string limit is not specified or if the password-invalid account lock state has not occurred.
9	PASSWORD_TEST	CHAR(1)	Password limit violation type code L: Minimum number of allowed bytes U: Specification of authentication indicator prohibited S: Specification of single-character type prohibited Null value if the user for whom the password-invalid account lock state occurs has not been prechecked or if there is no violation after the precheck.

#: If the consecutive certification failure account lock is set and no connection is established after the specified account lock period has elapsed, a null value is not set even if the consecutive certification failure account lock state has not occurred.

This table manages the assignment of RDAREA usage privileges. (Each row describes information on one user of one RDAREA.)

The following table shows the contents of the SQL_RDAREA_PRIVILEGES table.

Table G-9 SQL_RDAREA_PRIVILEGES table contents

Number	Column name	Data type	Contents
1	GRANTEE	VARCHAR(30) or MVARCHAR(30)	Name of the user with the RDAREA usage privilege or PUBLIC
2	RDAREA_NAME	VARCHAR(30) or MVARCHAR(30)	Name of the RDAREA
3	GRANT_TIME	CHAR(14)	Date and time at which the relevant privilege was granted (YYYYMMDDHHMMSS)

This table manages the granting of table access privileges. (Each row describes information on one user.)

Rows of the SQL_TABLE_PRIVILEGES table are created when users are granted table access privileges by GRANT. Rows are deleted when all of a user's privileges are revoked by REVOKE.

The following table shows the contents of the SQL_TABLE_PRIVILEGES table.

Table G-10 SQL_TABLE_PRIVILEGES table contents

Number	Column name	Data type	Contents
1	GRANTOR	VARCHAR(30) or MVARCHAR(30)	Name of the user granting the table access privileges or the definer of the public view table
2	GRANTEE	VARCHAR(30) or MVARCHAR(30)	Name of the user who receives table access privilege, or PUBLIC
3	TABLE_SCHEMA	VARCHAR(30) or MVARCHAR(30)	Owner of the table for which access privilege is to be granted. PUBLIC for a public view table.
4	TABLE_NAME	VARCHAR(30) or MVARCHAR(30)	Name of the table for which access privileges are to be granted
5	SELECT_PRIVILEGE	CHAR(1)	SELECT privilege status: G: Granted (for a table owner) Y: Granted N: Not granted The initial value is N.
6	INSERT_PRIVILEGE	CHAR(1)	INSERT privilege status G: Granted (for a table owner) Y: Granted N: Not granted The initial value is N.
7	DELETE_PRIVILEGE	CHAR(1)	DELETE privilege status G: Granted (for a table owner) Y: Granted N: Not granted The initial value is N.
8	UPDATE_PRIVILEGE	CHAR(1)	UPDATE privilege status G: Granted (for a table owner) Y: Granted N: Not granted The initial value is N.
9	GRANT_TIME	CHAR(14)	Date and time at which the relevant privilege was granted (YYYYMMDDHHMMSS)
10	GRANTEE_TYPE	CHAR(1)	Null value (fixed)

This table manages information of the base tables that serve as the basis for view tables. (Each row describes information on one view table.)

The following table shows the contents of the SQL_VIEW_TABLE_USAGE table.

Table G-11 SQL_VIEW_TABLE_USAGE table contents

Number	Column name	Data type	Contents
1	VIEW_SCHEMA	VARCHAR(30) or MVARCHAR(30)	Owner of a view table or PUBLIC for a public view table
2	VIEW_NAME	VARCHAR(30) or MVARCHAR(30)	Name of a view table
3	BASE_OWNER	VARCHAR(30) or MVARCHAR(30)	Owner of the base table or the resource to be used, or PUBLIC for a public view table or public routine
4	BASE_TABLE_NAME	VARCHAR(30) or MVARCHAR(30)	Name of the base table or the resource to be used
5	BASE_TYPE	CHAR(1)	Type of the base table or the resource to be used R: Real table V: View table P: User-defined function (excluding plug-in functions)
6	BASE_ROUTINE_CREATOR	VARCHAR(30) or MVARCHAR(30)	User who defined a public function if the resource to be used is the public function Null value if the resource to be used is not a public function

This table manages view table definition information. (Each row describes information on one view table.)

The following table shows the contents of the SQL_VIEWS table.

Table G-12 SQL_VIEWS table contents

Number	Column name	Data type	Contents
1	VIEW_SCHEMA	VARCHAR(30) or MVARCHAR(30)	Owner of a view table or PUBLIC for a public view table
2	VIEW_NAME	VARCHAR(30) or MVARCHAR(30)	Name of a view table
3	SOURCE_ORDER	INTEGER	Order if source is divided and stored in multiple rows (1-n)
4	IS_UPDATABLE	CHAR(3)	Update possibility: YES: Possible NO: Not possible
5	VIEW_DEFINITION	VARCHAR(32000) or MVARCHAR(32000)	View definition source statements
6	VIEW_ID	INTEGER	View ID

This table manages table partitioning information in the database. (Each row describes information on one table.)

The following table shows the contents of the SQL_DIV_TABLE table.

Table G-13 SQL_DIV_TABLE table contents

Number	Column name	Data type	Contents
1	TABLE_SCHEMA	VARCHAR(30) or MVARCHAR(30)	Owner of a view table
2	TABLE_NAME	VARCHAR(30) or MVARCHAR(30)	Name of a view table
3	DIV_NO	INTEGER	Partitioning condition specification order (unique value beginning with 1 for the corresponding table, which is obtained by adding 1 to the partitioning condition specification order)
4	TABLE_ID	INTEGER	Table ID
5	DCOND	CHAR(2)	Partitioning condition code The partitioning storage condition value is stored in character format; the storable values are =, ^=, <, <=, >, and >=; if <> or != is specified, it is stored as ^=. For a matrix-partitioned table, <= is stored. Nothing is stored if no partitioning storage condition is specified or if hash partitioning is specified.
6	DCVALUES	VARCHAR(256) or MVARCHAR(256)	Partitioning condition value The value to be stored is not converted even if a character set is specified for a partitioning key. Null value if no partitioning storage condition is specified or if hash partitioning is specified.
7	RDAREA_NAME	VARCHAR(30) or MVARCHAR(30)	Name of storage RDAREA
8	DCVALUES2	VARCHAR(255) or MVARCHAR(255)	Second dimension key partitioning condition value (The storage format is the same as that for DCVALUES.) Null value for a table that is not a matrix-partitioned table and for a matrix-partitioned table for which no boundary value is specified.

This table manages index column information. (Each row describes information on one index.)

The following table shows the contents of the SQL_INDEX_COLINF table.

Table G-14 SQL_INDEX_COLINF table contents

Number	Column name	Data type	Contents
1	TABLE_SCHEMA	VARCHAR(30) or MVARCHAR(30)	Table owner
2	TABLE_NAME	VARCHAR(30) or MVARCHAR(30)	Name of the table that contains an index
3	INDEX_NAME	VARCHAR(30) or MVARCHAR(30)	Index name
4	INDEX_ID	INTEGER	Index ID
5	INDEX_ORDER	INTEGER	Order of columns comprising the index (integer beginning with 1, which identifies the name order of columns comprising the index)
6	COLUMN_NAME	VARCHAR(30) or MVARCHAR(30)	Column name (name of columns comprising the index)
7	ASC_DESC	CHAR(1)	Ascending or descending order: A: Ascending order D: Descending order Empty: (for plug-in indexes) (If descending order is specified for a single-column index, it is stored as ascending order.)

This table manages index partitioning information (partitioning conditions and names of storage RDAREAs specified by CREATE TABLE). (Each row describes information on one index.)

The following table shows the contents of the SQL_DIV_INDEX table.

Table G-15 SQL_DIV_INDEX table contents

Number	Column name	Data type	Contents
1	TABLE_SCHEMA	VARCHAR(30) or MVARCHAR(30)	Table owner
2	TABLE_NAME	VARCHAR(30) or MVARCHAR(30)	Name of the table that contains an index
3	INDEX_NAME	VARCHAR(30) or MVARCHAR(30)	Index name
4	DIV_NO	INTEGER	RDAREA definition order (unique value beginning with 1 for the corresponding index which is obtained by adding 1 to the RDAREA definition order)#
5	INDEX_ID	INTEGER	Index ID
6	RDAREA_NAME	VARCHAR(30) or MVARCHAR(30)	Name of partitioned storage RDAREA comprising the index)

#: This value is not related to DIV_NO of SQL_DIV_TABLE.

This table manages BLOB-type column partitioning information (name of storage RDAREA specified by CREATE TABLE). (Each row describes information on one column.)

The following table shows the contents of the SQL_DIV_COLUMN table.

Table G-16 SQL_DIV_COLUMN table contents

Number	Column name	Data type	Contents
1	TABLE_SCHEMA	VARCHAR(30) or MVARCHAR(30)	Table owner
2	TABLE_NAME	VARCHAR(30) or MVARCHAR(30)	Table name
3	COLUMN_NAME	VARCHAR(30) or MVARCHAR(30)	Column name
4	DIV_NO	INTEGER	Storage order
5	RDAREA_NAME	VARCHAR(30) or MVARCHAR(30)	Name of the user LOB RDAREA
6	STORE_NO	INTEGER	Always 1
7	MASTER_RDAREA_ NAME	VARCHAR(30) or MVARCHAR(30)	Name of user RDAREA for the corresponding table
8	N_LEVEL	SMALLINT	Number of levels Null value for BLOB type columns.
9	COMPONENT_ NAME	VARCHAR(30) or MVARCHAR(30)	Component name Null value for BLOB type columns.
10	LOB_NO	SMALLINT	LOB attribute number Null value for BLOB type columns.

This table manages routine definition information. (Each row describes information on one routine.)

The following table shows the contents of the SQL_ROUTINES table.

Table G-17 SQL_ROUTINES table contents

Number	Column name	Data type	Contents
1	ROUTINE_SCHEMA	VARCHAR(30) or MVARCHAR(30)	Routine owner PUBLIC for public routines
2	ROUTINE_NAME	VARCHAR(30) or MVARCHAR(30)	Routine name#9
3	OBJECT_ID	INTEGER	Object ID
4	SPECIFIC_NAME	VARCHAR(30) or MVARCHAR(30)	Specific name#2
5	ROUTINE_TYPE	CHAR(1)	Routine type: P: Procedure F: Function
6	ROUTINE_VALID	CHAR(1)	Validity flag: Y: Validity routine N: Invalidity routine
7	INDEX_VALID	CHAR(1)	Index status change flag: Y: Index status valid#1 N: Index status invalid#1
8	CREATE_TIME	CHAR(14)	Routine creation date and time (YYYYMMDDHHMMSS) SQL analysis time for SQL procedure statements or definition creation time for external routines
9	ALTER_TIME	CHAR(14)	Routine re-creation date and time (YYYYMMDDHHMMSS) (The initial value is a null value.)
10	OBJECT_SIZE	INTEGER	Object size (in bytes) 0 for external routines
11	SOURCE_SIZE	INTEGER	Definition source size (bytes) 0 for external routines and registry operation procedures
12	ISOLATION_LEVEL	SMALLINT	Data guarantee level (0-2) Valid for procedures
13	OPTIMIZE_LEVEL	INTEGER	SQL optimization option (converted to decimal format) Specifies the value of OPTIMIZE LEVEL for CREATE PROCEDURE, ALTER PROCEDURE, CREATE TYPE, or ALTER ROUTINE.
14	SQL_LEVEL	SMALLINT	SQL level (0-2) Valid for procedures
15	N_PARAM	INTEGER	Number of parameters
16	N_RESOURCE	INTEGER	Number of resources used in an object
17	PARAM_LOCATION	INTEGER	Start position of a procedure statement in a definition source statement.#7
18	ROUTINE_ COMMENT	VARCHAR(255) or MVARCHAR(255)	Comment (The initial value is a null value.)
19	DEF_SOURCE	BLOB	Definition source statement (not including compiler options) Null value for a system definition function, for a registry operation procedure, and for a trigger action procedure.
20	ROUTINE_ADT_OWNER	VARCHAR(30)	Owner of the abstract data type that defined routines Null value for a routine that is not defined in an abstract data type.
21	ROUTINE_ADT_NAME	VARCHAR(30)	Name of the abstract data type that defined routines Null value for a routine that is not defined in an abstract data type.
22	ROUTINE_BODY	CHAR(1)	Function routine type: S: SQL procedure E: External routine T: Trigger action procedure Null value for a procedure (excluding a trigger action procedures) that is not a foreign routine.
23	FUNCTION_TYPE	CHAR(1)	Function type: C: System-defined function constructor Empty: User-defined function Null value for a procedure.
24	EXTERNAL_NAME	VARCHAR(255)	External routine name (library-name ! operation-name) or a Java method name if defined in Java Null value if this is not for an external stored routine.
25	EXTERNAL_LANGUAGE	CHAR(20)	External descriptive language type: C: C language Java: Java language Null value if this is not for an external stored routine.
26	PARAMETER_STYLE	VARCHAR(20)	Parameter style (external stored routine type) PLUGIN: Plug-in RDSQL: RDSQL Java: Java Null value if this is not for an external stored routine.
27	ENCAPSULATION_ LEVEL	VARCHAR(10)	Encapsulation level (PUBLIC, PRIVATE, or PROTECTED) Null value for a routine that is not defined in an abstract data type.
28	RETURN_UDT_OWNER	VARCHAR(30) or MVARCHAR(30)	Owner of a return value data type Null value if the return value is not a user-defined function.
29	RETURN_UDT_NAME	VARCHAR(30) or MVARCHAR(30)	Name of a return value data type Null value if the return value is not a user-defined function.
30	RETURN_UDT_TYPE_ ID	INTEGER	ID of a return value data type Null value if the return value is not a user-defined function.
31	RETURN_DATA_TYPE	CHAR(24)	Return value data type For details about the storage format, see the DATA_TYPE column in the SQL_COLUMNS table. Null value if the return value data type is not a function.
32	RETURN_DATA_TYPE _CODE	SMALLINT	Code for a return value data type For details about the storage format, see the DATA_TYPE_CODE column in the SQL_COLUMNS table. Null value if the return value data type is not a function.
33	RETURN_DATA_ LENGTH_CODE	SMALLINT	Code for a return value data length#3 Null value for a procedure.
34	RETURN_DATA_ LENGTH	CHAR(7)	Return value data length stored right-justified in character format (spaces are used for leading zeros) Null value for a procedure.
35	RETURN_LOB_ LENGTH_CODE	CHAR(8)	Code for a return value BLOB data length#4, #8 Null value for a procedure or if the return value is not a BLOB or BINARY function.
36	RETURN_LOB_ LENGTH	CHAR(20)	Specification value of a return value BLOB data length Right-justified in character format (spaces are used for leading zeros) Null value for a procedure or if the return value is not a BLOB or BINARY function.
37	RETURN_LOB_ LENGTH_TYPE	CHAR(1)	Type of a return value BLOB data length: K: K specified M: M specified G: G specified Empty: Default Null value for a procedure or if the return value is not a BLOB or BINARY function.
38	ADDITIONAL_ OPTIMIZE_LEVEL	INTEGER	Extended SQL optimization option (converted to decimal format) Specifies the value of ADD OPTIMIZE LEVEL for CREATE PROCEDURE, ALTER PROCEDURE, CREATE TYPE, or ALTER ROUTINE. Null value if the routine was created by HiRDB of version 06-00 or earlier.
39	CLASS_NAME	VARCHAR(255)	package-name.class-name#5 Null value if the foreign routine is not coded in Java.
40	JAR_NAME	VARCHAR(255)	Java archive file name Null value if the foreign routine is not coded in Java.
41	DYNAMIC_RESULT_ SETS	SMALLINT	Maximum number of result sets to be returned Null value if no maximum number is specified for the result sets.
42	SQL_ SPECIFICATION	CHAR(1)	Information used by the system
43	RETURNS_JAVA_ DATA_TYPE	VARCHAR(255)	Java return value's data type corresponding to return value's data type#6 Null value if the foreign routine is not coded in Java.
44	RETURNS_JAVA_ DATA_TYPE_CODE	INTEGER	Java return value's data type code corresponding to return value's data type#6 Null value if the foreign routine is not coded in Java.
45	RETURN_DATA_ MAX_ELM	SMALLINT	Maximum number of elements for return value's data type Null value if ARRAY is not specified for the return value data type.
46	N_JAVA_RESULT_ SETS	INTEGER	Number of java.sql.ResultSet[]s specified Null value if java.sql.ResultSet[] is not specified.
47	FOR_UPDATE_EXCLUSIVE_LOCK	CHAR(1)	Whether ISOLATION LEVEL is a value other than 2 and FOR UPDATE EXCLUSIVE is specified Y: Yes Null value: No Null value for a routine created with a HiRDB version earlier than 07-01, if FOR UPDATE EXCLUSIVE has not been specified, or if the ISOLATION LEVEL value is 2.
48	SUBSTR_LENGTH	SMALLINT	Specification value of SUBSTR LENGTH of the SQL compile option Null value for a routine created with a HiRDB version earlier than 08-00 or when the character code type is not Unicode (UTF-8).
49	RETCSET_SCHEMA	VARCHAR(30) or MVARCHAR(30)	Character set owner for the data type of return value (always MASTER) Null value if no character set is specified for the data type of the return value.
50	RETCSET_NAME	VARCHAR(30) or MVARCHAR(30)	Character set name for the data type of the return value: EBCDIK: EBCDIK is specified for the character set. UTF16: UTF16 is specified for the character set. Null value if no character set is specified for the data type of the return value.
51	RETCSET_ID	INTEGER	Character set ID for the data type of the return value Null value if no character set is specified for the data type of return value. For details about character set IDs, see the HiRDB Version 9 Installation and Design Guide.
52	ROUTINE_CREATOR	VARCHAR(30) or MVARCHAR(30)	User who defined the public routine Null value if the routine is not a public routine

#1: Index information in the routine is invalid (the routine cannot be executed). In this case, SQL objects must be re-created by ALTER ROUTINE or ALTER PROCEDURE.

#2: For procedures, this name is the same as the routine name; for functions, the system internally generates a name from the routine name and object ID as follows:

F routine name (up to 19 bytes) object ID (10 bytes)

#3: For the DECIMAL, INTERVAL YEAR TO DAY, and INTERVAL HOUR TO SECOND types, precision and scale are each stored in 1 byte. In all other cases, size (number of characters for the NCHAR and NVARCHAR types) is stored in the 2-byte binary format. Note that the value is 0 for the BLOB and abstract data types.

#4: The specified column length is stored in binary format in 8 bytes, divided into 4-byte segments.

#5: The following shows the storage format for package-name.class-name:

• Package name specified
  package-name.class-name
  
• Package name not specified
  class-name
  

#6: The following Java data types are stored as a character string in RETURN_JAVA_DATA_TYPE. The Java data types expressed in hexadecimal numbers are stored in RETURN_JAVA_DATA_TYPE_CODE.

Java data type	Value in hexadecimal
byte[]	1000
byte[][]	100A
short	1002
short[]	1003
int	1004
int[]	1005
float	1006
float[]	1007
double	1008
double[]	1009
java.match.BigDecimal	2000
java.match.BigDecimal[]	2001
java.lang.String	2002
java.lang.String[]	2003
java.sql.Date	2004
java.sql.Date[]	2005
java.sql.Time	2006
java.sql.Time[]	2007
java.lang.Double	2008
java.lang.Double[]	2009
java.lang.Float	200A
java.lang.Float[]	200B
java.lang.Integer	200C
java.lang.Integer[]	200D
java.lang.Short	200E
java.lang.Short[]	200F
java.sql.Timestamp	2010
java.sql.Timestamp[]	2011
void	0000

#7: The location at which the procedure statement starts is counted from the top of the SQL statement, beginning at 1. For an external routine (Java stored routine), the location at which the external routine specification (EXTERNAL NAME clause) starts is counted from the beginning of the SQL statement. A value of 0 is set for the following:

• External routine (excluding Java stored routines)
• Registry manipulation procedure
• Trigger action procedure

#8: SQL results are not subject to endian conversion, even for connection modes with different endians. Therefore, applications must handle the endian.

#9: For a trigger action procedure, the following routine name (22 bytes long) is stored:

'(TRIGyyyymmddhhmmssth)'

yyyymmddhhmmssth: Time stamp at the time of trigger definition (units: 1/100 seconds)

This table manages resource information used in routines. (n rows describe information on one routine.)

The following table shows the contents of the SQL_ROUTINE_RESOURCES table.

Table G-18 SQL_ROUTINE_RESOURCES table contents

Number	Column name	Data type	Contents
1	ROUTINE_SCHEMA	VARCHAR(30) or MVARCHAR(30)	Routine owner PUBLIC for public routines
2	ROUTINE_NAME	VARCHAR(30) or MVARCHAR(30)	Routine name
3	SPECIFIC_NAME	VARCHAR(30) or MVARCHAR(30)	Specific name#1
4	BASE_OWNER	VARCHAR(30) or MVARCHAR(30)	Resource owner or PUBLIC for a public view table or a public routine
5	BASE_NAME	VARCHAR(30) or MVARCHAR(30)	Resource identifier
6	BASE_TYPE	CHAR(1)	Resource type: R: Base table V: View table that can be updated U: Read-only view table I: Index D: Data type P: Routine T: Trigger Q: Sequence generator
7	ROUTINE_TYPE_OWNER	VARCHAR(30) or MVARCHAR(30)	Owner of abstract data type for routine defined in abstract data type Null value for routines that are not defined in an abstract data type.
8	ROUTINE_TYPE_NAME	VARCHAR(30) or MVARCHAR(30)	Name of abstract data type for routine defined in abstract data type Null value for routines that are not defined in an abstract data type.
9	SELECT_OPERATION#2	CHAR(1)	Retrieval target specification status: Y: Specified Null value: Not specified Null value if the type of resource used is not R or V.#3
10	INSERT_OPERATION#2	CHAR(1)	Data insertion target status: Y: Specified Null value: Not specified Null value if the type of resource used is not R or V.#3
11	UPDATE_OPERATION#2	CHAR(1)	Data update target status: Y: Specified Null value: Not specified Null value if the type of resource used is not R or V.#3
12	DELETE_OPERATION#2	CHAR(1)	Data deletion target status: Y: Specified Null value: Not specified Null value if the type of resource used is not R or V.#3
13	LOCK_OPERATION#2	CHAR(1)	Data insertion target status: Y: Specified Null value: Not specified Null value if the type of resource used is not R or V.#3
14	PURGE_OPERATION#2	CHAR(1)	Whether or not a data deletion target is specified in a PURGE TABLE statement: Y: Specified Null value: Not specified Null value if the type of resource used is not R or V.#3
15	BASE_ROUTINE_CREATOR	VARCHAR(30) or MVARCHAR(30)	User who defined a public routine if the resource to be used is the public routine Null value if the resource to be used is not a public routine
16	ROUTINE_CREATOR	VARCHAR(30) or MVARCHAR(30)	User who defined the public routine. Null value if this is not for a public routine.

#1: For procedures, this name is the same as the routine name; for functions, the system internally generates a name from the routine name and object ID as follows:

'F' routine name (up to 19 bytes) object ID (10 bytes)

#2: If a view table is used as an SQL object, information that merges the operation types of all view tables being used is set in the base table (the highest order base table if the base table is a view table) that is the base for the view table being used as the SQL object.

#3: If the type of resource being used is a view table (V), a null value is set for a view table that is not actually contained in the SQL object.

This table manages parameter information in routines. (n rows describe information on one routine.)

The following table shows the contents of the SQL_ROUTINE_PARAMS table.

Table G-19 SQL_ROUTINE_PARAMS table contents

Number	Column name	Data type	Contents
1	ROUTINE_SCHEMA	VARCHAR(30) or MVARCHAR(30)	Routine owner PUBLIC for public routines
2	ROUTINE_NAME	VARCHAR(30) or MVARCHAR(30)	Routine name
3	SPECIFIC_NAME	VARCHAR(30) or MVARCHAR(30)	Specific name
4	PARAMETER_NAME	VARCHAR(30) or MVARCHAR(30)	Parameter name#4
5	PARAMETER_NO	INTEGER	Parameter specification sequence (a unique number within the routine beginning with 1)
6	DATA_TYPE	CHAR(24)	Data type For details about the storage format, see the DATA_TYPE column in the SQL_COLUMNS table.
7	DATA_LENGTH	CHAR(7)	Data length stored right-justified in character format (spaces are used for leading zeros) Null value if the data type is BLOB, BINARY, or a user-defined type.
8	LOB_LENGTH	CHAR(20)	Column length specification value right-justified in character format (spaces are used for leading zeros) Null value if the data type is not BLOB or BINARY.
9	LOB_LENGTH_TYPE	CHAR(1)	Column length type: K: K specified M: M specified G: G specified Empty: Default Null value if the data type is not BLOB.
10	PARAMETER_MODE	CHAR(5)	Parameter I/O mode: IN: Input mode NOUT: Output mode INOUT: Input/output mode NONE: Other than above
11	DATA_TYPE_CODE	SMALLINT	Data type code For details about the storage format, see the DATA_TYPE_CODE column of the SQL_COLUMNS table.
12	DATA_LENGTH_CODE	SMALLINT	Data length code#1 Null value if the data type is BLOB, BINARY, or a user-defined type.
13	LOB_LENGTH_CODE	CHAR(8)	Column length specification value#2, #3 Null value if the data type is not BLOB or BINARY.
14	UDT_OWNER	VARCHAR(30) or MVARCHAR(30)	Owner of a data type parameter Null value if the parameter is a system-defined type.
15	UDT_NAME	VARCHAR(30) or MVARCHAR(30)	Name of a data type parameter Null value if the parameter is a system-defined type.
16	UDT_TYPE_ID	INTEGER	ID of a data type parameter Null value if the parameter is a system-defined type.
17	JAVA_DATA_TYPE	VARCHAR(255)	Data type of the corresponding Java parameter For the storage format, see the RETURNS_JAVA_DATA_TYPE column in the SQL_ROUTINES table. Null value if the foreign routine is not coded in Java.
18	JAVA_DATA_TYPE_CODE	INTEGER	Data type code of the corresponding Java parameter For the storage format, see the RETURNS_JAVA_DATA_TYPE_ CODE column in the SQL_ROUTINES table. Null value if the foreign routine is not coded in Java.
19	MAX_ELM	SMALLINT	Maximum number of parameter elements Null value if the number of parameter elements is not specified.
20	TRIGGER_COLUMN	CHAR(1)	Parameter information for the column specified by an old or new values correlation name of the trigger action procedure O: Column referenced by an old values correlation name N: Column referenced by a new values correlation name Null value: Neither of the above Null value if the parameter is not for a trigger action procedure or does not correspond to a column specified by an old or new values correlation name.
21	TRIGGER_TABLE_ID	INTEGER	Table ID that defines the column before it is replaced with a parameter Null value if the ID is not for a trigger action procedure or does not correspond to a column specified by an old or new values correlation name.
22	TRIGGER_COLUMN_NAME	VARCHAR(30) or MVARCHAR(30)	Column name before being replaced with a parameter Null value if the name is not for a trigger action procedure or does not correspond to a column specified by an old or new values correlation name.
23	PARMCSET_SCHEMA	VARCHAR(30) or MVARCHAR(30)	Character set owner for the data type (always MASTER) Null value if no character set is specified for the data type.
24	PARMCSET_NAME	VARCHAR(30) or MVARCHAR(30)	Character set name for the data type: EBCDIK: EBCDIK is specified for the character set. UTF16: UTF16 is specified for the character set. Null value if no character set is specified for the data type.
25	PARMCSET_ID	INTEGER	Character set ID for the data type Null value if no character set is specified for the data type. For details about character set IDs, see the HiRDB Version 9 Installation and Design Guide.

#1: For the DECIMAL, INTERVAL YEAR TO DAY, and INTERVAL HOUR TO SECOND types, precision and scale are each stored in 1 byte. In all other cases, size (number of characters for the NCHAR and NVARCHAR types) is stored in the 2-byte binary format. Note that the value is 0 for the BLOB and abstract data types.

#2: The specified column length is stored in binary format in 8 bytes, divided into 4-byte segments.

#3: SQL results are not subject to endian conversion, even for connection modes with different endians. Therefore, applications must handle the endian.

#4: For a trigger action procedure, the following parameter name (27 bytes long) is used:

'(T#tbl_id#col_id#nnnnn)'

tbl_id

Table ID (hexadecimal, 8 digits (If the number of digits is less than 8, the front portion is zero filled.))

col_id

Column ID (hexadecimal, 8 digits (If the number of digits is less than 8, the front portion is zero filled.))

nnnnn

00001: Parameter that corresponds to a column modified by an old values correlation name

00002: Parameter that corresponds to a column modified by a new values correlation name

This table manages table statistical information. (Each row describes information on one table.)

If there is no statistical information (for example, immediately following CREATE TABLE), the contents of this table are empty.

The following table shows the contents of the SQL_TABLE_STATISTICS table.

Table G-20 SQL_TABLE_STATISTICS table contents

Number	Column name	Data type	Contents
1	TABLE_SCHEMA	VARCHAR(30) or MVARCHAR(30)	Table owner
2	TABLE_NAME	VARCHAR(30) or MVARCHAR(30)	Table name
3	N_PAGE	FLOAT	Number of pages stored (statistical information) Null value if lvll is specified for the -c option of pdgetcst
4	N_ROW	FLOAT	Total number of rows (statistical information)
5	UPDATE_TIME	CHAR(14)	Update date and time (YYYYMMDDHHMMSS)

This table manages column statistical information. (Each row describes information on one column.)

If there is no statistical information (for example, immediately after CREATE TABLE), the contents of this table are empty.

The following table shows the contents of the SQL_COLUMN_STATISTICS table.

Table G-21 SQL_COLUMN_STATISTICS table contents

Number	Column name	Data type	Contents
1	TABLE_SCHEMA	VARCHAR(30) or MVARCHAR(30)	Table owner
2	TABLE_NAME	VARCHAR(30) or MVARCHAR(30)	Name of the table that contains a column
3	COLUMN_NAME	VARCHAR(30) or MVARCHAR(30)	Column name
4	N_UNIQUE	FLOAT	Number of unique values (statistical information)
5	N_MAX_DUP_KEY	FLOAT	Maximum number of duplicate key values (statistical information)
6	N_MIN_DUP_KEY	FLOAT	Minimum number of duplicate key values (statistical information)
7	N_NULL	FLOAT	Number of null values
8	UPDATE_TIME	CHAR(14)	Update date and time (YYYYMMDDHHMMSS)
9	RANGE_VALUES	VARCHAR(2872)	Column value frequency distribution information (statistical information)#

#: The maximum and minimum column values set in the pdgetcst parameter file are stored in the RANGE_VALUES column after being converted into an internal format. To reference these maximum and minimum values, the SQL described as follows must be executed. The retrieval results are displayed in hexadecimal.

• SQL for retrieving the maximum column value

  SELECT HEX(SUBSTR("RANGE_VALUE",33,a))
     FROM "MASTER".SQL_COLUMN_STATISTICS
     WITHOUT LOCK NOWAIT

For a, specify the data length of the column in bytes. If the data is of the character string type, it is truncated to 16 bytes, so a value equal to or less than 16 must be specified.

• SQL for retrieving the minimum column value

When the column's data type is DECIMAL or NUMERIC and the precision is 32 digits or more

 
SELECT HEX(SUBSTR("RANGE_VALUE",33,a))
    FROM "MASTER".SQL_COLUMN_STATISTICS
    WITHOUT LOCK NOWAIT
 

When the column's data type is neither DECIMAL nor NUMERIC

 
SELECT HEX(SUBSTR("RANGE_VALUES"),49,a)
    FROM "MASTER".SQL_COLUMN_STATISTICS
    WITHOUT LOCK NOWAIT
 

For a, specify the data length of the column in bytes. If the data is of the character string type, it is truncated to 16 bytes, so a value equal to or less than 16 must be specified.

Example

Referencing the maximum column value of an INT-type column

SELECT HEX(SUBSTR("RANGE_VALUE"),33,4)
    FROM "MASTER".SQL_COLUMN_STATISTICS
    WITHOUT LOCK NOWAIT

Output result (when maximum column value is 10)

'0000000A'

This table manages index statistical information. (Each row describes information on one index.)

If there is no statistical information (for example, immediately following CREATE TABLE), the contents of this table are empty.

The following table shows the contents of the SQL_INDEX_STATISTICS table.

Table G-22 SQL_INDEX_STATISTICS table contents

Number	Column name	Data type	Contents
1	TABLE_SCHEMA	VARCHAR(30) or MVARCHAR(30)	Table owner
2	TABLE_NAME	VARCHAR(30) or MVARCHAR(30)	Name of the table that contains the index
3	INDEX_NAME	VARCHAR(30) or MVARCHAR(30)	Index name
4	N_ENTRY	FLOAT	Number of key entries (statistical information)
5	N_IXPG	FLOAT	Number of leaf pages (statistical information)
6	N_LEVEL	SMALLINT	Number of levels (statistical information)
7	SEQ_RATIO	INTEGER	Sequential level (statistical information)
8	UPDATE_TIME	CHAR(14)	Update date and time (YYYYMMDDHHMMSS)

This table manages user-defined type information (each row defines information on one user-defined type).

The following table shows the contents of the SQL_DATATYPES table.

Table G-23 SQL_DATATYPES table contents

Number	Column name	Data type	Contents
1	TYPE_SCHEMA	VARCHAR(30) or MVARCHAR(30)	Owner of the user-defined type
2	TYPE_NAME	VARCHAR(30) or MVARCHAR(30)	Name of the user-defined type
3	META_TYPE	CHAR(1)	Type of the user-defined type: A: Abstract data type
4	TYPE_ID	INTEGER	ID of the user-defined type
5	N_ATTR	SMALLINT	Number of attributes
6	CREATE_TIME	CHAR(14)	Creation date and time (YYYYMMDDHHMMSS)
7	N_SUBTYPE	INTEGER	Number of subtypes
8	SOURCE_SCHEMA	VARCHAR(30) or MVARCHAR(30)	Owner of the supertype abstract data type Null value if there is no supertype abstract data type.
9	SOURCE_NAME	VARCHAR(30) or MVARCHAR(30)	Name of the supertype abstract data type Null value if there is no supertype abstract data type.
10	SOURCE_TYPE_ID	INTEGER	ID of the supertype abstract data type Null value if there is no supertype abstract data type.
11	ROOT_TYPE_ID	INTEGER	ID of the highest order abstract data type if the supertype abstract data type also has a supertype
12	LEVEL_NO	SMALLINT	Number of generations from highest order supertype abstract data type if the supertype abstract data type also has a supertype
13	TYPE_COMMENT	VARCHAR(255)	Comment The initial value is a null value. Null value if there is no comment.
14	N_LOB_ATTR	SMALLINT	Number of BLOB-type attributes
15	N_ADT_ATTR	SMALLINT	Number of abstract-data-type attributes
16	N_LARGE_BINARY_ATTR	SMALLINT	Number of attributes for BINARY-type data of 32,001 bytes or more

This table manages user-defined type attribute information. (Each row describes information on one attribute.)

The following table shows the contents of the SQL_DATATYPE_DESCRIPTORS table.

Table G-24 SQL_DATATYPE_DESCRIPTORS table contents

Number	Column name	Data type	Contents
1	TYPE_SCHEMA	VARCHAR(30) or MVARCHAR(30)	Owner of the user-defined type
2	TYPE_NAME	VARCHAR(30) or MVARCHAR(30)	Name of the user-defined type
3	OBJECT_NAME	VARCHAR(30) or MVARCHAR(30)	Attribute name
4	TYPE_ID	INTEGER	ID of the user-defined type
5	META_TYPE	CHAR(1)	Type of the user-defined type: S: System-defined type A: Abstract data type
6	ORDINAL_POSITION	SMALLINT	Order position
7	ENCAPSULATION_ LEVEL	VARCHAR(10)	Encapsulation level (PUBLIC, PRIVATE, or PROTECTED)
8	IS_NULLABLE	CHAR(3)	Column null value information YES: Null value allowed NO: Null values not allowed
9	DATA_TYPE	CHAR(24)	Data type For details about the storage format, see the DATA_TYPE column in the SQL_COLUMNS table.
10	DATA_TYPE_CODE	SMALLINT	Data type code For details of the storage format, see the DATA_TYPE_CODE column of the SQL_COLUMNS table.
11	DATA_LENGTH_CODE	SMALLINT	Data length code#1
12	DATA_LENGTH	CHAR(7)	Data length stored right-justified in character format (spaces are used for leading zeros)
13	LOB_LENGTH_CODE	CHAR(8)	BLOB attribute length code#2, #3 Null value if the code is not for BLOB or BINARY.
14	LOB_LENGTH	CHAR(20)	BLOB attribute length specification value stored right-justified in character format (spaces are used for leading zeros) Null value if the value is not for BLOB or BINARY.
15	LOB_LENGTH_TYPE	CHAR(1)	BLOB attribute length type (unit): K: K specified M: M specified G: G specified Empty: Default Null value if the type is not BLOB.
16	UDT_OWNER	VARCHAR(30) or MVARCHAR(30)	Owner of the abstract data type for an abstract data type attribute that has another abstract data type Null value if the owner is for the system definition type.
17	UDT_NAME	VARCHAR(30) or MVARCHAR(30)	Name of the abstract data type for an abstract data type attribute that has another abstract data type Null value if the name is for the system definition type.
18	DATA_COMMENT	VARCHAR(255)	Comment (The initial value is a null value; null value is also used if there is no comment.)
19	NO_SPLIT	CHAR(1)	Whether or not NO SPLIT is specified: Y: Specified Null value: No specification

#1: For the DECIMAL, INTERVAL YEAR TO DAY, and INTERVAL HOUR TO SECOND types, precision and scale are each stored in 1 byte. In all other cases, size (number of characters for the NCHAR and NVARCHAR types) is stored in the 2-byte binary format. Note that the value is 0 for the BLOB and abstract data types.

#2: The specified column length is stored in binary format in 8 bytes, divided into 4-byte segments.

#3: SQL results are not subject to endian conversion, even for connection modes with different endians. Therefore, applications must handle the endian.

This table manages resource information used in tables. (Each row describes information on one resource.)

The following table shows the contents of the SQL_TABLE_RESOURCES table.

Table G-25 SQL_TABLE_RESOURCES table contents

Number	Column name	Data type	Contents
1	TABLE_SCHEMA	VARCHAR(30) or MVARCHAR(30)	Table owner
2	TABLE_NAME	VARCHAR(30) or MVARCHAR(30)	Table name
3	BASE_OWNER	VARCHAR(30) or MVARCHAR(30)	Owner of the resource used
4	BASE_NAME	VARCHAR(30) or MVARCHAR(30)	ID of the resource used
5	BASE_TYPE	CHAR(1)	Type of the resource used: A: Abstract data type

This table manages plug-in information. (Each row describes information on one plug-in.)

The following table shows the contents of the SQL_PLUGINS table.

Table G-26 SQL_PLUGINS table contents

Number	Column name	Data type	Contents
1	PLUGIN_SCHEMA	VARCHAR(30) or MVARCHAR(30)	Plug-in owner
2	PLUGIN_NAME	VARCHAR(30) or MVARCHAR(30)	Plug-in name
3	PLUGIN_TYPE	CHAR(1)	Plug-in type: D: Data type plug-in I: Index type plug-in
4	TYPE_SCHEMA	VARCHAR(30) or MVARCHAR(30)	Owner of the abstract data type or index type
5	TYPE_NAME	VARCHAR(30) or MVARCHAR(30)	Name of the abstract data type or index type
6	CREATE_TIME	CHAR(14)	Plug-in creation time
7	PLUGIN_LIB_NAME	VARCHAR(255)	Library path name
8	PLUGIN_COMMENT	VARCHAR(255)	Comment The initial value is a null value. Null value if there is no comment.
9	PLUGIN_VERSION	VARCHAR(10)	Plug-in version Null value if the plug-in is the initial version.
10	PLUGIN_EXT_FUNC	VARCHAR(255)	Plug-in extended function code (information used in the system)

This table manages plug-in routine information. (Each row describes information on one plug-in routine.)

The following table shows the contents of the SQL_PLUGIN_ROUTINES table.

Table G-27 SQL_PLUGIN_ROUTINES table contents

Number	Column name	Data type	Contents
1	ROUTINE_SCHEMA	VARCHAR(30) or MVARCHAR(30)	Routine owner
2	PLUGIN_NAME	VARCHAR(30) or MVARCHAR(30)	Plug-in name
3	OPERATION_NAME	VARCHAR(255)	Operation name
4	SPECIFIC_NAME	VARCHAR(30) or MVARCHAR(30)	Specific name#
5	N_PARAM	INTEGER	Number of parameters
6	TIMING_DESCRIPTOR	VARCHAR(30)	Timing descriptor
7	OPERATION_ DESCRIPTOR	VARCHAR(255)	Operation modification information

#: A plug-in routine is named in the following format:

'P' function-name registration-date-and-time

P

Code that indicates a function provided by a plug-in

function-name

The leading characters (maximum 15 characters) are truncated so that the specific name is within 30 characters.

registration-date-and-time

Indicates the year, month, hour, minute, and second with 14 characters.

This table manages plug-in routine parameter information. (Each row describes information on one parameter.)

The following table shows the contents of the SQL_PLUGIN_ROUTINE_PARAMS table.

Table G-28 SQL_PLUGIN_ROUTINE_PARAMS table contents

Number	Column name	Data type	Contents
1	ROUTINE_SCHEMA	VARCHAR(30) or MVARCHAR(30)	Owner
2	PLUGIN_NAME	VARCHAR(30) or MVARCHAR(30)	Plug-in name
3	SPECIFIC_NAME	VARCHAR(30) or MVARCHAR(30)	Specific name
4	PARAMETER_NAME	VARCHAR(30) or MVARCHAR(30)	Parameter name
5	PARAMETER_MODE	CHAR(7)	Parameter I/O attribute: IN: Input mode OUT: Output mode INOUT: Input/output mode RETURNS: Return value attribute PICKUP: ROWID output attribute
6	PARAMETER_ DESCRIPTOR	VARCHAR(255)	Parameter modification information Parameter modification information specified with the plug-in IDL is held as a character string without changes. Null value if no parameter modification information is specified.
7	SPECIFIC_BIND_ OPERATION_NAME	VARCHAR(30) or MVARCHAR(30)	Specific bind operation name Null value if bind operation is not specified.
8	PARAMETER_TYPE	CHAR(1)	Parameter mode: Empty: Normal (data type that can be handled by SQL) I: Indicator N: New data C: Current data D: dbifb K: Index key inf P: Pointer R: rowid U: utlifb T: Pointer These are plug-in specific parameter modes, except normal.
9	PARAMETER_NO	INTEGER	Parameter specification order position for abstract data type functions
10	DATA_TYPE	CHAR(24)	Parameter data type For details about the storage format, see the DATA_TYPE column in the SQL_COLUMNS table. Null value if the parameter mode is D, K, P, R, U, or T.
11	DATA_TYPE_CODE	SMALLINT	Parameter data code Null value if the parameter mode is D, K, P, R, U, or T. For details about the storage format, see the DATA_TYPE_CODE column of the SQL_COLUMNS table.
12	DATA_LENGTH_ CODE	SMALLINT	Parameter data type definition length code#1 Null value if the parameter mode is D, K, P, R, U, or T.
13	DATA_LENGTH	CHAR(7)	Parameter data definition length stored right-justified in character format (spaces are used for leading zeros) Null value if the parameter mode is D, K, P, R, U, or T.
14	LOB_LENGTH_ CODE	CHAR(8)	LOB column length code or BINARY column length code#2, #3 Null value if the parameter mode is normal and the data type is not BLOB or BINARY.
15	LOB_LENGTH	CHAR(20)	LOB column length specification value or BINARY column length specification value Stored in the character format, right-justified (higher-order 0s are left as spaces). Null value if the parameter mode is normal and the data type is not BLOB or BINARY.
16	LOB_LENGTH_TYPE	CHAR(1)	LOB column length type (unit): K: K specified M: M specified G: G specified Empty: Default Null value if the parameter mode is normal and the data type is not BLOB or BINARY.
17	UDT_OWNER	VARCHAR(30) or MVARCHAR(30)	Parameter data type owner Null value if the data type is not a user-defined type.
18	UDT_NAME	VARCHAR(30) or MVARCHAR(30)	Parameter data type name Null value if the data type is not a user-defined type.
19	UDT_TYPE_ID	INTEGER	Parameter data type ID Null value if the data type is not a user-defined type.

#1: For the DECIMAL, INTERVAL YEAR TO DAY, and INTERVAL HOUR TO SECOND types, precision and scale are each stored in 1 byte. In all other cases, size (number of characters for the NCHAR and NVARCHAR types) is stored in the 2-byte binary format. Note that the value is 0 for the BLOB and abstract data types.

#2: The specified column length is stored in binary format in 8 bytes, divided into 4-byte segments.

#3: SQL results are not subject to endian conversion, even for connection modes with different endians. Therefore, applications must handle the endian.

This table manages index type information. (Each row describes information on one index type.)

The following table shows the contents of the SQL_INDEX_TYPES table.

Table G-29 SQL_INDEX_TYPES table contents

Number	Column name	Data type	Contents
1	INDEX_TYPE_ SCHEMA	VARCHAR(30) or MVARCHAR(30)	Index type owner
2	INDEX_TYPE_NAME	VARCHAR(30) or MVARCHAR(30)	Index type name
3	INDEX_TYPE_ID	INTEGER	Index type ID
4	CREATE_TIME	CHAR(14)	Creation time
5	ADT_OWNER	VARCHAR(30) or MVARCHAR(30)	Abstract data type owner
6	ADT_NAME	VARCHAR(30) or MVARCHAR(30)	Abstract data type name
7	N_FUNCTION	INTEGER	Number of abstract data type functions that can be used in an index-type-defined index

This table manages resource information used in indexes. (Each row describes information on one resource.)

The following table shows the contents of the SQL_INDEX_RESOURCES table.

Table G-30 SQL_INDEX_RESOURCES table contents

Number	Column name	Data type	Contents
1	TABLE_SCHEMA	VARCHAR(30) or MVARCHAR(30)	Owner of the index definition table
2	INDEX_NAME	VARCHAR(30) or MVARCHAR(30)	Index name
3	BASE_OWNER	VARCHAR(30) or MVARCHAR(30)	Owner of the resource used
4	BASE_NAME	VARCHAR(30) or MVARCHAR(30)	ID of the resource used
5	BASE_TYPE	CHAR(1)	Type of the resource used: I: Index type

This table manages target item information in indexes. (Each row describes information on one target item (one level).)

The following table shows the contents of the SQL_INDEX_DATATYPE table.

Table G-31 SQL_INDEX_DATATYPE table contents

Number	Column name	Data type	Contents
1	TABLE_SCHEMA	VARCHAR(30) or MVARCHAR(30)	Table owner
2	TABLE_NAME	VARCHAR(30) or MVARCHAR(30)	Name of the table that contains the index
3	INDEX_NAME	VARCHAR(30) or MVARCHAR(30)	Index name
4	INDEX_ID	INTEGER	Index ID
5	COLUMN_NAME	VARCHAR(30) or MVARCHAR(30)	Column name (index column name)
6	N_LEVEL	SMALLINT	Number of levels (number used to identify the name order of attributes constituting an abstract data type)
7	ADT_OWNER	VARCHAR(30) or MVARCHAR(30)	Owner of the abstract data type
8	ADT_NAME	VARCHAR(30) or MVARCHAR(30)	Name of the abstract data type
9	ADT_ATTR_NAME	VARCHAR(30) or MVARCHAR(30)	Name of the abstract data type attribute
10	ADT_ATTR_ID	SMALLINT	Attribute position

This table manages abstract data type function information used in indexes. (Each row describes information on one abstract data type function.)

The following table shows the contents of the SQL_INDEX_FUNCTION table.

Table G-32 SQL_INDEX_FUNCTION table contents

Number	Column name	Data type	Contents
1	TABLE_SCHEMA	VARCHAR(30) or MVARCHAR(30)	Table owner
2	TABLE_NAME	VARCHAR(30) or MVARCHAR(30)	Name of the table that contains the index
3	INDEX_NAME	VARCHAR(30) or MVARCHAR(30)	Index name
4	INDEX_ID	INTEGER	Index ID
5	COLUMN_NAME	VARCHAR(30) or MVARCHAR(30)	Column name (index column name)
6	ADT_OWNER	VARCHAR(30) or MVARCHAR(30)	Owner name of the abstract data type function
7	ADT_FUNCTION_ NAME	VARCHAR(30) or MVARCHAR(30)	Name of the abstract data type function (routine name)
8	ADT_FUNCTION_ OBJECT_ID	INTEGER	Object ID of the abstract data type function

This table manages resource information used in user-defined types. (Each row describes information on one resource.)

The following table shows the contents of the SQL_TYPE_RESOURCES table.

Table G-33 SQL_TYPE_RESOURCES table contents

Number	Column name	Data type	Contents
1	TYPE_SCHEMA	VARCHAR(30) or MVARCHAR(30)	User-defined type owner
2	TYPE_NAME	VARCHAR(30) or MVARCHAR(30)	User-defined type name
3	BASE_OWNER	VARCHAR(30) or MVARCHAR(30)	Owner of the resource used
4	BASE_NAME	VARCHAR(30) or MVARCHAR(30)	ID of the resource used
5	BASE_TYPE	CHAR(1)	ID of the resource used A: Abstract data type

This table manages abstract data type function information that can be used in an index that defines index types. (Each row describes information on one index type.)

The following table shows the contents of the SQL_INDEX_TYPE_FUNCTION table.

Table G-34 SQL_INDEX_TYPE_FUNCTION table contents

Number	Column name	Data type	Contents
1	INDEX_TYPE_ SCHEMA	VARCHAR(30) or MVARCHAR(30)	Index type owner
2	INDEX_TYPE_NAME	VARCHAR(30) or MVARCHAR(30)	Index name
3	ADT_OWNER	VARCHAR(30) or MVARCHAR(30)	Owner of the abstract data type function
4	ADT_FUNCTION_ NAME	VARCHAR(30) or MVARCHAR(30)	ID of the abstract data type function#
5	ADT_FUNCTION_ OBJECT_ID	INTEGER	Object ID of the abstract data type function

#: This is not a specific name.

This table manages index exclusion key value information. (Each row describes information on the exclusion key group for one index.) This table manages one exclusion key value (exclusion value group for multicolumn indexes) in each row.

The following table shows the contents of the SQL_EXCEPT table.

Table G-35 SQL_EXCEPT table contents

Number	Column name	Data type	Contents
1	TABLE_SCHEMA	VARCHAR(30) or MVARCHAR(30)	Index owner
2	TABLE_NAME	VARCHAR(30) or MVARCHAR(30)	Name of the table that contains the index
3	INDEX_NAME	VARCHAR(30) or MVARCHAR(30)	Index name
4	INDEX_ID	INTEGER	Index ID
5	TABLE_ID	INTEGER	Table ID
6	EXCEPT_VALUE	VARCHAR(573) or MVARCHAR(573)	Contents of the exclusion key value The specified values for each column are delimited with a comma in a character format. The initial value is a null value.

This table manages the generation information of HiRDB file system areas when the inner replica facility is used. (Each row describes information on one HiRDB file system area.)

If the HiRDB Staticizer Option is not installed, this table is empty. However, if a database is created with HiRDB Staticizer Option installed, and then HiRDB Staticizer Option is removed, any data set in the table remains.

The following table shows the contents of the SQL_IOS_GENERATIONS table.

Table G-36 SQL_IOS_GENERATIONS table contents

Number	Column name	Data type	Contents
1	FILE_SYSTEM_NAME	VARCHAR(165)	HiRDB file system area name (absolute path name)
2	GENERATION_NUMBER	SMALLINT	Generation number
3	SERVER_NAME	CHAR(8)	Server name (BES or SDS)#
4	ORIGINAL_FILE_SYSTEM_NAME	VARCHAR(165)	Original HiRDB file system area name (absolute path name)

#: Even when a dictionary table of a HiRDB/Parallel Server is used in a HiRDB/Single Server without any modification, the server name is not changed.

If the name is less than 8 characters when left justified, the remaining spaces are filled with spaces.

This table manages the information of the triggers that are inside a schema. (Each row describes information on one trigger.)

The following table shows the contents of the SQL_TRIGGERS table.

Table G-37 SQL_TRIGGERS table contents

Number	Column name	Data type	Contents
1	TRIGGER_SCHEMA	VARCHAR(30) or MVARCHAR(30)	Trigger owner
2	TRIGGER_NAME	VARCHAR(30) or MVARCHAR(30)	Trigger name
3	OBJECT_ID	INTEGER	Object ID
4	TABLE_SCHEMA	VARCHAR(30) or MVARCHAR(30)	Owner of the table for which the trigger is defined.
5	TABLE_NAME	VARCHAR(30) or MVARCHAR(30)	Name of the table for which the trigger is defined.
6	TRIGGER_VALID	CHAR(1)	Trigger-enabling flag Y: Enabled N: Disabled Same value as the ROUTINE_VALID column of the SQL_ROUTINES table for the trigger action procedure
7	INDEX_VALID	CHAR(1)	Index-enabling flag Y: Enabled N: Disabled Same value as the INDEX_VALID column of the SQL_ROUTINES table for the trigger action procedure
8	ACTION_TIME	CHAR(1)	Trigger action timing A: AFTER B: BEFORE
9	EVENT	CHAR(1)	Trigger event type I: INSERT D: DELETE U: UPDATE
10	ACTION_TYPE	CHAR(1)	Trigger action unit R: ROW S: STATEMENT
11	OLD_ROW_NAME	VARCHAR(30) or MVARCHAR(30)	Old values correlation name (correlation name specified in OLD ROW) Null value if OLD ROW is not specified.
12	NEW_ROW_NAME	VARCHAR(30) or MVARCHAR(30)	New values correlation name (correlation name specified in NEW ROW) Null value if NEW ROW is not specified.
13	CREATE_TIME	VARCHAR(16)	Trigger definition creation time
14	ALTER_TIME	CHAR(14)	Trigger SQL object re-creation time Same value as the ALTER_TIME column of the SQL_ROUTINES table for the trigger action procedure Null value if a trigger SQL object is not re-created.
15	DEF_SOURCE_LEN	INTEGER	Trigger definition source length
16	SPECIFIC_NAME	VARCHAR(30) or MVARCHAR(30)	Specific name of the trigger action procedure
17	N_UPDATE_COLUMNS	SMALLINT	Number of trigger event columns Null value for an UPDATE trigger for which no INSERT trigger, DELETE trigger, or trigger event column is specified.
18	REFERENCING_TABLE_ID	INTEGER	Table ID of the referencing table Null value for a trigger that is not created by a referential constraint action.
19	REFERENCE_ACTION	CHAR(2)	Referential constraint operation type DC: ON DELETE CASCADE UC: ON UPDATE CASCADE Null value for a trigger that is not created by a referential constraint action.
20	CONSTRAINT_NAME	VARCHAR(30) or MVARCHAR(30)	Constraint name of referential trigger Null value for a trigger that is not created by a referential constraint action.

This table manages the list information of UPDATE trigger event columns. (Each row describes information on one trigger column.)

The following table shows the contents of the SQL_TRIGGER_COLUMNS table.

Table G-38 SQL_TRIGGER_COLUMNS table contents

Number	Column name	Data type	Contents
1	TRIGGER_SCHEMA	VARCHAR(30) or MVARCHAR(30)	Trigger owner
2	TRIGGER_NAME	VARCHAR(30) or MVARCHAR(30)	Trigger name
3	TABLE_SCHEMA	VARCHAR(30) or MVARCHAR(30)	Owner of the table for which the trigger is defined.
4	TABLE_NAME	VARCHAR(30) or MVARCHAR(30)	Name of the table for which the trigger is defined.
5	COLUMN_NAME	VARCHAR(30) or MVARCHAR(30)	Column name specified for the column list
6	TABLE_ID	INTEGER	ID of the table for which the trigger is defined.

This table manages the source information of trigger definitions. (Each row describes information on one trigger definition source.)

The following table shows the contents of the SQL_TRIGGER_DEF_SOURCE table.

Table G-39 SQL_TRIGGER_DEF_SOURCE table contents

Number	Column name	Data type	Contents
1	TRIGGER_SCHEMA	VARCHAR(30) or MVARCHAR(30)	Trigger owner
2	TRIGGER_NAME	VARCHAR(30) or MVARCHAR(30)	Trigger name
3	TABLE_SCHEMA	VARCHAR(30) or MVARCHAR(30)	Owner of the table for which the trigger is defined.
4	TABLE_NAME	VARCHAR(30) or MVARCHAR(30)	Name of the table for which the trigger is defined.
5	SOURCE_NO	INTEGER	Definition source serial number
6	DEF_SOURCE	VARCHAR(32000) or MVARCHAR(32000)	Definition source (excluding SQL compile options and WITH PROGRAM)

This table manages the resource information being referenced inside trigger action conditions. (Each row describes information on one resource name being referenced in a trigger action condition.)

The following table shows the contents of the SQL_TRIGGER_USAGE table.

Table G-40 SQL_TRIGGER_USAGE table contents

Number	Column name	Data type	Contents
1	TRIGGER_SCHEMA	VARCHAR(30) or MVARCHAR(30)	Trigger owner
2	TRIGGER_NAME	VARCHAR(30) or MVARCHAR(30)	Trigger name
3	TABLE_SCHEMA	VARCHAR(30) or MVARCHAR(30)	Owner of the table for which the trigger is defined.
4	TABLE_NAME	VARCHAR(30) or MVARCHAR(30)	Name of the table for which the trigger is defined.
5	BASE_SCHEMA	VARCHAR(30) or MVARCHAR(30)	Owner of the resource being used PUBLIC for public routines
6	BASE_TABLE	VARCHAR(30) or MVARCHAR(30)	Table name of the resource being used Null value if the type of the resource being used is F (function).
7	BASE_NAME	VARCHAR(30) or MVARCHAR(30)	Name of the resource being used (specific name or column name)
8	BASE_TYPE	CHAR(1)	Type of resource being used F: Function C: Column name
9	TABLE_ID	INTEGER	Table ID Null value if the type of the resource being used is F (function).
10	BASE_ID	INTEGER	ID of the resource being used (object ID or column ID)
11	BASE_ROUTINE_CREATOR	VARCHAR(30) or MVARCHAR(30)	User who defined a public function if the resource being used is a public function Null value if the resource being used is not a public function.

This table manages the partitioning key information of matrix-partitioned tables. (Each row describes information on one partitioning key.)

If HiRDB Advanced High Availability is not installed, this table is empty. However, if HiRDB Advanced High Availability is installed and a database is created, and then HiRDB Advanced High Availability is removed afterwards, the data in the table remains.

The following table shows the contents of the SQL_PARTKEY table.

Table G-41 SQL_PARTKEY table contents

Number	Column name	Data type	Contents
1	TABLE_SCHEMA	VARCHAR(30) or MVARCHAR(30)	Table owner
2	TABLE_NAME	VARCHAR(30) or MVARCHAR(30)	Table name
3	KEY_NO	SMALLINT	Partitioning key number (dimension number 1 or 2)
4	KEY_NAME	VARCHAR(30) or MVARCHAR(30)	Partitioning key column name
5	COLUMN_ID	SMALLINT	Partitioning key column ID
6	N_DIVISION	SMALLINT	Number of divisions inside the key
7	HASH_KEY_NO	SMALLINT	Sequence number in hash key column Null value for dimensions of boundary value partitioning.

This table manages the information on the partitioning condition values for a matrix-partitioned table. (Each row describes information on one partitioning condition value.)

If HiRDB Advanced High Availability is not installed, this table is empty. However, if HiRDB Advanced High Availability is installed and a database is created, and then HiRDB Advanced High Availability is removed afterwards, the data in the table remains.

The following table shows the contents of the SQL_PARTKEY_DIVISION table.

Table G-42 SQL_PARTKEY_DIVISION table contents

Number	Column name	Data type	Contents
1	TABLE_SCHEMA	VARCHAR(30) or MVARCHAR(30)	Table owner
2	TABLE_NAME	VARCHAR(30) or MVARCHAR(30)	Table name
3	KEY_NO	SMALLINT	Partitioning key number (dimension number 1 or 2)
4	IN_DIM_NO	SMALLINT	Serial number inside a partitioning key
5	DCVALUES	VARCHAR(255) or MVARCHAR(255)	Partitioning condition value (the specified partitioning condition value is stored in the character format). The value to be stored is not converted even if a character set is specified for a partitioning key. Null value for the last boundary value within a partitioning key and for dimensions of hash partitioning.

This table manages audit target information. (Each row describes information on one event for one object or user.)

The following table shows the contents of the SQL_AUDITS table.

Table G-43 SQL_AUDITS table contents

Number	Column name	Data type	Contents
1	EVENT_TYPE	VARCHAR(30)	Name of the event type#1 specified by the CREATE AUDIT FOR operation type or 'ANY'.
2	EVENT_SUBTYPE	VARCHAR(30)	Event sub-type name#2 or 'ANY' Null value if CREATE AUDIT FOR ANY is specified.
3	OBJECT_TYPE	VARCHAR(30)	Type of object specified by the CREATE AUDIT selection option.#3 Null value if no object is specified or if the HiRDB version is earlier than 07-03.
4	OBJECT_SCHEMA	VARCHAR(30) or MVARCHAR(30)	Owner of object specified by the CREATE AUDIT selection option. Null value if no object is specified or if the HiRDB version is earlier than 07-03.
5	OBJECT_NAME	VARCHAR(30) or MVARCHAR(30)	Name of object specified by the CREATE AUDIT selection option. Null value if no object is specified or if the HiRDB version is earlier than 07-03.
6	USER_NAME	VARCHAR(30) or MVARCHAR(30)	Authorization identifier of event executor (null value).
7	ANY_VALID	CHAR(1)	Whether or not CREATE AUDIT WHENEVER ANY is specified: Y: Specified N: Not specified
8	SUCCESSFUL_VALID	CHAR(1)	Whether or not CREATE AUDIT WHENEVER SUCCESSFUL is specified: Y: Specified N: Not specified
9	UNSUCCESSFUL_ANY_VALID	CHAR(1)	Whether or not CREATE AUDIT WHENEVER UNSUCCESSFUL is specified: Y: Specified N: Not specified
10	AUDIT_TYPE	CHAR(1)	Acquisition information type: E: CREATE AUDIT AUDITTYPE EVENT is specified A: CREATE AUDIT AUDITTYPE ANY is specified Null value: CREATE AUDIT AUDITTYPE PRIVILEGE is specified or AUDITTYPE is omitted.

#1: The following event types are available:

SESSION, PRIVILEGE, DEFINITION, ACCESS, and UTILITY

#2: The following event sub-types are available:

CONNECT, AUTHORIZATION, DISCONNECT, GRANT, REVOKE, CREATE, DROP, ALTER, SELECT, INSERT, UPDATE, DELETE, PURGE, CALL, OPEN, LOCK, PDLOAD, PDRORG, and PDEXP

#3: The following object types are available:

FUNCTION, INDEX, PROCEDURE, SCHEMA, SERVER, TABLE, TRIGGER, DATA TYPE, VIEW, LIST, COMMENT, and SEQUENCE

This table manages the corresponding conditions of referential constraints. (Each row describes information on one constraint.)

The following table shows the contents of the SQL_REFERENTIAL_CONSTRAINTS table.

Table G-44 SQL_REFERENTIAL_CONSTRAINTS table contents

Number	Column name	Data type	Contents
1	CONSTRAINT_NAME	VARCHAR(30) or MVARCHAR(30)	Constraint name
2	CONSTRAINT_SCHEMA	VARCHAR(30) or MVARCHAR(30)	Constraint owner
3	TABLE_NAME	VARCHAR(30) or MVARCHAR(30)	Name of the table for which the constraint is defined
4	TABLE_SCHEMA	VARCHAR(30) or MVARCHAR(30)	Owner of the table for which the constraint is defined
5	COLUMN_COUNT	SMALLINT	Number of columns in the foreign key
6	COLUMN_NAME	VARCHAR(527) or MVARCHAR(527)	Column names of the table containing the foreign key Enclose each column in quotation marks and link the columns with commas.
7	COLUMN_NO	VARCHAR(32)	Column IDs (16 IDs) of the table containing the foreign key#
8	R_OWNER	VARCHAR(30) or MVARCHAR(30)	Owner of the table to be referenced
9	R_TABLE_NAME	VARCHAR(30) or MVARCHAR(30)	Name of the table to be referenced
10	DELETE_RULE	CHAR(11)	Deletion rule (RESTRICT or CASCADE)
11	UPDATE_RULE	CHAR(11)	Update rule (RESTRICT or CASCADE)
12	CONSTRAINT_TIME	CHAR(14)	Date and time when the constraint was defined (YYYYMMDDHHMMSS)
13	CHECK_PEND	CHAR(1)	Type of check pending status C: Pending Null value: Non-pending
14	DELETE_TRIGGER_NAME	VARCHAR(30) or MVARCHAR(30)	Name of the trigger created by the action of the ON DELETE referential constraint (DRAYYYYMMDDHHMMSSth) Null value if no trigger is created by the action of the ON DELETE referential constraint.
15	UPDATE_TRIGGER_NAME	VARCHAR(30) or MVARCHAR(30)	Name of the trigger created by the action of the ON UPDATE referential constraint (DRAYYYYMMDDHHMMSSth) Null value if no trigger is created by the action of the ON UPDATE referential constraint.
16	R_COLUMN_NAME	VARCHAR(527) or MVARCHAR(527)	Column names of the columns that make up the main key Enclose each column in quotation marks and link the columns with commas.
17	R_COLUMN_NO	VARCHAR(32)	Column IDs (16 IDs) of the columns that make up the main key#

#: Endian conversion is not performed on the SQL results even if the connection modes have different endians. Therefore, when an application accesses the SQL results, the SQL must consider the endian and convert the endian if necessary.

This table manages information on the columns that make up foreign keys. (Each row describes information on one column.)

The following table shows the contents of the SQL_KEYCOLUMN_USAGE table.

Table G-45 SQL_KEYCOLUMN_USAGE table contents

Number	Column name	Data type	Contents
1	CONSTRAINT_SCHEMA	VARCHAR(30) or MVARCHAR(30)	Constraint owner
2	CONSTRAINT_NAME	VARCHAR(30) or MVARCHAR(30)	Constraint name
3	TABLE_SCHEMA	VARCHAR(30) or MVARCHAR(30)	Owner of the table for which the constraint was defined
4	TABLE_NAME	VARCHAR(30) or MVARCHAR(30)	Name of the table for which the constraint was defined
5	COLUMN_NAME	VARCHAR(30) or MVARCHAR(30)	Name of the column for which the constraint was defined
6	COLUMN_ORDER	SMALLINT	Position of the column for which the constraint was defined

This table manages information on integrity constraints found in a schemas. (Each row describes information on one integrity constraint.)

The following table shows the contents of the SQL_TABLE_CONSTRAINTS table.

Table G-46 SQL_TABLE_CONSTRAINTS table contents

Number	Column name	Data type	Contents
1	CONSTRAINT_SCHEMA	VARCHAR(30) or MVARCHAR(30)	Constraint owner
2	CONSTRAINT_NAME	VARCHAR(30) or MVARCHAR(30)	Constraint name
3	CONSTRAINT_TYPE	VARCHAR(30)	Constraint type FOREIGN KEY: Foreign key CHECK: Check constraint
4	TABLE_SCHEMA	VARCHAR(30) or MVARCHAR(30)	Owner of the table for which the constraint was defined
5	TABLE_NAME	VARCHAR(30) or MVARCHAR(30)	Name of the table for which the constraint was defined

This table manages information on check constraints. (Each row describes information on one check constraint.)

The following table shows the contents of the SQL_CHECKS table.

Table G-47 SQL_CHECKS table contents

Number	Column name	Data type	Contents
1	CONSTRAINT_SCHEMA	VARCHAR(30) or MVARCHAR(30)	Check constraint owner
2	CONSTRAINT_NAME	VARCHAR(30) or MVARCHAR(30)	Constraint name
3	TABLE_SCHEMA	VARCHAR(30) or MVARCHAR(30)	Owner of the table for which the constraint was defined
4	TABLE_NAME	VARCHAR(30) or MVARCHAR(30)	Name of the table for which the constraint was defined
5	CHK_SOURCE_LEN	INTEGER	Length of the check constraint search conditions
6	CHK_SOURCE	BINARY(2000000)	Check constraint search conditions
7	CREATE_TIME	CHAR(14)	Date and time when the search constraint was defined (YYYYMMDDHHMMSS)
8	CHECK_PEND2	CHAR(1)	Check pending status type C: Pending Null value: Non-pending
9	N_CHK_COLUMN	INTEGER	Number of constraint columns specified in the check constraint definition (number of duplicate exclusion columns)

This table manages information on the columns used by check constraints. (Each row describes information on one column used by one check constraint.)

The following table shows the contents of the SQL_CHECK_COLUMNS table.

Table G-48 SQL_CHECK_COLUMNS table contents

Number	Column name	Data type	Contents
1	CONSTRAINT_SCHEMA	VARCHAR(30) or MVARCHAR(30)	Check constraint owner
2	CONSTRAINT_NAME	VARCHAR(30) or MVARCHAR(30)	Constraint name
3	TABLE_SCHEMA	VARCHAR(30) or MVARCHAR(30)	Owner of the table for which the constraint was defined
4	TABLE_NAME	VARCHAR(30) or MVARCHAR(30)	Name of the table for which the constraint was defined
5	COLUMN_NAME	VARCHAR(30) or MVARCHAR(30)	Name of the column used by the constraint

This table manages information on partitioning keys in matrix partitioning tables that combine key range partitioning and hash partitioning. (Each row describes information on one partitioning key.)

The following table shows the contents of the SQL_DIV_TYPE table.

Table G-49 SQL_DIV_TYPE table contents

Number	Column name	Data type	Contents
1	TABLE_SCHEMA	VARCHAR(30) or MVARCHAR(30)	Table owner
2	TABLE_NAME	VARCHAR(30) or MVARCHAR(30)	Table name
3	KEY_NO	SMALLINT	Partitioning key number (dimension number)
4	DIV_TYPE	CHAR(1)	Partitioning type in the dimension P: Boundary value partitioning F: FIX hash partitioning H: Flexible hash partitioning
5	HASH_NAME	VARCHAR(30) or MVARCHAR(30)	Hash function name "HASH1" "HASH2" "HASH3" "HASH4" "HASH5" "HASH6" "HASH0" Null value for dimensions without hash partitioning
6	N_DIV_COLUMN	SMALLINT	Number of partitioning columns in the dimension

This table manages information about limits on the number of consecutive certification failures and password character strings. (Each row describes information on one setting item. n rows describes information on one limit on the number of consecutive certification failures or one password character string limit.) The SQL_SYSPARAMS table can be referenced only by owners with the DBA privilege and auditors.

The following table shows the contents of the SQL_SYSPARAMS table.

Table G-50 SQL_SYSPARAMS table contents

Number	Column name	Data type	Contents
1	PARAM_KIND	VARCHAR(20)	Parameter type (CONNECTION_SECURITY)
2	FUNCTION_KEY	VARCHAR(20)	Function name CONNECT: Limit on the number of consecutive certification failures PASSWORD: Password character sting limit
3	PARAM_KEY	VARCHAR(20)	Specification item When the function name is CONNECT, the specification item is one of the following: PERMISSION_COUNT: Permitted number of consecutive certification failures LOCK_MINUTE: Account lock period (minutes) LOCK_MINUTE_CODE: Account lock period code When the function name is PASSWORD, the specification item is one of the following: MIN_LENGTH: Minimum number of allowed bytes USER_IDENTIFIER: Specification of authorization identifier prohibited SIMILAR: Specification of single character type prohibited
4	INT_VALUE	INTEGER	INT-type data value#
5	CHAR_VALUE	VARCHAR(30)	CHAR-type data value#

#: The table below shows the values that are stored for the INT-type and CHAR-type data values.

PARAM_KEY setting value	Value specified in SQL	INT_VALUE	CHAR_VALUE
PERMISSION_COUNT	Constant	Constant	Constant
	No specification	2	2
LOCK_MINUTE	Constant	Constant	Constant
	UNLIMITED	Null value	UNLIMITED
	No specification	1440	1440
LOCK_MINUTE_CODE	Constant	Constant	Constant
	UNLIMITED	Null value	UNLIMITED
	No specification	1000000	1000000
MIN_LENGTH	Constant	Constant	Constant
	No specification	8	8
USER_IDENTIFIER	RESTRICT	Null value	RESTRICT
	UNRESTRICT	Null value	UNRESTRICT
	No specification	Null value	RESTRICT
SIMILAR	RESTRICT	Null value	RESTRICT
	UNRESTRICT	Null value	UNRESTRICT
	No specification	Null value	RESTRICT