![[Contents]](FIGURE/CONTENT.GIF)
Scalable Database Server, HiRDB Version 8 UAP Development Guide
![[Index]](FIGURE/INDEX.GIF)
![[Back]](FIGURE/FRONT.GIF)
![[Next]](FIGURE/AFTER.GIF)
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.)
Table F-2 shows the contents of the SQL_PHYSICAL_FILES table.
Table F-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.)
Table F-3 shows the contents of the SQL_RDAREAS table.
Table F-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) |
| 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 |
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.
Table F-4 shows the contents of the SQL_TABLES table.
Table F-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 FOREIGN TABLE: External 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 (initial value is 0) |
| 7 | DCOLUMN_NAME | VARCHAR(30) or MVARCHAR(30) | Partitioned column name (column name of the first partitioning key for multiple column partitioning or matrix partitioning) Null value for a non-partitioned table, view tables, and foreign tables |
| 8 | VDEFLEN | INTEGER | Length of view analysis information Null value for base tables and foreign tables |
| 9 | FREE_AREA | SMALLINT | Percentage of unused space in each page 0 for a view table or a foreign table |
| 10 | FREE_PAGE | SMALLINT | Rate (%) of free pages (unused pages) inside a segment 0 for a view table or a foreign 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 row units and for view tables, foreign tables |
| 14 | DEFAULT_COLUMN | SMALLINT | Number of specified columns with the default value (DEFAULT clause or WITH DEFAULT).2 Null value for view tables and dictionary tables |
| 15 | RDAREA_NAME | VARCHAR(30) or MVARCHAR(30) | Name of storage RDAREA for non-partitioned table (Null value for partitioned tables, view tables, and foreign tables) |
| 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-1024) 0 for a view table or a foreign 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 base tables and foreign tables |
| 21 | N_BASETABLE | INTEGER | Number of base tables used for a view table Null value for base tables and foreign tables |
| 22 | ROW_LENGTH | INTEGER | Row length of a FIX table Null value for tables that are not FIX tables, view tables, and foreign tables |
| 23 | N_NOTNULL | INTEGER | Number of NOT NULL values2 (Null value for view tables and dictionary tables) |
| 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 non-partitioned tables, key range partitioning tables, view tables, and foreign tables |
| 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 tables without a HASH specification, matrix partitioning tables, view tables, dictionary tables, and foreign tables. |
| 27 | N_LOB_COLUMN | SMALLINT | Number of columns with BLOB-data type (Null value for view tables and tables without BLOB columns) |
| 28 | N_LOB_RDAREA | INTEGER | Number of user LOB RDAREAs for a table Null value for view tables, tables without BLOB columns, tables without abstract data containing BLOB attributes, and foreign tables |
| 29 | CHANGE_TIME | CHAR(14) | Time table definition was changed (YYYYMMDDHHMMSS) (Null value when a table is initially created.) |
| 30 | N_DIV_COLUMN | SMALLINT | Number of partitioning key columns (216) Null value for non-partitioned tables, tables with single column partitioning keys specified, view tables, and foreign tables. |
| 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 tables for which column-by-column data suppression is not specified, view tables, and foreign tables |
| 32 | N_ADT_COLUMN | SMALLINT | Number of columns with an abstract data type Null value for tables in which the abstract data type is not defined, view tables, and foreign tables |
| 33 | WITHOUT_ ROLLBACK |
CHAR(1) | Whether or not a WITHOUT ROLLBACK is specified 'Y': Specified Null value: No specification Null value for tables for which WITHOUT ROLLBACK is not defined, view tables, and foreign tables |
| 34 | N_EXCEPT_VALUES | INTEGER | Number of exclusion key values in an index (Null value for indexes without exceptional value specifications and for view tables) |
| 35 | EXCEPT_VALUES_LEN | INTEGER | Total length of exclusion key values in an index (Null value for indexes without exceptional value specifications and for view tables) |
| 36 | REBALANCE | CHAR(1) | Whether or not the rebalancing facility is used: Y: Used. Null value for tables that do not use the rebalancing facility, view tables, and foreign tables |
| 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) | External server name Null value for tables that are not foreign tables. |
| 40 | FOREIGN_SERVER_ ID |
INTEGER | External server ID Null value for tables that are not foreign tables. |
| 41 | BASE_FOREIGN_ TABLE_SCHEMA |
VARCHAR(30) or MVARCHAR(30) | Authorization identifier or schema name of the user of a base table on a foreign server. Null value for tables that are not foreign tables. |
| 42 | BASE_FOREIGN_ TABLE_NAME |
VARCHAR(30) or MVARCHAR(30) | Name of a base table on a foreign server. Null value for tables that are not foreign tables. |
| 43 | N_RDAREA_BEFORE_ REBALANCE |
INTEGER | Number of RDAREAs storing the rebalancing table1 Null value if rebalancing is started, and for tables that are not rebalancing tables, view tables, and foreign tables. |
| 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), for view tables, and foreign tables. |
| 46 | N_REUSE_SEGMENT | INTEGER | Number of segments that start reusing free areas.3 Null value if NO is specified for SEGMENT REUSE (including when its specification is omitted), for view tables, and foreign tables. |
| 47 | REUSE_SEGMENT_SIZE | CHAR(10) | Specified number of segments that start reusing free areas.4 Null value if a value other than a segment count is specified for SEGMENT REUSE, for view tables, and foreign tables. |
| 48 | REUSE_SEGMENT_SIZE_TYPE | CHAR(1) | Unit for the number of segments that start reusing free areas. K: Specifies K. M: Specifies M. Blank space: Specification omitted Null value if a value other than a segment count is specified for SEGMENT REUSE, for view tables, and foreign tables. |
| 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, for view tables, and foreign tables. |
| 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, if no deletion prevented duration is specified, for view tables, and foreign tables |
| 51 | DELETE_PROHIBIT_TERM | CHAR(10) | Specification value for the deletion prevented duration5 Null value if the falsification prevention facility is not used, if no deletion prevented duration is specified, for view tables, and foreign tables. |
| 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, for view tables, and foreign tables. |
| 53 | N_TRIGGER | INTEGER | Number of defined triggers Null value if no trigger is defined, and for view tables, foreign tables, and dictionary tables. |
| 54 | N_DIV_DIMENSION | SMALLINT | Number of division dimensions Null value for tables that are not matrix-partitioned tables. |
| 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 tables that are not audit trail tables and not view tables based on an audit trail table |
| 56 | N_PARENTS | SMALLINT | Number of foreign keys Null value for tables without a defined referential constraint, view tables, and foreign tables. |
| 57 | N_CHILDREN | SMALLINT | Number of foreign keys that reference the main keys of this table Null value for unreferenced tables that are not referenced tables, view tables, and foreign tables. |
| 58 | N_FK_COLUMNS | SMALLINT | Total number of foreign key columns Null value for tables without a defined referential constraint, view tables, and foreign tables. |
| 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 view tables, and foreign tables. |
| 60 | N_CHECK | INTEGER | Number of defined check constraints Null value for tables without a defined referential constraint, view tables, and foreign tables. |
| 61 | N_CHECK_LIMIT | INTEGER | Check constraint limit6 Null value for tables without a defined referential constraint, view tables, and foreign tables. |
| 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 view tables, and foreign tables. |
| 63 | CHK_SOURCE_LEN | INTEGER | Total length of search conditions of a check constraint Null value for tables without a defined referential constraint, view tables, and foreign tables. |
| 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 view tables, and foreign tables. |
| 66 | N_UPDATE_COLUMN | SMALLINT | Number of columns for which an updatable column attribute is specified Null value for tables without a specified updatable column attribute, view tables, and foreign tables. |
| 67 | TABLE_CREATOR | VARCHAR(30) or MVARCHAR(30) |
Creator of a public view table Null value for table that are not public view tables. |
| 68 | N_ENCRYPTED_COLUMN | SMALLINT | Used by the system; always the null value. |
| 69 | CRYPTO_LIBRARY_TYPE | CHAR(1) | Used by the system; always the null value. |
1 If an RDAREA is added to a rebalancing table using ALTER TABLE ADD RDAREA, the column contains the number of table storage RDAREAs before the RDAREA was added.
2 If a foreign table is created using the HiRDB External Data Access facility and NO is specified in the NULLABLE column option, NOT NULL WITH DEFAULT is assumed. Therefore, the columns in the DEFAULT_COLUMN column for which WITH DEFAULT is specified are counted, as well as the columns in the N_NOTNULL column that contains non-null values.
![[Figure]](FIGURE/ZUENG005.GIF)
1024 10242
CREATE TABLE "STOCK"
("GNO" CHAR(5),"GNAME" CHAR(8),"PRICE" INTEGER,
"QUANTITY" INTEGER,"STOCKING DATE" DATE)
CHECK("QUANTITY "![[Figure]](FIGURE/ZUENG001.GIF)
100 AND "QUANTITY" ![[Figure]](FIGURE/ZUENG000.GIF)
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.
Table F-5 shows the contents of the SQL_COLUMNS table.
Table F-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 type1 |
| 7 | DATA_LENGTH | CHAR(7) | Column data length is stored right justified in character format (blanks are used for leading zeros) |
| 8 | IS_NULLABLE | CHAR(3) | Column null information5: YES: Null value allowed NO: Null values not allowed |
| 9 | DIVIDED_KEY | CHAR(1) | Partitioning key: Y: Partitioning key Blank: Not a partitioning key |
| 10 | CLUSTER_KEY | CHAR(1) | Cluster key: Y: Column used for cluster key Blank: 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 type8: C: Column F: Function, operation E: Other Null value for base tables and foreign tables |
| 13 | BASE_OWNER | VARCHAR(30) or MVARCHAR(30) | Owner of base table that contains base column Null value for base tables and foreign tables |
| 14 | BASE_TABLE | VARCHAR(30) or MVARCHAR(30) | Name of base table that contains base column Null value for base tables and foreign tables |
| 15 | BASE_COLUMN | VARCHAR(30) or MVARCHAR(30) | Base column name Null value for base tables and foreign tables |
| 16 | DEFAULT_COLUMN | CHAR(1) | WITH DEFAULT specification5 Y: Specified N: Not specified Null value for view tables |
| 17 | COLUMN_OFFSET | SMALLINT | Column offset Null value for tables that are not FIX tables, view tables, and foreign tables. |
| 18 | HASH_KEY | CHAR(1) | Hash key: Y: Hash key Blank: 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.) |
| 20 | LOB_LENGTH | CHAR(20) | Column length specification stored right-justified in character format (blanks are used for leading zeros) Null value if the length is not for BLOB or BINARY. |
| 21 | LOB_LENGTH_TYPE | CHAR(1) | Column length type (in column lengths): K: K specified M: M specified G: G specified Blank: Default (Null value if the data type is not BLOB.) |
| 22 | DATA_TYPE_CODE | SMALLINT | Data type code2 |
| 23 | DATA_LENGTH_CODE | SMALLINT | Column data length code3 |
| 24 | LOB_LENGTH_CODE | CHAR(8) | BLOB column data length code4, 6 (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 non-partitioned tables, tables with single column partitioning keys specified, view tables, and foreign tables. |
| 26 | SUPPRESS_INF | CHAR(1) | Whether or not data suppression is specified: Y: Specified Null value: No specification Null value for tables without data suppression specifications, view tables, and for foreign tables |
| 27 | PLUGIN_ DESCRIPTION |
VARCHAR(255) | Plug-in option contents Null value if no PLUGIN clause is specified, and for foreign tables. |
| 28 | UDT_OWNER | VARCHAR(30) | Owner of a user-defined type Null value if the type is not user-defined, and for foreign tables. |
| 29 | UDT_NAME | VARCHAR(30) | Name of the user-defined type Null value if the type is not user-defined, and for foreign tables. |
| 30 | UDT_TYPE_ID | INTEGER | User-defined type ID Null value if the type is not user-defined, and for foreign tables. |
| 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 view tables, foreign tables, and if ALTER TABLE CHANGE SPLIT is executed. |
| 33 | PRIMARY_KEY | CHAR(1) | Primary key type Y: Primary key Blank: Other than the primary key |
| 34 | COLLATING_SEQUENCE | CHAR(1) | Character code and collating sequence for the character string type column of a foreign server and HiRDB External Data Access S: SAME D: DIFFERENT Null value for tables that are not foreign tables and if the data type of a foreign table column is not the character string type. |
| 35 | TRAILING_SPACE | CHAR(1) | Whether or not there are trailing spaces in a column of character string type in the external table: Y: There are trailing spaces. N: There are no trailing spaces. Null value for tables that are not foreign tables and if the data type of a foreign table column is not the variable character string type. |
| 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, for view tables, and foreign tables. |
| 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, for view tables, and foreign tables. |
| 38 | DEFAULT_VALUE | VARCHAR(32000) or MVARCHAR(32000)7 |
Default value (character format) specified for the DEFAULT clause.9 Null value if the DEFAULT clause is not specified, for view tables, and foreign tables. |
| 39 | DEFAULT_VALUE2 | VARCHAR(32000) or MVARCHAR(32000)7 | 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, for view tables, and foreign tables. |
| 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, for view tables, and foreign tables. |
| 41 | CHECK_COLUMN | CHAR(1) | Check constraint specification Y: Specified Null value for tables in which a check constraint is not defined, view tables, and foreign tables. |
| 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 tables for which the updatable attribute is not specified, view tables, and foreign tables. |
| 44 | CRYPTO_LIBRARY_TYPE | CHAR(1) | Used by the system; always the null value. |
| Data type | Value to be stored |
|---|---|
| INT | INTEGER |
| INTEGER | |
| SMALLINT | SMALLINT |
| DEC | 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 |
| BINARY LARGE OBJECT | |
| Abstract data type | ADT |
| BOOLEAN | BOOLEAN |
Table F-6 Values that are stored when the DEFAULT clause is specified
| Default value | Data type1 | Value stored in DEFAULT_VALUE column, DEFAULT_VALUE2 column, or DEFAULT_VALUE3 column2 | |||
|---|---|---|---|---|---|
| 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![[Figure]](FIGURE/ZUENG020.GIF) DATE'3 |
||
| CURRENT_DATE | 12 | 'CURRENT_DATE' | |||
| CURRENT TIME | TIME or CHAR(8) | 12 | 'CURRENTTIME'3 |
||
| CURRENT_TIME | 12 | 'CURRENT_TIME' | |||
| CURRENT TIMESTAMP(p) (p: decimal seconds precision) |
TIMESTAMP, CHAR(19), CHAR(22), CHAR(24), or CHAR(26) | 20 | 'CURRENTTIMESTAMP(p)'3, 7 |
||
| CURRENT_TIMESTAMP(p) (p: decimal seconds precision) |
20 | 'CURRENT_TIMESTAMP(p)'7 | |||
| Lit | Char string lit | Character string literal Example 1: 'HiRDB' Example 2: '2002-10-24 10:50:23.1234' |
CHAR or MCHAR | def-val-size + 24 | specified-default-value-size4 Example: ''HiRDB'' |
| VARCHAR or MVARCHAR | |||||
| DATE, TIME, or TIMESTAMP | def-val-size + 24 | specified-default-value-size4 Example: ''2002-10-24 10:50:23.1234'' |
|||
| Mixed character string literal Example: M'100 years' |
CHAR or MCHAR | def-val-size + 34 | specified-default-value-size4 Example: 'M'100 years'' |
||
| VARCHAR or MVARCHAR | |||||
| National character string literal Example: N'software' |
NCHAR or NVARCHAR | def-val-size + 34 | specified-default-value-size4 Example: 'N'software''' |
||
| Hexadecimal character string literal Example 1: X'48692D43' Example 2: X'2002102410502312' |
CHAR, VARCHAR, MCHAR, MVARCHAR, or BINARY | def-val-size + 34 | 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-size5 | specified-default-value5 Example: '10' |
|
| Floating-point literal Example: 15e + 3 |
INTEGER, SMALLINT, DECIMAL, FLOAT, or SMALLFLT | 22 or 23 | specified-default-value5 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-size5 | specified-default-value5 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 blank in all other cases and for a positive value)) |
||
: 1-byte blank spaceThis table manages index information. (Each row describes information on one index.)
Table F-7 shows the contents of the SQL_INDEXES table.
Table F-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 partitioning key indexes and foreign indexes |
| 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 (%) 0 for foreign indexes |
| 13 | COLUMN_ID_LIST | VARCHAR(64) | List of IDs of columns constituting the index1 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 indexes for which unbalanced split is not specified, and foreign indexes. |
| 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), and foreign indexes |
| 17 | INDEX_TYPE_NAME | VARCHAR(30) or MVARCHAR(30) | Name of an index type Null value for CREATE INDEX (Format 1), and foreign indexes |
| 18 | INDEX_TYPE_ID | INTEGER | Index type ID Null value for CREATE INDEX (Format 1), and foreign indexes |
| 19 | PLUGIN_ DESCRIPTION |
VARCHAR(255) | Plug-in option contents Null value if PLUGIN is not specified, and for foreign indexes. |
| 20 | N_FUNCTION | INTEGER | Number of applied functions Null value for CREATE INDEX (Format 1), and foreign indexes |
| 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 partitioning key indexes as well |
| 27 | SHARED | CHAR(1) | Shared index specification S: Shared index Null value: Unshared index |
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.
Table F-8 shows the contents of the SQL_USERS table.
Table F-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.)
Table F-9 shows the contents of the SQL_RDAREA_PRIVILEGES table.
Table F-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.
Table F-10 shows the contents of the SQL_TABLE_PRIVILEGES table.
Table F-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 or role 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) | Type of table access privilege grantee: G: Role registered in the directory server Null if GRANTEE or the user is PUBLIC. |
This table manages information of the base tables that serve as the basis for view tables. (Each row describes information on one view table.)
Table F-11 shows the contents of the SQL_VIEW_TABLE_USAGE table.
Table F-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 |
| 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 F: External table P: User-defined function (excluding plug-in functions) |
This table manages view table definition information. (Each row describes information on one view table.)
Table F-12 shows the contents of the SQL_VIEWS table.
Table F-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.)
Table F-13 shows the contents of the SQL_DIV_TABLE table.
Table F-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. Blank if no partitioning storage condition is specified or if hash partitioning is specified. |
| 6 | DCVALUES | VARCHAR(256) or MVARCHAR(256) | Partitioning condition value (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.)
Table F-14 shows the contents of the SQL_INDEX_COLINF table.
Table F-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 Blank: (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.)
Table F-15 shows the contents of the SQL_DIV_INDEX table.
Table F-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)1 |
| 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.)
Table F-16 shows the contents of the SQL_DIV_COLUMN table.
Table F-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.)
Table F-17 shows the contents of the SQL_ROUTINES table.
Table F-17 SQL_ROUTINES table contents
| Number | Column name | Data type | Contents |
|---|---|---|---|
| 1 | ROUTINE_SCHEMA | VARCHAR(30) or MVARCHAR(30) | Routine owner |
| 2 | ROUTINE_NAME | VARCHAR(30) or MVARCHAR(30) | Routine name10 |
| 3 | OBJECT_ID | INTEGER | Object ID |
| 4 | SPECIFIC_NAME | VARCHAR(30) or MVARCHAR(30) | Specific name2 |
| 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 valid1 N: Index status invalid1 |
| 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.8 |
| 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 foreign routines (excluding Java routines), registry operation procedures, and trigger action procedures. |
| 20 | ROUTINE_ADT_OWNER | VARCHAR(30) | Owner of the abstract data type that defined routines (Null value for routines that are not defined inside the abstract data type) |
| 21 | ROUTINE_ADT_NAME | VARCHAR(30) | Name of the abstract data type that defined routines (Null value for routines that are not defined inside the abstract data type) |
| 22 | ROUTINE_BODY | CHAR(1) | Function routine type: S: SQL procedure E: External routine T: Trigger action procedure Null value for procedures (excluding trigger action procedures) that are not foreign routines. |
| 23 | FUNCTION_TYPE | CHAR(1) | Function type: C: System-defined function constructor Blank: User-defined function (Null value for procedures) |
| 24 | EXTERNAL_NAME | VARCHAR(255) | External routine name (library-name ! operation-name) or a Java method name if defined in Java Null value if the name is not for a foreign function. |
| 25 | EXTERNAL_LANGUAGE | CHAR(20) | External descriptive language type: C: C language Java: Java language Null value if the language type is not for a foreign function. |
| 26 | PARAMETER_STYLE | VARCHAR(20) | Parameter style (external routine type) PLUGIN: Plug-in RDSQL: System-defined scalar function Java: Java Null value if the parameter style is not for a foreign function. |
| 27 | ENCAPSULATION_ LEVEL |
VARCHAR(10) | Encapsulation level (PUBLIC, PRIVATE, or PROTECTED) (Null value for routines that are not defined inside the 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 type3 (Null value if the return value data type is not a function.) |
| 33 | RETURN_DATA_ LENGTH_CODE |
SMALLINT | Code for a return value data length4 (Null value for procedures) |
| 34 | RETURN_DATA_ LENGTH |
CHAR(7) | Return value data length stored right-justified in character format (blanks are used for leading zeros) (Null value for procedures) |
| 35 | RETURN_LOB_ LENGTH_CODE |
CHAR(8) | Code for a return value BLOB data length5, 9 (Null value for procedures, 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 (blanks are used for leading zeros) (Null value for procedures, 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 Blank: Default (Null value for procedures, 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-name6 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) | Data access specification: C: CONTAINS SQL M: MODIFIES SQL N: NO SQL R: Used by the system; always the null value. |
| 43 | RETURNS_JAVA_ DATA_TYPE |
VARCHAR(255) | Java return value's data type corresponding to return value's data type7 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 type7 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 routines created with an HiRDB versions earlier than 07-01, if FOR UPDATE EXCLUSIVE has not been specified, and if the ISOLATION LEVEL value is 2. |
| 48 | SUBSTR_LENGTH | SMALLINT | Specification value of SUBSTR LENGTH of the SQL compile option Null value for routines created with HiRDB versions earlier than 08-00, or when the character code type is not Unicode (UTF-8). |
| 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.)
Table F-18 shows the contents of the SQL_ROUTINE_RESOURCES table.
Table F-18 SQL_ROUTINE_RESOURCES table contents
| Number | Column name | Data type | Contents |
|---|---|---|---|
| 1 | ROUTINE_SCHEMA | VARCHAR(30) or MVARCHAR(30) | Routine owner |
| 2 | ROUTINE_NAME | VARCHAR(30) or MVARCHAR(30) | Routine name |
| 3 | SPECIFIC_NAME | VARCHAR(30) or MVARCHAR(30) | Specific name1 |
| 4 | BASE_OWNER | VARCHAR(30) or MVARCHAR(30) | Resource owner or PUBLIC for a public view table |
| 5 | BASE_NAME | VARCHAR(30) or MVARCHAR(30) | Resource identifier |
| 6 | BASE_TYPE | CHAR(1) | Resource type: R: Base table V: View table I: Index D: Data type P: Routine F: External table T: Trigger |
| 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 inside the 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 inside the abstract data type.) |
| 9 | SELECT_OPERATION2 | 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_OPERATION2 | 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_OPERATION2 | 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_OPERATION2 | 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_OPERATION2 | 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_OPERATION2 | 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 |
'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.)
Table F-19 shows the contents of the SQL_ROUTINE_PARAMS table.
Table F-19 SQL_ROUTINE_PARAMS table contents
| Number | Column name | Data type | Contents |
|---|---|---|---|
| 1 | ROUTINE_SCHEMA | VARCHAR(30) or MVARCHAR(30) | Routine owner |
| 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 name5 |
| 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. (Null value if the data type is BLOB.) |
| 7 | DATA_LENGTH | CHAR(7) | Data length stored right-justified in character format (blanks 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 (blanks 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 Blank: 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 code1 (Null value if the data type is BLOB.) |
| 12 | DATA_LENGTH_CODE | SMALLINT | Data length code2 (Null value if the data type is BLOB, BINARY, or a user-defined type.) |
| 13 | LOB_LENGTH_CODE | CHAR(8) | Column length specification value3, 4 (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 the system-defined type.) |
| 15 | UDT_NAME | VARCHAR(30) or MVARCHAR(30) | Name of a data type parameter (Null value if the parameter is the system-defined type.) |
| 16 | UDT_TYPE_ID | INTEGER | ID of a data type parameter (Null value if the parameter is the 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. |
'(T#tbl_id#col_id#nnnnn)'
This table manages table alias information (table alias specified when CREATE ALIAS was executed and the three-part name of the target table). (Each row describes information on one alias.) For the Windows version, the SQL_ALIASES table is empty.
Table F-20 shows the contents of the SQL_ALIASES table.
Table F-20 SQL_ALIASES table contents
| Number | Column name | Data type | Contents |
|---|---|---|---|
| 1 | ALIAS_SCHEMA | VARCHAR(30) or MVARCHAR(30) | Owner of the alias |
| 2 | ALIAS_NAME | VARCHAR(30) or MVARCHAR(30) | Alias |
| 3 | ALIAS_TYPE | CHAR(1) | Alias type: T: Table Blank: Others |
| 4 | RDNODE_NAME | VARCHAR(30) or MVARCHAR(30) | RD node name |
| 5 | BASE_SCHEMA | VARCHAR(30) or MVARCHAR(30) | Owner of the alias or PUBLIC for a public view table. |
| 6 | BASE_NAME | VARCHAR(30) or MVARCHAR(30) | Name of the alias |
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.
Table F-21 shows the contents of the SQL_TABLE_STATISTICS table.
Table F-21 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.
Table F-22 shows the contents of the SQL_COLUMN_STATISTICS table.
Table F-22 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(2464) | Column value frequency distribution information (statistical information)1 |
SELECT HEX(SUBSTR("RANGE_VALUE"),33,a)
FROM "MASTER".SQL_COLUMN_STATISTICS
WITHOUT LOCK NOWAITSELECT HEX(SUBSTR("RANGE_VALUE"),49,a)
FROM "MASTER".SQL_COLUMN_STATISTICS
WITHOUT LOCK NOWAITSELECT HEX(SUBSTR("RANGE_VALUE"),33,4)
FROM "MASTER".SQL_COLUMN_STATISTICS
WITHOUT LOCK NOWAITThis 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.
Table F-23 shows the contents of the SQL_INDEX_STATISTICS table.
Table F-23 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).
Table F-24 shows the contents of the SQL_DATATYPES table.
Table F-24 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 is also used 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.)
Table F-25 shows the contents of the SQL_DATATYPE_DESCRIPTORS table.
Table F-25 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 code1 |
| 11 | DATA_LENGTH_CODE | SMALLINT | Data length code2 (Null value if the data type is BLOB, BINARY, or a user-defined type) |
| 12 | DATA_LENGTH | CHAR(7) | Data length stored right-justified in character format (blanks are used for leading zeros) (Null value if the data length is for BLOB, BINARY, or a user-defined type.) |
| 13 | LOB_LENGTH_CODE | CHAR(8) | BLOB attribute length code3, 4 (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 (blanks 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 Blank: 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.)
Table F-26 shows the contents of the SQL_TABLE_RESOURCES table.
Table F-26 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.)
Table F-27 shows the contents of the SQL_PLUGINS table.
Table F-27 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 is also used 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.)
Table F-28 shows the contents of the SQL_PLUGIN_ROUTINES table.
Table F-28 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 name1 |
| 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.)
Table F-29 shows the contents of the SQL_PLUGIN_ROUTINE_PARAMS table.
Table F-29 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: Blank: 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 code1 (Null value if the parameter mode is D, K, P, R, U, or T.) |
| 12 | DATA_LENGTH_ CODE |
SMALLINT | Parameter data type definition length code2 (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 (blanks 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 code3, 4 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 blank 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 Blank: 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.)
Table F-30 shows the contents of the SQL_INDEX_TYPES table.
Table F-30 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.)
Table F-31 shows the contents of the SQL_INDEX_RESOURCES table.
Table F-31 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).)
Table F-32 shows the contents of the SQL_INDEX_DATATYPE table.
Table F-32 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.)
Table F-33 shows the contents of the SQL_INDEX_FUNCTION table.
Table F-33 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.)
Table F-34 shows the contents of the SQL_TYPE_RESOURCES table.
Table F-34 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.)
Table F-35 shows the contents of the SQL_INDEX_TYPE_FUNCTION table.
Table F-35 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 function1 |
| 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.
Table F-36 shows the contents of the SQL_EXCEPT table.
Table F-36 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 server DBMS information. One row is created for the information for one foreign server. (Each row describes information on one foreign server.)
If HiRDB External Data Access is not installed, this table is empty. However, if HiRDB External Data Access is installed and a database is created, and then HiRDB External Data Access is removed afterwards, the data in the table remains.
Table F-37 shows the contents of the SQL_FOREIGN_SERVERS table.
Table F-37 SQL_FOREIGN_SERVERS table contents
| Number | Column name | Data type | Contents |
|---|---|---|---|
| 1 | FOREIGN_SERVER_ NAME |
VARCHAR(30) or MVARCHAR(30) | Foreign server name Null value after DROP SERVER is executed.3 |
| 2 | FOREIGN_SERVER_ID | INTEGER | Foreign server ID |
| 3 | FOREIGN_SERVER_ TYPE |
VARCHAR(30) | Server type1 HIRDB: HiRDB XDMRD: HiRDB on XDM DB2_UDB_OS390: DB2 Universal Database for OS/390 ORACLE: Oracle Null value after DROP SERVER is executed.3 |
| 4 | FOREIGN_SERVER_ VERSION |
VARCHAR(30) | Server version1 Null value after DROP SERVER is executed.3 |
| 5 | AUTHORIZATION_ IDENTIFIER |
VARCHAR(30) or MVARCHAR(30) | Foreign server owner Null value after DROP SERVER is executed.3 |
| 6 | CREATE_TIME | CHAR(14) | Foreign server creation time (YYYYMMDDHHMMSS) Null value after DROP SERVER is executed.3 |
| 7 | CHANGE_TIME | CHAR(14) | Foreign server definition change time (YYYYMMDDHHMMSS) Null value when a row is created and after DROP SERVER is executed.3 |
| 8 | N_FOREIGN_TABLE | INTEGER | Number of tables defined in the foreign server |
| 9 | USING_BES | CHAR(8) | Name of the back-end server that accesses the foreign server.2 Null value after DROP SERVER is executed.3 |
| DBMS product name | Server type | Server version |
|---|---|---|
| XDM/RD E2 | XDMRD | 6.0 |
| HiRDB Version 5.0 | HIRDB | 5.0 |
| HiRDB Version 6 | HIRDB | 6.0 |
| HiRDB Version 7 | HIRDB | 6.0 |
| Oracle8.1.5 (for the HP-UX version) | ORACLE | 8.1.5 |
| Oracle8.1.7 (for the AIX 5L version) | ORACLE | 8.1.5 |
| DB2 Universal Database for OS/390 Version 6 | DB2_UDB_OS390 | 6.0 |
This table manages mapping information between authorization identifiers on HiRDB and user IDs on the external server when an external server is accessed while the HiRDB External Data Access facility is being used (one row is for one mapping for one user on HiRDB).
If HiRDB External Data Access is not installed, this table is empty. However, if HiRDB External Data Access is installed and a database is created, and then HiRDB External Data Access is removed afterwards, the data in the table remains.
Table F-38 shows the contents of the SQL_USER_MAPPINGS table.
Table F-38 SQL_USER_MAPPINGS table contents
| Number | Column name | Data type | Contents |
|---|---|---|---|
| 1 | AUTHORIZATION_ IDENTIFIER |
VARCHAR(30) or MVARCHAR(30) | HiRDB authorization identifier that is the conversion source of mapping (always PUBLIC) |
| 2 | FOREIGN_SERVER_ NAME |
VARCHAR(30) or VARCHAR(30) | Name of the external server |
| 3 | FOREIGN_SERVER_ID | INTEGER | External server ID |
| 4 | CREATE_TIME | CHAR(14) | User mapping creation date and time (YYYYMMDDHHMMSS) |
| 5 | CHANGE_TIME | CHAR(14) | User mapping definition modification date and time (YYYYMMDDHHMMSS) |
| 6 | USER_ID | VARCHAR(30) or VARCHAR(30) | User name at the external server |
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.
Table F-39 shows the contents of the SQL_IOS_GENERATIONS table.
Table F-39 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.)
Table F-40 shows the contents of the SQL_TRIGGERS table.
Table F-40 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 triggers that are 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 triggers that are not created by a referential constraint action. |
| 20 | CONSTRAINT_NAME | VARCHAR(30) or MVARCHAR(30) |
Constraint name of referential trigger Null value for triggers that are 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.)
Table F-41 shows the contents of the SQL_TRIGGER_COLUMNS table.
Table F-41 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.)
Table F-42 shows the contents of the SQL_TRIGGER_DEF_SOURCE table.
Table F-42 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.)
Table F-43 shows the contents of the SQL_TRIGGER_USAGE table.
Table F-43 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 |
| 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) |
This table manages the partitioning key information of matrix-partitioned tables. (Each row describes information on one partitioning key.)
If HiRDB Advanced Partitioning Option is not installed, this table is empty. However, if HiRDB Advanced Partitioning Option is installed and a database is created, and then HiRDB Advanced Partitioning Option is removed afterwards, the data in the table remains.
Table F-44 shows the contents of the SQL_PARTKEY table.
Table F-44 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 Partitioning Option is not installed, this table is empty. However, if HiRDB Advanced Partitioning Option is installed and a database is created, and then HiRDB Advanced Partitioning Option is removed afterwards, the data in the table remains.
Table F-45 shows the contents of the SQL_PARTKEY_DIVISION table.
Table F-45 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). 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.)
Table F-46 shows the contents of the SQL_AUDITS table.
Table F-46 SQL_AUDITS table contents
| Number | Column name | Data type | Contents |
|---|---|---|---|
| 1 | EVENT_TYPE | VARCHAR(30) | Name of the event type1 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.)
Table F-47 shows the contents of the SQL_REFERENTIAL_CONSTRAINTS table.
Table F-47 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.)
Table F-48 shows the contents of the SQL_KEYCOLUMN_USAGE table.
Table F-48 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.)
Table F-49 shows the contents of the SQL_TABLE_CONSTRAINTS table.
Table F-49 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.)
Table F-50 shows the contents of the SQL_CHECKS table.
Table F-50 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.)
Table F-51 shows the contents of the SQL_CHECK_COLUMNS table.
Table F-51 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.)
Table F-52 shows the contents of the SQL_DIV_TYPE table.
Table F-52 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.
Table F-53 shows the contents of the SQL_SYSPARAMS table.
Table F-53 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 |
All Rights Reserved. Copyright (C) 2007, Hitachi, Ltd.