Nonstop Database, HiRDB Version 9 UAP Development Guide
The definition information required for referencing of each data dictionary table is shown as follows:
Each dictionary table has a column with the VARCHAR or MVARCHAR data type. This is the dictionary datatype operand for the database initialization utility or database structure modification utility, and must be set to either VARCHAR or MVARCHAR.
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:
|
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:
|
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.
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"
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. |
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 |
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 |
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 | 'CURRENT |
||
CURRENT_DATE | 12 | 'CURRENT_DATE' | |||
CURRENT TIME | TIME or CHAR(8) | 12 | 'CURRENT |
||
CURRENT_TIME | 12 | 'CURRENT_TIME' | |||
CURRENT TIMESTAMP(p) (p: decimal seconds precision) |
TIMESTAMP, CHAR(19), CHAR(22), CHAR(24), or CHAR(26) | 20 | 'CURRENT |
||
CURRENT_TIMESTAMP(p) (p: decimal seconds precision) |
20 | 'CURRENT_TIMESTAMP(p)'#7 | |||
Lit | Char string lit | Character string literal Example 1: 'HiRDB' Example 2: |
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-24 |
|||
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)) |
This table manages information about the following indexes (each row describes information for one index):
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. |
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. |
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 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 |
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 |
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. |
'F' routine name (up to 19 bytes) object ID (10 bytes)
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. |
'(T#tbl_id#col_id#nnnnn)'
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)# |
SELECT HEX(SUBSTR("RANGE_VALUE",33,a)) FROM "MASTER".SQL_COLUMN_STATISTICS WITHOUT LOCK NOWAIT
SELECT HEX(SUBSTR("RANGE_VALUE",33,a)) FROM "MASTER".SQL_COLUMN_STATISTICS WITHOUT LOCK NOWAIT
SELECT HEX(SUBSTR("RANGE_VALUES"),49,a) FROM "MASTER".SQL_COLUMN_STATISTICS WITHOUT LOCK NOWAIT
SELECT HEX(SUBSTR("RANGE_VALUE"),33,4) FROM "MASTER".SQL_COLUMN_STATISTICS WITHOUT LOCK NOWAIT
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 |
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 |
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. |
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 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) |
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. |
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# |
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# |
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 |
This table manages information about the component substructure paths of substructure indexes (each row describes information on one index).
The following table shows the contents of the SQL_INDEX_XMLINF table.
Table G-51 SQL_INDEX_XMLINF 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 | INDEX_NAME | VARCHAR(30) or MVARCHAR(30) | Index name |
4 | PARTIAL_STRUCTURE_PATH_ORDER | SMALLINT | Always 1 |
5 | PARTIAL_STRUCTURE_PATH | VARCHAR(32000) or MVARCHAR(32000) | Substructure path |
6 | ASC_DESC | CHAR(1) | Sort order: A: Ascending order D: Descending order |
7 | DATA_TYPE | CHAR(24) | Data type of the substructure path For details about the storage format, see the DATA_TYPE column of the SQL_COLUMNS table. |
8 | DATA_TYPE_CODE | SMALLINT | Data type code of the substructure path For details about the storage format, see the DATA_TYPE_CODE column of the SQL_COLUMNS table. |
9 | DATA_LENGTH | CHAR(7) | Data length of the substructure path (character format) For details about the storage format, see the DATA_LENGTH column of the SQL_COLUMNS table. |
10 | DATA_LENGTH_CODE | SMALLINT | Data length of the substructure path. For details about the storage format, see the DATA_LENGTH_CODE column of the SQL_COLUMNS table. |
This table manages information about sequence generators. (Each row describes information on one sequence generator.)
The following table shows the contents of the SQL_SEQUENCES table.
Table G-52 SQL_SEQUENCES table contents
Number | Column name | Data type | Contents |
---|---|---|---|
1 | SEQUENCE_SCHEMA | VARCHAR(30) or MVARCHAR(30) | Owner of the sequence generator |
2 | SEQUENCE_NAME | VARCHAR(30) or MVARCHAR(30) | Sequence generator identifier |
3 | SEQUENCE_ID | INT | Sequence generator ID |
4 | SEQUENCE_TYPE | CHAR(1) | Information used by the system Always E. |
5 | PUBLIC_USAGE | CHAR(1) | Whether PUBLIC USAGE is specified: Y: Specified Null value: PUBLIC USAGE is not specified. |
6 | CREATE_TIME | CHAR(14) | Sequence generator creation time |
7 | ALTER_TIME | CHAR(14) | Always the null value |
8 | DATA_TYPE | CHAR(24) | Data type of the sequence generator: INTEGER: Default value For details about the storage format, see the DATA_TYPE column of the SQL_COLUMNS table. |
9 | DATA_TYPE_CODE | SMALLINT | Data type code of the sequence generator For details about the storage format, see the DATA_TYPE_CODE column of the SQL_COLUMNS table. |
10 | DATA_LENGTH | CHAR(7) | Data length of the sequence generator (character format) For details about the storage format, see the DATA_LENGTH column of the SQL_COLUMNS table. |
11 | DATA_LENGTH_CODE | SMALLINT | Data length of the sequence generator For details about the storage format, see the DATA_LENGTH_CODE column of the SQL_COLUMNS table. |
12 | START_VALUE | VARCHAR(255) | Start value Null value if this information is not specified. |
13 | MAXIMUM_VALUE | VARCHAR(255) | Maximum value: NO MAXVALUE: NO MAXVALUE is specified Null value if this information is not specified. |
14 | MINIMUM_VALUE | VARCHAR(255) | Minimum value: NO MINVALUE: NO MINVALUE is specified Null value if this information is not specified. |
15 | INCREMENT | VARCHAR(255) | Increment Null value if this information is not specified. |
16 | CYCLE_OPTION | CHAR(1) | Cycle option: Y: CYCLE N: NO CYCLE is specified or the specification is omitted. |
17 | LOGINTERVAL | INT | Sequence generator log output interval If this information is not specified, 1 is set. The initial value is 1. |
18 | RDAREA_NAME | VARCHAR(30) or MVARCHAR(30) | Name of the sequence generator storage RDAREA |
19 | RDAREA_ID | INT | ID of the sequence generator storage RDAREA |
All Rights Reserved. Copyright (C) 2011, Hitachi, Ltd.