Appendix F.2 Data dictionary table details

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.

Organization of this subsection
(1) SQL_PHYSICAL_FILES table
(2) SQL_RDAREAS table
(3) SQL_TABLES table
(4) SQL_COLUMNS table
(5) SQL_INDEXES table
(6) SQL_USERS table
(7) SQL_RDAREA_PRIVILEGES table
(8) SQL_TABLE_PRIVILEGES table
(9) SQL_VIEW_TABLE_USAGE table
(10) SQL_VIEWS table
(11) SQL_DIV_TABLE table
(12) SQL_INDEX_COLINF table
(13) SQL_DIV_INDEX table
(14) SQL_DIV_COLUMN table
(15) SQL_ROUTINES table
(16) SQL_ROUTINE_RESOURCES table
(17) SQL_ROUTINE_PARAMS table
(18) SQL_ALIASES table
(19) SQL_TABLE_STATISTICS table
(20) SQL_COLUMN_STATISTICS table
(21) SQL_INDEX_STATISTICS table
(22) SQL_DATATYPES table
(23) SQL_DATATYPE_DESCRIPTORS table
(24) SQL_TABLE_RESOURCES table
(25) SQL_PLUGINS table
(26) SQL_PLUGIN_ROUTINES table
(27) SQL_PLUGIN_ROUTINE_PARAMS table
(28) SQL_INDEX_TYPES table
(29) SQL_INDEX_RESOURCES table
(30) SQL_INDEX_DATATYPE table
(31) SQL_INDEX_FUNCTION table
(32) SQL_TYPE_RESOURCES table
(33) SQL_INDEX_TYPE_FUNCTION table
(34) SQL_EXCEPT table
(35) SQL_FOREIGN_SERVERS table
(36) SQL_USER_MAPPINGS table
(37) SQL_IOS_GENERATIONS table contents
(38) SQL_TRIGGERS table contents
(39) SQL_TRIGGER_COLUMNS table contents
(40) SQL_TRIGGER_DEF_SOURCE table contents
(41) SQL_TRIGGER_USAGE table contents
(42) SQL_PARTKEY table contents
(43) SQL_PARTKEY_DIVISION table contents
(44) SQL_AUDITS table contents
(45) SQL_REFERENTIAL_CONSTRAINTS table contents
(46) SQL_KEYCOLUMN_USAGE table contents
(47) SQL_TABLE_CONSTRAINTS table contents
(48) SQL_CHECKS table contents
(49) SQL_CHECK_COLUMNS table contents
(50) SQL_DIV_TYPE table contents
(51) SQL_SYSPARAMS table contents

(1) SQL_PHYSICAL_FILES table

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

NumberColumn nameData typeContents
1SERVER_NAMECHAR(8)Server name (back-end server name or dictionary server name)
2PHYSICAL_FILE_NAMEVARCHAR(167)HiRDB filename
3RDAREA_NAMEVARCHAR(30) or MVARCHAR(30)Name of the RDAREA to which HiRDB files are allocated
4INITIAL_SIZEINTEGERNumber of HiRDB file segments
5PHYSICAL_FILE_IDINTEGERPhysical file ID

(2) SQL_RDAREAS table

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

NumberColumn nameData typeContents
1RDAREA_NAMEVARCHAR(30) or MVARCHAR(30)RDAREA name
2SERVER_NAMECHAR(8)Server name (back-end server name or dictionary server name)
3RDAREA_TYPECHAR(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
4PAGE_SIZEINTEGERPage length (in bytes)
5SEGMENT_SIZEINTEGERSegment size (in pages)
6FILE_COUNTINTEGERNumber of HiRDB files
7N_TABLEINTEGERNumber of tables stored (defined number) (initial value is 0)
8N_INDEXINTEGERNumber of indexes stored (defined number) (initial value is 0)
9RDAREA_IDINTEGERRDAREA ID
10REBALANCE_TABLECHAR(1)Rebalance table status:
Y: A rebalance table is used.
Null value: No rebalance table is used.
11MAX_ENTRIESINTEGERMaximum number of entries in the list
NULL for any RDAREA other than the list RDAREA or if max entries is not specified
12EXTENSIONCHAR(1)Specification of RDAREA expansion:
U: Specified.
N: Not specified.
13EXTENSION_SEGMENT_SIZEINTEGERNumber of extension segments
NULL if RDAREA expansion is not specified
14ORIGINAL_RDAREA_NAMEVARCHAR(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)
15ORIGINAL_RDAREA_IDINTEGERFor UNIX:
ID of the original RDAREA
Null value if the RDAREA is not a replica RDAREA.
For Windows:
Used by the system (no contents)
16GENERATION_NUMBERSMALLINTFor UNIX:
Generation number
Null value if the RDAREA is not an original RDAREA or replica RDAREA.
For Windows:
Used by the system (no contents)
17REPLICA_COUNTSMALLINTFor 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)
18REPLICA_STATUSCHAR(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)
19SHAREDCHAR(1)Shared RDAREA
S: Shared RDAREA
Null value: Unshared RDAREA

(3) SQL_TABLES table

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

NumberColumn nameData typeContents
1TABLE_SCHEMAVARCHAR(30) or MVARCHAR(30)Table owner or PUBLIC for a public view table
2TABLE_NAMEVARCHAR(30) or MVARCHAR(30)Table name
3TABLE_TYPECHAR(16)Table type
BASE TABLE: Base table
VIEW: View table
READ ONLY VIEW: Read-only view table
FOREIGN TABLE: External table.
4TABLE_IDINTEGERTable ID
Indicates an internal ID that is unique within the system.
5N_COLSSMALLINTNumber of structure columns
6N_INDEXSMALLINTNumber of defined indexes (initial value is 0)
7DCOLUMN_NAMEVARCHAR(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
8VDEFLENINTEGERLength of view analysis information
Null value for base tables and foreign tables
9FREE_AREASMALLINTPercentage of unused space in each page
0 for a view table or a foreign table
10FREE_PAGESMALLINTRate (%) of free pages (unused pages) inside a segment
0 for a view table or a foreign table
11TABLE_COMMENTVARCHAR(255) or MVARCHAR(255)Comment (initial value is NULL)
12CREATE_TIMECHAR(14)Table creation date and time (YYYYMMDDHHMMSS)
13ENQ_RESOURCE_
SIZE
CHAR(1)Locked resource unit
P: In page units
Null value for locking in row units and for view tables, foreign tables
14DEFAULT_COLUMNSMALLINTNumber of specified columns with the default value (DEFAULT clause or WITH DEFAULT).2
Null value for view tables and dictionary tables
15RDAREA_NAMEVARCHAR(30) or MVARCHAR(30)Name of storage RDAREA for non-partitioned table (Null value for partitioned tables, view tables, and foreign tables)
16DEFINITION_CACHE_
SIZE
INTEGERTable definition cache size (in bytes) (Null value for dictionary tables)
17STATISTICS_CACHE_
SIZE
INTEGERStatistical information cache size (in bytes) (The initial value is a null value.)
18N_RDAREAINTEGERNumber of RDAREAs for storage of table (1-1024)
0 for a view table or a foreign table
19FIX_TABLECHAR(1)FIX specification
F: Specified
N: Not specified
20VIEW_LEVELINTEGERNumber of nesting levels in view definition
Null value for base tables and foreign tables
21N_BASETABLEINTEGERNumber of base tables used for a view table
Null value for base tables and foreign tables
22ROW_LENGTHINTEGERRow length of a FIX table
Null value for tables that are not FIX tables, view tables, and foreign tables
23N_NOTNULLINTEGERNumber of NOT NULL values2 (Null value for view tables and dictionary tables)
24COMPRESS_TYPEVARCHAR(8)Data compression information:
  • Compression type (first byte)
    S: Data compression (SUPPRESS)
  • Suppressed data type (byte 2 and beyond):
    D: DECIMAL
Null value for tables without SUPPRESS specification, view tables, dictionary tables, and foreign tables
25DIV_TYPECHAR(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
26HASH_NAMEVARCHAR(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.
27N_LOB_COLUMNSMALLINTNumber of columns with BLOB-data type
(Null value for view tables and tables without BLOB columns)
28N_LOB_RDAREAINTEGERNumber 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
29CHANGE_TIMECHAR(14)Time table definition was changed
(YYYYMMDDHHMMSS)
(Null value when a table is initially created.)
30N_DIV_COLUMNSMALLINTNumber of partitioning key columns (216)
Null value for non-partitioned tables, tables with single column partitioning keys specified, view tables, and foreign tables.
31COLUMN_SUP_INFCHAR(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
32N_ADT_COLUMNSMALLINTNumber 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
33WITHOUT_
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
34N_EXCEPT_VALUESINTEGERNumber of exclusion key values in an index
(Null value for indexes without exceptional value specifications and for view tables)
35EXCEPT_VALUES_LENINTEGERTotal length of exclusion key values in an index
(Null value for indexes without exceptional value specifications and for view tables)
36REBALANCECHAR(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
37INDEXLOCK_OPTCHAR(1)Information used by the system
38N_PK_COLUMNSSMALLINTNumber of columns for the primary key
Null value if no primary key is defined.
39FOREIGN_SERVER_
NAME
VARCHAR(30) or MVARCHAR(30)External server name
Null value for tables that are not foreign tables.
40FOREIGN_SERVER_
ID
INTEGERExternal server ID
Null value for tables that are not foreign tables.
41BASE_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.
42BASE_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.
43N_RDAREA_BEFORE_
REBALANCE
INTEGERNumber 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.
44ON_REBALANCECHAR(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.
45SEGMENT_REUSECHAR(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.
46N_REUSE_SEGMENTINTEGERNumber 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.
47REUSE_SEGMENT_SIZECHAR(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.
48REUSE_SEGMENT_SIZE_TYPECHAR(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.
49INSERT_ONLYCHAR(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.
50DELETE_PROHIBIT_TERM_TYPECHAR(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
51DELETE_PROHIBIT_TERMCHAR(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.
52SYSGEN_COLUMN_NAMEVARCHAR(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.
53N_TRIGGERINTEGERNumber of defined triggers
Null value if no trigger is defined, and for view tables, foreign tables, and dictionary tables.
54N_DIV_DIMENSIONSMALLINTNumber of division dimensions
Null value for tables that are not matrix-partitioned tables.
55AUDIT_TABLE_OPTIONCHAR(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
56N_PARENTSSMALLINTNumber of foreign keys
Null value for tables without a defined referential constraint, view tables, and foreign tables.
57N_CHILDRENSMALLINTNumber 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.
58N_FK_COLUMNSSMALLINTTotal number of foreign key columns
Null value for tables without a defined referential constraint, view tables, and foreign tables.
59CHECK_PENDCHAR(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.
60N_CHECKINTEGERNumber of defined check constraints
Null value for tables without a defined referential constraint, view tables, and foreign tables.
61N_CHECK_LIMITINTEGERCheck constraint limit6
Null value for tables without a defined referential constraint, view tables, and foreign tables.
62CHECK_PEND2CHAR(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.
63CHK_SOURCE_LENINTEGERTotal length of search conditions of a check constraint
Null value for tables without a defined referential constraint, view tables, and foreign tables.
64SHAREDCHAR(1)Shared table specification
S: Shared table
Null value: Unshared table
65CHANGE_TIME_INSERT_ONLYCHAR(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.
66N_UPDATE_COLUMNSMALLINTNumber 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.
67TABLE_CREATORVARCHAR(30) or
MVARCHAR(30)
Creator of a public view table
Null value for table that are not public view tables.
68N_ENCRYPTED_COLUMNSMALLINTUsed by the system; always the null value.
69CRYPTO_LIBRARY_TYPECHAR(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.

3 When a segment count unit is specified, the following values are stored:
When K is specified: Specified value [Figure] 1024
When M is specified: Specified value [Figure] 10242
4 Values are stored right-justified. Note that the segment count units (K and M) are not included.
5 The following is stored depending on the type of deletion prevented duration:
When 'I' is specified: +YYYYMMDD. character format
When 'Y', 'M', or 'D' is specified: Right-justified character format
6 The check constraint limit is the sum of the total number of logical operators specified in the search conditions of the check constraints (number of AND and OR specifications, excluding the AND and OR specifications in WHEN search conditions of CASE expressions) and the total number of check constraints.
Example
If a table is defined as follows, the check constraint limit is 4 (the total number of operators (AND and OR) is 2 and the total number of check constraints is 2):

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

(4) SQL_COLUMNS table

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

NumberColumn nameData typeContents
1TABLE_SCHEMAVARCHAR(30) or MVARCHAR(30)Table owner or PUBLIC for a public view table
2TABLE_NAMEVARCHAR(30) or MVARCHAR(30)Name of the table that contains the column
3COLUMN_NAMEVARCHAR(30) or MVARCHAR(30)Column name
4TABLE_IDINTEGERTable ID
5COLUMN_IDSMALLINTColumn ID (integer beginning with 1; values less than 1 are not allowed)
6DATA_TYPECHAR(24)Data type1
7DATA_LENGTHCHAR(7)Column data length is stored right justified in character format (blanks are used for leading zeros)
8IS_NULLABLECHAR(3)Column null information5:
YES: Null value allowed
NO: Null values not allowed
9DIVIDED_KEYCHAR(1)Partitioning key:
Y: Partitioning key
Blank: Not a partitioning key
10CLUSTER_KEYCHAR(1)Cluster key:
Y: Column used for cluster key
Blank: Not a column used for cluster key
11COLUMN_COMMENTVARCHAR(255) or MVARCHAR(255)Comment (The initial value is a null value.)
12BASE_TYPECHAR(1)Base column type8:
C: Column
F: Function, operation
E: Other
Null value for base tables and foreign tables
13BASE_OWNERVARCHAR(30) or MVARCHAR(30)Owner of base table that contains base column
Null value for base tables and foreign tables
14BASE_TABLEVARCHAR(30) or MVARCHAR(30)Name of base table that contains base column
Null value for base tables and foreign tables
15BASE_COLUMNVARCHAR(30) or MVARCHAR(30)Base column name
Null value for base tables and foreign tables
16DEFAULT_COLUMNCHAR(1)WITH DEFAULT specification5
Y: Specified
N: Not specified
Null value for view tables
17COLUMN_OFFSETSMALLINTColumn offset
Null value for tables that are not FIX tables, view tables, and foreign tables.
18HASH_KEYCHAR(1)Hash key:
Y: Hash key
Blank: Other than hash key
19RECOVERY_TYPECHAR(1)RECOVERY specification:
A: ALL
P: PARTIAL
N: NO
(Null value if the data type is not BLOB.)
20LOB_LENGTHCHAR(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.
21LOB_LENGTH_TYPECHAR(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.)
22DATA_TYPE_CODESMALLINTData type code2
23DATA_LENGTH_CODESMALLINTColumn data length code3
24LOB_LENGTH_CODECHAR(8)BLOB column data length
code4, 6
(Null value if the data type is not BLOB or BINARY.)
25DIVCOL_ORDERSMALLINTPartitioning 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.
26SUPPRESS_INFCHAR(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
27PLUGIN_
DESCRIPTION
VARCHAR(255)Plug-in option contents
Null value if no PLUGIN clause is specified, and for foreign tables.
28UDT_OWNERVARCHAR(30)Owner of a user-defined type
Null value if the type is not user-defined, and for foreign tables.
29UDT_NAMEVARCHAR(30)Name of the user-defined type
Null value if the type is not user-defined, and for foreign tables.
30UDT_TYPE_IDINTEGERUser-defined type ID
Null value if the type is not user-defined, and for foreign tables.
31MAX_ELMSMALLINTMaximum number of repetition column elements
(Null value if the column is not a repetition column.)
32NO_SPLITCHAR(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.
33PRIMARY_KEYCHAR(1)Primary key type
Y: Primary key
Blank: Other than the primary key
34COLLATING_SEQUENCECHAR(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.
35TRAILING_SPACECHAR(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.
36SYSTEM_GENERATEDCHAR(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.
37DEFAULT_CLAUSECHAR(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.
38DEFAULT_VALUEVARCHAR(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.
39DEFAULT_VALUE2VARCHAR(32000) or MVARCHAR(32000)7Default 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.
40DEFAULT_VALUE3VARCHAR(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.
41CHECK_COLUMNCHAR(1)Check constraint specification
Y: Specified
Null value for tables in which a check constraint is not defined, view tables, and foreign tables.
42FOREIGN_KEYCHAR(1)Foreign key type
Y: Foreign key configuration table
Null value: Non-foreign key configuration table
43UPDATABLECHAR(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.
44CRYPTO_LIBRARY_TYPECHAR(1)Used by the system; always the null value.
1 The stored value depends on the data type, as follows:
Data typeValue to be stored
INTINTEGER
INTEGER
SMALLINTSMALLINT
DECDECIMAL
DECIMAL
FLOATFLOAT
DOUBLE PRECISION
SMALLFLTSMALLFLT
REAL
CHARCHAR
VARCHARVARCHAR
NCHARNCHAR
NVARCHARNVARCHAR
MCHARMCHAR
MVARCHARMVARCHAR
DATEDATE
TIMETIME
TIMESTAMPTIMESTAMP
INTERVAL YEAR TO DAYINTERVAL YEAR TO DAY
INTERVAL HOUR TO SECONDINTERVAL HOUR TO SECOND
BINARYBINARY
BLOBBLOB
BINARY LARGE OBJECT
Abstract data typeADT
BOOLEANBOOLEAN
2 For the specified data types and the values to be stored, see Table B-2 Data codes and data lengths set in the SQL Descriptor Area.
3 For the DECIMAL, INTERVAL YEAR TO DAY, and INTERVAL HOUR TO SECOND types, precision and scale are each stored in 1 byte. In all other cases, size (number of characters for the NCHAR and NVARCHAR types) is stored in the 2-byte binary format. Note that the value is 0 for the BLOB, BINARY, and abstract data types.
4 The specified column length is stored in binary format in 8 bytes divided into 4-byte segments.
5 If a foreign table is created using the HiRDB External Data Access facility and YES is specified in the NULLABLE column option, YES is assumed in the IS_NULLABLE column and N for the DEFAULT_COLUMN column. If NO is specified in the NULLABLE column option, NOT NULL WITH DEFAULT is assumed, and NO is assumed in the IS_NULLABLE column and Y for the DEFAULT_COLUMN column. Additionally, if NO is specified in the NULLABLE column option, the values in the DEFAULT_COLUMN and N_NOTNULL columns in the SQL_TABLES table are counted.
6 SQL results are not subject to endian conversion, even for connection modes with different endians. Therefore, applications must handle the endian.
7 Specifies NO SPLIT.
8 E (Other) is set when the selection formula is one of the following:
  • Scalar operations (four arithmetic operations, data operation, time operation, CASE expression, and scalar functions)
  • Literal
  • CAST specification
  • Function invocation (excluding plug-in functions)
  • USER
  • CURRENT_DATE
  • CURRENT_TIME
  • CURRENT_TIMESTAMP
9 Table F-6 shows the values that are stored when the DEFAULT clause is specified.

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

Default valueData type1Value stored in DEFAULT_VALUE column, DEFAULT_VALUE2 column, or DEFAULT_VALUE3 column2
Data size (in char format)Default value (character format)
OmittedAllNull valueNull value
NULLAll4'NULL'
USERCHAR and MCHAR4'USER'
VARCHAR and MVARCHAR
CURRENT DATEDATE, or CHAR(10)12'CURRENT[Figure]DATE'3
CURRENT_DATE12'CURRENT_DATE'
CURRENT TIMETIME or CHAR(8)12'CURRENT[Figure]TIME'3
CURRENT_TIME12'CURRENT_TIME'
CURRENT TIMESTAMP(p)
(p: decimal seconds precision)
TIMESTAMP, CHAR(19), CHAR(22), CHAR(24), or CHAR(26)20'CURRENT[Figure]TIMESTAMP(p)'3, 7
CURRENT_TIMESTAMP(p)
(p: decimal seconds precision)
20'CURRENT_TIMESTAMP(p)'7
LitChar string litCharacter string literal
Example 1: 'HiRDB'
Example 2: [Figure]'2002-10-24 10:50:23.1234'
CHAR or MCHARdef-val-size + 24specified-default-value-size4
Example: ''HiRDB''
VARCHAR or MVARCHAR
DATE, TIME, or TIMESTAMPdef-val-size + 24specified-default-value-size4
Example: ''2002-10-24[Figure]10:50:23.1234''
Mixed character string literal
Example: M'100 years'
CHAR or MCHARdef-val-size + 34specified-default-value-size4
Example: 'M'100 years''
VARCHAR or MVARCHAR
National character string literal
Example: N'software'
NCHAR or NVARCHARdef-val-size + 34specified-default-value-size4
Example: 'N'software'''
Hexadecimal character string literal
Example 1: X'48692D43'
Example 2: X'2002102410502312​'
CHAR, VARCHAR, MCHAR, MVARCHAR, or BINARYdef-val-size + 34Example: 'X'48692D43''4, 6
DATE, TIME, or TIMESTAMP(p)Example: 'X'2002102410502312​''4, 6
Num litInteger literal
Example: 10
INTEGER, SMALLINT, DECIMAL, FLOAT, or SMALLFLTdef-val-size5specified-default-value5
Example: '10'
Floating-point literal
Example: 15e + 3
INTEGER, SMALLINT, DECIMAL, FLOAT, or SMALLFLT22 or 23specified-default-value5
Example: '+1.500000000000000​E+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 SECONDdef-val-size5specified-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))
The following abbreviations are used in this table:
Num: Numeric
Lit: Literal
Char: Character
def: default
val: value
[Figure]: 1-byte blank space
1 Excludes BLOB, the abstract data type, and BINARY of 32,001 bytes or greater.
2 If the data size is smaller than 32,001 bytes, the DEFAULT_VALUE2 column and DEFAULT_VALUE3 column become null values. If the data size is 32,001-64,000 bytes, the DEFAULT_VALUE3 column becomes a null value.
3 Blank spaces between CURRENT and DATE, TIME, or TIMESTAMP are edited into a single blank space.
4 The specified default value is stored as a literal expression in the character format. The data size and default value include the literal expressions M, N, X, and apostrophe ('). Therefore, the data size range is 2-32,002 bytes including ' ' for a character string literal, 3-32,003 bytes including M' ' and N' ' for a mixed character string literal and a national character string literal, and 3-64,003 bytes including X' ' for a hexadecimal character string literal.
Bytes 1-32,000 of the specified literal are stored in the DEFAULT_VALUE column; bytes 32,001-64,000 are stored in the DEFAULT_VALUE2 column; and bytes 64,000 and beyond are stored in the DEFAULT_VALUE3 column.
Example:
When 32,000 bytes worth of a default value is specified for the hexadecimal character string literal (a total of 64,003 bytes including X and an apostrophe ('))
VARCHAR(32000) DEFAULT X'C1C1C1...C1C1C1'
The first 32,000 bytes X'C1C1C1... are stored in the DEFAULT_VALUE column.
The next 32,000 bytes C1C1C1... are stored in the DEFAULT_VALUE2 column.
The remaining 3 bytes C1' are stored in the DEFAULT_VALUE3 column.
5 The specified default value is stored as a literal expression in the character format. Size in the character format expression is stored for the data size.
Example:
When a default value is specified for the numeric literal
INTEGER DEFAULT 100
The first 3 bytes 100 are stored in the DEFAULT_VALUE column.
Null values are stored in the DEFAULT_VALUE2 and DEFAULT_VALUE3 columns.
6 The value is all upper-case letters (upper-case letters are stored even when lower-caser letters are specified for the value).
7 If the decimal precision (p) for the CURRENT_TIMESTAMP value to be specified for the default value is omitted, p = 0 is assumed.

(5) SQL_INDEXES table

This 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

NumberColumn nameData typeContents
1TABLE_SCHEMAVARCHAR(30) or MVARCHAR(30)Table owner
2TABLE_NAMEVARCHAR(30) or MVARCHAR(30)Name of the table that contains an index
3INDEX_NAMEVARCHAR(30) or MVARCHAR(30)Index name
4INDEX_IDINTEGERIndex ID
5TABLE_IDINTEGERTable ID
6UNIQUE_TYPECHAR(1)Unique type:
U: Unique
N: Non-unique
7COLUMN_COUNTSMALLINTNumber of columns comprising the index
8CREATE_TIMECHAR(14)Index creation date and time (YYYYMMDDHHMMSS)
9RDAREA_NAMEVARCHAR(30) or MVARCHAR(30)Name of storage RDAREA for non-partitioned index
Null value for partitioning key indexes and foreign indexes
10CLUSTER_KEYCHAR(1)Index type:
Y: Cluster index
N: Non-cluster index
11DIV_INDEXCHAR(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
12FREE_AREASMALLINTPercentage of unused space in each page (%)
0 for foreign indexes
13COLUMN_ID_LISTVARCHAR(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.
14SPLIT_OPTCHAR(1)Page split option:
U: Unbalanced split
Null value for indexes for which unbalanced split is not specified, and foreign indexes.
15ATTR_COUNTSMALLINTNumber of abstract data type attributes constituting an index
Null value for CREATE INDEX (Format 1)
16INDEX_TYPE_OWNERVARCHAR(30) or MVARCHAR(30)Owner of an index type
Null value for CREATE INDEX (Format 1), and foreign indexes
17INDEX_TYPE_NAMEVARCHAR(30) or MVARCHAR(30)Name of an index type
Null value for CREATE INDEX (Format 1), and foreign indexes
18INDEX_TYPE_IDINTEGERIndex type ID
Null value for CREATE INDEX (Format 1), and foreign indexes
19PLUGIN_
DESCRIPTION
VARCHAR(255)Plug-in option contents
Null value if PLUGIN is not specified, and for foreign indexes.
20N_FUNCTIONINTEGERNumber of applied functions
Null value for CREATE INDEX (Format 1), and foreign indexes
21EXCEPT_VALUESCHAR(1)Whether or not exclusion key values are specified:
Y: Specified
N: Not specified
22N_EXCEPT_VALUESSMALLINTNumber of exclusion key values in an index
Null value for indexes without exception value specifications
23ARRAY_TYPECHAR(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.
24LOCK_OPTCHAR(1)Information used by the system
25PRIMARY_KEYCHAR(1)Index type
Y: Primary key index
Null value: Not a primary key index
26DIV_IN_SRVCHAR(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
27SHAREDCHAR(1)Shared index specification
S: Shared index
Null value: Unshared index
1 SQL results are not subject to endian conversion, even for connection modes with different endians. Therefore, applications must handle the endian.

(6) SQL_USERS table

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

NumberColumn nameData typeContents
1USER_IDVARCHAR(30) or MVARCHAR(30)Name of the user with privileges
2DBA_PRIVILEGECHAR(1)DBA privilege:
Y: Has the DBA privilege
N: Does not have the DBA privilege
3SCHEMA_PRIVILEGECHAR(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.
4CREATE_TIMECHAR(14)Schema creation date and time (YYYYMMDDHHMMSS)
The initial value is a null value; also a null value when DROP SCHEMA is executed.
5AUDIT_PRIVILEGECHAR(1)Audit privilege status:
Y: Granted
Null value: Not granted
Null value for any user who is not the auditor.
6AUTH_ERR_COUNTSMALLINTNumber 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.
7CON_LOCK_TIMETIMESTAMP(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.*
8PWD_LOCK_TIMETIMESTAMP(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.
9PASSWORD_TESTCHAR(1)Password limit violation type code
L: Minimum number of allowed bytes
U: Specification of authentication indicator prohibited
S: Specification of single-character type prohibited
Null value if the user for whom the password-invalid account lock state occurs has not been prechecked or if there is no violation after the precheck.
* If the consecutive certification failure account lock is set and no connection is established after the specified account lock period has elapsed, a null value is not set even if the consecutive certification failure account lock state has not occurred.

(7) SQL_RDAREA_PRIVILEGES table

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

NumberColumn nameData typeContents
1GRANTEEVARCHAR(30) or MVARCHAR(30)Name of the user with the RDAREA usage privilege or PUBLIC
2RDAREA_NAMEVARCHAR(30) or MVARCHAR(30)Name of the RDAREA
3GRANT_TIMECHAR(14)Date and time at which the relevant privilege was granted (YYYYMMDDHHMMSS)

(8) SQL_TABLE_PRIVILEGES table

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

NumberColumn nameData typeContents
1GRANTORVARCHAR(30) or MVARCHAR(30)Name of the user granting the table access privileges or the definer of the public view table
2GRANTEEVARCHAR(30) or MVARCHAR(30)Name or role name, of the user who receives table access privilege, or PUBLIC
3TABLE_SCHEMAVARCHAR(30) or MVARCHAR(30)Owner of the table for which access privilege is to be granted. PUBLIC for a public view table.
4TABLE_NAMEVARCHAR(30) or MVARCHAR(30)Name of the table for which access privileges are to be granted
5SELECT_PRIVILEGECHAR(1)SELECT privilege status:
G: Granted (for a table owner)
Y: Granted
N: Not granted
The initial value is N.
6INSERT_PRIVILEGECHAR(1)INSERT privilege status
G: Granted (for a table owner)
Y: Granted
N: Not granted
The initial value is N.
7DELETE_PRIVILEGECHAR(1)DELETE privilege status
G: Granted (for a table owner)
Y: Granted
N: Not granted
The initial value is N.
8UPDATE_PRIVILEGECHAR(1)UPDATE privilege status
G: Granted (for a table owner)
Y: Granted
N: Not granted
The initial value is N.
9GRANT_TIMECHAR(14)Date and time at which the relevant privilege was granted (YYYYMMDDHHMMSS)
10GRANTEE_TYPECHAR(1)Type of table access privilege grantee:
G: Role registered in the directory server
Null if GRANTEE or the user is PUBLIC.

(9) SQL_VIEW_TABLE_USAGE table

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

NumberColumn nameData typeContents
1VIEW_SCHEMAVARCHAR(30) or MVARCHAR(30)Owner of a view table or PUBLIC for a public view table
2VIEW_NAMEVARCHAR(30) or MVARCHAR(30)Name of a view table
3BASE_OWNERVARCHAR(30) or MVARCHAR(30)Owner of the base table or the resource to be used or PUBLIC for a public view table
4BASE_TABLE_NAMEVARCHAR(30) or MVARCHAR(30)Name of the base table or the resource to be used
5BASE_TYPECHAR(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)

(10) SQL_VIEWS table

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

NumberColumn nameData typeContents
1VIEW_SCHEMAVARCHAR(30) or MVARCHAR(30)Owner of a view table or PUBLIC for a public view table
2VIEW_NAMEVARCHAR(30) or MVARCHAR(30)Name of a view table
3SOURCE_ORDERINTEGEROrder if source is divided and stored in multiple rows (1-n)
4IS_UPDATABLECHAR(3)Update possibility:
YES: Possible
NO: Not possible
5VIEW_DEFINITIONVARCHAR(32000) or MVARCHAR(32000)View definition source statements
6VIEW_IDINTEGERView ID

(11) SQL_DIV_TABLE table

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

NumberColumn nameData typeContents
1TABLE_SCHEMAVARCHAR(30) or MVARCHAR(30)Owner of a view table
2TABLE_NAMEVARCHAR(30) or MVARCHAR(30)Name of a view table
3DIV_NOINTEGERPartitioning condition specification order (unique value beginning with 1 for the corresponding table, which is obtained by adding 1 to the partitioning condition specification order)
4TABLE_IDINTEGERTable ID
5DCONDCHAR(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.
6DCVALUESVARCHAR(256) or MVARCHAR(256)Partitioning condition value
(Null value if no partitioning storage condition is specified or if hash partitioning is specified.)
7RDAREA_NAMEVARCHAR(30) or MVARCHAR(30)Name of storage RDAREA
8DCVALUES2VARCHAR(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.

(12) SQL_INDEX_COLINF table

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

NumberColumn nameData typeContents
1TABLE_SCHEMAVARCHAR(30) or MVARCHAR(30)Table owner
2TABLE_NAMEVARCHAR(30) or MVARCHAR(30)Name of the table that contains an index
3INDEX_NAMEVARCHAR(30) or MVARCHAR(30)Index name
4INDEX_IDINTEGERIndex ID
5INDEX_ORDERINTEGEROrder of columns comprising the index (integer beginning with 1, which identifies the name order of columns comprising the index)
6COLUMN_NAMEVARCHAR(30) or MVARCHAR(30)Column name (name of columns comprising the index)
7ASC_DESCCHAR(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.)

(13) SQL_DIV_INDEX table

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

NumberColumn nameData typeContents
1TABLE_SCHEMAVARCHAR(30) or MVARCHAR(30)Table owner
2TABLE_NAMEVARCHAR(30) or MVARCHAR(30)Name of the table that contains an index
3INDEX_NAMEVARCHAR(30) or MVARCHAR(30)Index name
4DIV_NOINTEGERRDAREA definition order (unique value beginning with 1 for the corresponding index which is obtained by adding 1 to the RDAREA definition order)1
5INDEX_IDINTEGERIndex ID
6RDAREA_NAMEVARCHAR(30) or MVARCHAR(30)Name of partitioned storage RDAREA comprising the index)
1 This value is not related to DIV_NO of SQL_DIV_TABLE.

(14) SQL_DIV_COLUMN table

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

NumberColumn nameData typeContents
1TABLE_SCHEMAVARCHAR(30) or MVARCHAR(30)Table owner
2TABLE_NAMEVARCHAR(30) or MVARCHAR(30)Table name
3COLUMN_NAMEVARCHAR(30) or MVARCHAR(30)Column name
4DIV_NOINTEGERStorage order
5RDAREA_NAMEVARCHAR(30) or MVARCHAR(30)Name of the user LOB RDAREA
6STORE_NOINTEGERAlways 1
7MASTER_RDAREA_
NAME
VARCHAR(30) or MVARCHAR(30)Name of user RDAREA for the corresponding table
8N_LEVELSMALLINTNumber of levels
(Null value for BLOB type columns)
9COMPONENT_
NAME
VARCHAR(30) or MVARCHAR(30)Component name
(Null value for BLOB type columns)
10LOB_NOSMALLINTLOB attribute number
(Null value for BLOB type columns)

(15) SQL_ROUTINES table

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

NumberColumn nameData typeContents
1ROUTINE_SCHEMAVARCHAR(30) or MVARCHAR(30)Routine owner
2ROUTINE_NAMEVARCHAR(30) or MVARCHAR(30)Routine name10
3OBJECT_IDINTEGERObject ID
4SPECIFIC_NAMEVARCHAR(30) or MVARCHAR(30)Specific name2
5ROUTINE_TYPECHAR(1)Routine type:
P: Procedure
F: Function
6ROUTINE_VALIDCHAR(1)Validity flag:
Y: Validity routine
N: Invalidity routine
7INDEX_VALIDCHAR(1)Index status change flag:
Y: Index status valid1
N: Index status invalid1
8CREATE_TIMECHAR(14)Routine creation date and time (YYYYMMDDHHMMSS)
SQL analysis time for SQL procedure statements or definition creation time for external routines
9ALTER_TIMECHAR(14)Routine re-creation date and time (YYYYMMDDHHMMSS)
(The initial value is a null value.)
10OBJECT_SIZEINTEGERObject size (in bytes)
0 for external routines
11SOURCE_SIZEINTEGERDefinition source size (bytes)
0 for external routines and registry operation procedures
12ISOLATION_LEVELSMALLINTData guarantee level (0-2)
Valid for procedures
13OPTIMIZE_LEVELINTEGERSQL optimization option (converted to decimal format)
Specifies the value of OPTIMIZE LEVEL for CREATE PROCEDURE, ALTER PROCEDURE, CREATE TYPE, or ALTER ROUTINE.
14SQL_LEVELSMALLINTSQL level (0-2)
Valid for procedures
15N_PARAMINTEGERNumber of parameters
16N_RESOURCEINTEGERNumber of resources used in an object
17PARAM_LOCATIONINTEGERStart position of a procedure statement in a definition source statement.8
18ROUTINE_
COMMENT
VARCHAR(255) or
MVARCHAR(255)
Comment
(The initial value is a null value.)
19DEF_SOURCEBLOBDefinition source statement (not including compiler options)
Null value for foreign routines (excluding Java routines), registry operation procedures, and trigger action procedures.
20ROUTINE_ADT_OWNERVARCHAR(30)Owner of the abstract data type that defined routines
(Null value for routines that are not defined inside the abstract data type)
21ROUTINE_ADT_NAMEVARCHAR(30)Name of the abstract data type that defined routines
(Null value for routines that are not defined inside the abstract data type)
22ROUTINE_BODYCHAR(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.
23FUNCTION_TYPECHAR(1)Function type:
C: System-defined function constructor
Blank: User-defined function
(Null value for procedures)
24EXTERNAL_NAMEVARCHAR(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.
25EXTERNAL_LANGUAGECHAR(20)External descriptive language type:
C: C language
Java: Java language
Null value if the language type is not for a foreign function.
26PARAMETER_STYLEVARCHAR(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.
27ENCAPSULATION_
LEVEL
VARCHAR(10)Encapsulation level (PUBLIC, PRIVATE, or PROTECTED)
(Null value for routines that are not defined inside the abstract data type.)
28RETURN_UDT_OWNERVARCHAR(30) or MVARCHAR(30)Owner of a return value data type
(Null value if the return value is not a user-defined function.)
29RETURN_UDT_NAMEVARCHAR(30) or MVARCHAR(30)Name of a return value data type
(Null value if the return value is not a user-defined function.)
30RETURN_UDT_TYPE_
ID
INTEGERID of a return value data type
(Null value if the return value is not a user-defined function.)
31RETURN_DATA_TYPECHAR(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.)
32RETURN_DATA_TYPE _CODESMALLINTCode for a return value data type3
(Null value if the return value data type is not a function.)
33RETURN_DATA_
LENGTH_CODE
SMALLINTCode for a return value data length4
(Null value for procedures)
34RETURN_DATA_
LENGTH
CHAR(7)Return value data length stored right-justified in character format (blanks are used for leading zeros)
(Null value for procedures)
35RETURN_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.)
36RETURN_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.)
37RETURN_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.)
38ADDITIONAL_
OPTIMIZE_LEVEL
INTEGERExtended 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.
39CLASS_NAMEVARCHAR(255)package-name.class-name6
Null value if the foreign routine is not coded in Java.
40JAR_NAMEVARCHAR(255)Java archive file name
Null value if the foreign routine is not coded in Java.
41DYNAMIC_RESULT_
SETS
SMALLINTMaximum number of result sets to be returned
Null value if no maximum number is specified for the result sets.
42SQL_
SPECIFICATION
CHAR(1)Data access specification:
C: CONTAINS SQL
M: MODIFIES SQL
N: NO SQL
R: Used by the system; always the null value.
43RETURNS_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.
44RETURNS_JAVA_
DATA_TYPE_CODE
INTEGERJava return value's data type code corresponding to return value's data type7
Null value if the foreign routine is not coded in Java.
45RETURN_DATA_
MAX_ELM
SMALLINTMaximum number of elements for return value's data type
Null value if ARRAY is not specified for the return value data type.
46N_JAVA_RESULT_
SETS
INTEGERNumber of Java.sql.ResultSet[]s specified
Null value if Java.sql.ResultSet[] is not specified.
47FOR_UPDATE_EXCLUSIVE_LOCKCHAR(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.
48SUBSTR_LENGTHSMALLINTSpecification 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).
1 Index information in the routine is invalid (the routine cannot be executed). In this case, SQL objects must be re-created by ALTER ROUTINE or ALTER PROCEDURE.
2 For procedures, this name is the same as the routine name; for functions, the system internally generates a name from the routine name and object ID as follows:
F routine name (up to 19 bytes) object ID (10 bytes)
3 For details about the specified data type and values to be stored, see Table B-2 Data codes and data lengths set in the SQL Descriptor Area.
4 For the DECIMAL, INTERVAL YEAR TO DAY, and INTERVAL HOUR TO SECOND types, precision and scale are each stored in 1 byte. In all other cases, size (number of characters for the NCHAR and NVARCHAR types) is stored in the 2-byte binary format. Note that the value is 0 for the BLOB and abstract data types.
5 The specified column length is stored in binary format in 8 bytes, divided into 4-byte segments.
6 The following shows the storage format for package-name.class-name:
  • Package name specified
    package-name.class-name
  • Package name not specified
    class-name
7 The following Java data types are stored as a character string in RETURN_JAVA_DATA_TYPE. The Java data types expressed in hexadecimal numbers are stored in RETURN_JAVA_DATA_TYPE_CODE.
Java data typeValue in hexadecimal
byte[]1000
byte[][]100A
short1002
short[]1003
int1004
int[]1005
float1006
float[]1007
double1008
double[]1009
java.match.BigDecimal2000
java.match.BigDecimal[]2001
java.lang.String2002
java.lang.String[]2003
java.sql.Date2004
java.sql.Date[]2005
java.sql.Time2006
java.sql.Time[]2007
java.lang.Double2008
java.lang.Double[]2009
java.lang.Float200A
java.lang.Float[]200B
java.lang.Integer200C
java.lang.Integer[]200D
java.lang.Short200E
java.lang.Short[]200F
java.sql.Timestamp2010
java.sql.Timestamp[]2011
void0000
8 The location at which the procedure statement starts is counted from the top of the SQL statement, beginning at 1. For an external routine (Java routine), the location at which the external routine specification (EXTERNAL NAME clause) begins is counted from the top of the SQL statement. A value of 0 is set for the following:
  • External routine (excluding Java routines)
  • Registry manipulation procedure
  • Trigger action procedure
9 SQL results are not subject to endian conversion, even for connection modes with different endians. Therefore, applications must handle the endian.
10 For a trigger action procedure, the following routine name (22 bytes long) is stored:
'(TRIGyyyymmddhhmmssth)'
yyyymmddhhmmssth: Time stamp at the time of trigger definition (units: 1/100 seconds)

(16) SQL_ROUTINE_RESOURCES table

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

NumberColumn nameData typeContents
1ROUTINE_SCHEMAVARCHAR(30) or MVARCHAR(30)Routine owner
2ROUTINE_NAMEVARCHAR(30) or MVARCHAR(30)Routine name
3SPECIFIC_NAMEVARCHAR(30) or MVARCHAR(30)Specific name1
4BASE_OWNERVARCHAR(30) or MVARCHAR(30)Resource owner or PUBLIC for a public view table
5BASE_NAMEVARCHAR(30) or MVARCHAR(30)Resource identifier
6BASE_TYPECHAR(1)Resource type:
R: Base table
V: View table
I: Index
D: Data type
P: Routine
F: External table
T: Trigger
7ROUTINE_TYPE_OWNERVARCHAR(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.)
8ROUTINE_TYPE_NAMEVARCHAR(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.)
9SELECT_OPERATION2CHAR(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
10INSERT_OPERATION2CHAR(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
11UPDATE_OPERATION2CHAR(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
12DELETE_OPERATION2CHAR(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
13LOCK_OPERATION2CHAR(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
14PURGE_OPERATION2CHAR(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
1 For procedures, this name is the same as the routine name; for functions, the system internally generates a name from the routine name and object ID as follows:

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

2 If a view table is used as an SQL object, information that merges the operation types of all view tables being used is set in the base table (the highest order base table if the base table is a view table) that is the base for the view table being used as the SQL object.
3 If the type of resource being used is a view table (V), a null value is set for a view table that is not actually contained in the SQL object.

(17) SQL_ROUTINE_PARAMS table

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

NumberColumn nameData typeContents
1ROUTINE_SCHEMAVARCHAR(30) or MVARCHAR(30)Routine owner
2ROUTINE_NAMEVARCHAR(30) or MVARCHAR(30)Routine name
3SPECIFIC_NAMEVARCHAR(30) or MVARCHAR(30)Specific name
4PARAMETER_NAMEVARCHAR(30) or MVARCHAR(30)Parameter name5
5PARAMETER_NOINTEGERParameter specification sequence (a unique number within the routine beginning with 1)
6DATA_TYPECHAR(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.)
7DATA_LENGTHCHAR(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.)
8LOB_LENGTHCHAR(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.)
9LOB_LENGTH_TYPECHAR(1)Column length type:
K: K specified
M: M specified
G: G specified
Blank: Default
(Null value if the data type is not BLOB.)
10PARAMETER_MODECHAR(5)Parameter I/O mode:
IN: Input mode
NOUT: Output mode
INOUT: Input/output mode
NONE: Other than above
11DATA_TYPE_CODESMALLINTData type code1
(Null value if the data type is BLOB.)
12DATA_LENGTH_CODESMALLINTData length code2
(Null value if the data type is BLOB, BINARY, or a user-defined type.)
13LOB_LENGTH_CODECHAR(8)Column length specification
value3, 4
(Null value if the data type is not BLOB or BINARY.)
14UDT_OWNERVARCHAR(30) or MVARCHAR(30)Owner of a data type parameter
(Null value if the parameter is the system-defined type.)
15UDT_NAMEVARCHAR(30) or MVARCHAR(30)Name of a data type parameter
(Null value if the parameter is the system-defined type.)
16UDT_TYPE_IDINTEGERID of a data type parameter
(Null value if the parameter is the system-defined type.)
17JAVA_DATA_TYPEVARCHAR(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.
18JAVA_DATA_TYPE_CODEINTEGERData 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.
19MAX_ELMSMALLINTMaximum number of parameter elements
Null value if the number of parameter elements is not specified.
20TRIGGER_COLUMNCHAR(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.
21TRIGGER_TABLE_IDINTEGERTable 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.
22TRIGGER_COLUMN_NAMEVARCHAR(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.
1 For the specified data types and the values to be stored, see Table B-2 Data codes and data lengths set in the SQL Descriptor Area.
2 For the DECIMAL, INTERVAL YEAR TO DAY, and INTERVAL HOUR TO SECOND types, precision and scale are each stored in 1 byte. In all other cases, size (number of characters for the NCHAR and NVARCHAR types) is stored in the 2-byte binary format. Note that the value is 0 for the BLOB and abstract data types.
3 The specified column length is stored in binary format in 8 bytes, divided into 4-byte segments.
4 SQL results are not subject to endian conversion, even for connection modes with different endians. Therefore, applications must handle the endian.
5 For a trigger action procedure, the following parameter name (27 bytes long) is used:

'(T#tbl_id#col_id#nnnnn)'

tbl_id
Table ID (hexadecimal, 8 digits (If the number of digits is less than 8, the front portion is zero filled.))
col_id
Column ID (hexadecimal, 8 digits (If the number of digits is less than 8, the front portion is zero filled.))
nnnnn
00001: Parameter that corresponds to a column modified by an old values correlation name
00002: Parameter that corresponds to a column modified by a new values correlation name

(18) SQL_ALIASES table

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

NumberColumn nameData typeContents
1ALIAS_SCHEMAVARCHAR(30) or MVARCHAR(30)Owner of the alias
2ALIAS_NAMEVARCHAR(30) or MVARCHAR(30)Alias
3ALIAS_TYPECHAR(1)Alias type:
T: Table
Blank: Others
4RDNODE_NAMEVARCHAR(30) or MVARCHAR(30)RD node name
5BASE_SCHEMAVARCHAR(30) or MVARCHAR(30)Owner of the alias or PUBLIC for a public view table.
6BASE_NAMEVARCHAR(30) or MVARCHAR(30)Name of the alias

(19) SQL_TABLE_STATISTICS table

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

NumberColumn nameData typeContents
1TABLE_SCHEMAVARCHAR(30) or MVARCHAR(30)Table owner
2TABLE_NAMEVARCHAR(30) or MVARCHAR(30)Table name
3N_PAGEFLOATNumber of pages stored (statistical information)
Null value if lvll is specified for the -c option of pdgetcst
4N_ROWFLOATTotal number of rows (statistical information)
5UPDATE_TIMECHAR(14)Update date and time (YYYYMMDDHHMMSS)

(20) SQL_COLUMN_STATISTICS table

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

NumberColumn nameData typeContents
1TABLE_SCHEMAVARCHAR(30) or MVARCHAR(30)Table owner
2TABLE_NAMEVARCHAR(30) or MVARCHAR(30)Name of the table that contains a column
3COLUMN_NAMEVARCHAR(30) or MVARCHAR(30)Column name
4N_UNIQUEFLOATNumber of unique values (statistical information)
5N_MAX_DUP_KEYFLOATMaximum number of duplicate key values (statistical information)
6N_MIN_DUP_KEYFLOATMinimum number of duplicate key values (statistical information)
7N_NULLFLOATNumber of null values
8UPDATE_TIMECHAR(14)Update date and time (YYYYMMDDHHMMSS)
9RANGE_VALUESVARCHAR(2464)Column value frequency distribution information (statistical information)1
1 The maximum and minimum column values set in the pdgetcst parameter file are stored in the RANGE_VALUES column after being converted into an internal format. To reference these maximum and minimum values, the SQL described as follows must be executed. The retrieval results are displayed in hexadecimal.
  • SQL for retrieving the maximum column value

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

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

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

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

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

Output result (when maximum column value is 10)
'0000000A'

(21) SQL_INDEX_STATISTICS table

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

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

Table F-23 shows the contents of the SQL_INDEX_STATISTICS table.

Table F-23 SQL_INDEX_STATISTICS table contents

NumberColumn nameData typeContents
1TABLE_SCHEMAVARCHAR(30) or MVARCHAR(30)Table owner
2TABLE_NAMEVARCHAR(30) or MVARCHAR(30)Name of the table that contains the index
3INDEX_NAMEVARCHAR(30) or MVARCHAR(30)Index name
4N_ENTRYFLOATNumber of key entries (statistical information)
5N_IXPGFLOATNumber of leaf pages (statistical information)
6N_LEVELSMALLINTNumber of levels (statistical information)
7SEQ_RATIOINTEGERSequential level (statistical information)
8UPDATE_TIMECHAR(14)Update date and time (YYYYMMDDHHMMSS)

(22) SQL_DATATYPES table

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

NumberColumn nameData typeContents
1TYPE_SCHEMAVARCHAR(30) or MVARCHAR(30)Owner of the user-defined type
2TYPE_NAMEVARCHAR(30) or MVARCHAR(30)Name of the user-defined type
3META_TYPECHAR(1)Type of the user-defined type:
A: Abstract data type
4TYPE_IDINTEGERID of the user-defined type
5N_ATTRSMALLINTNumber of attributes
6CREATE_TIMECHAR(14)Creation date and time (YYYYMMDDHHMMSS)
7N_SUBTYPEINTEGERNumber of subtypes
8SOURCE_SCHEMAVARCHAR(30) or MVARCHAR(30)Owner of the supertype abstract data type
(Null value if there is no supertype abstract data type.)
9SOURCE_NAMEVARCHAR(30) or MVARCHAR(30)Name of the supertype abstract data type
(Null value if there is no supertype abstract data type.)
10SOURCE_TYPE_IDINTEGERID of the supertype abstract data type
(Null value if there is no supertype abstract data type.)
11ROOT_TYPE_IDINTEGERID of the highest order abstract data type if the supertype abstract data type also has a supertype
12LEVEL_NOSMALLINTNumber of generations from highest order supertype abstract data type if the supertype abstract data type also has a supertype
13TYPE_COMMENTVARCHAR(255)Comment
(The initial value is a null value; null value is also used if there is no comment.)
14N_LOB_ATTRSMALLINTNumber of BLOB-type attributes
15N_ADT_ATTRSMALLINTNumber of abstract-data-type attributes
16N_LARGE_BINARY_ATTRSMALLINTNumber of attributes for BINARY-type data of 32,001 bytes or more

(23) SQL_DATATYPE_DESCRIPTORS table

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

NumberColumn nameData typeContents
1TYPE_SCHEMAVARCHAR(30) or MVARCHAR(30)Owner of the user-defined type
2TYPE_NAMEVARCHAR(30) or MVARCHAR(30)Name of the user-defined type
3OBJECT_NAMEVARCHAR(30) or MVARCHAR(30)Attribute name
4TYPE_IDINTEGERID of the user-defined type
5META_TYPECHAR(1)Type of the user-defined type:
S: System-defined type
A: Abstract data type
6ORDINAL_POSITIONSMALLINTOrder position
7ENCAPSULATION_
LEVEL
VARCHAR(10)Encapsulation level (PUBLIC, PRIVATE, or PROTECTED)
8IS_NULLABLECHAR(3)Column null value information
YES: Null value allowed
NO: Null values not allowed
9DATA_TYPECHAR(24)Data type
For details about the storage format, see the DATA_TYPE column in the SQL_COLUMNS table.
10DATA_TYPE_CODESMALLINTData type code1
11DATA_LENGTH_CODESMALLINTData length code2
(Null value if the data type is BLOB, BINARY, or a user-defined type)
12DATA_LENGTHCHAR(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.)
13LOB_LENGTH_CODECHAR(8)BLOB attribute length code3, 4
(Null value if the code is not for BLOB or BINARY.)
14LOB_LENGTHCHAR(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.
15LOB_LENGTH_TYPECHAR(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.)
16UDT_OWNERVARCHAR(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.)
17UDT_NAMEVARCHAR(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.)
18DATA_COMMENTVARCHAR(255)Comment
(The initial value is a null value; null value is also used if there is no comment.)
19NO_SPLITCHAR(1)Whether or not NO SPLIT is specified:
Y: Specified
Null value: No specification
1 For the specified data types and the values to be stored, see Table B-2 Data codes and data lengths set in the SQL Descriptor Area.
2 For the DECIMAL, INTERVAL YEAR TO DAY, and INTERVAL HOUR TO SECOND types, precision and scale are each stored in 1 byte. In all other cases, size (number of characters for the NCHAR and NVARCHAR types) is stored in the 2-byte binary format. Note that the value is 0 for the BLOB and abstract data types.
3 The specified column length is stored in binary format in 8 bytes, divided into 4-byte segments.
4 SQL results are not subject to endian conversion, even for connection modes with different endians. Therefore, applications must handle the endian.

(24) SQL_TABLE_RESOURCES table

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

NumberColumn nameData typeContents
1TABLE_SCHEMAVARCHAR(30) or MVARCHAR(30)Table owner
2TABLE_NAMEVARCHAR(30) or MVARCHAR(30)Table name
3BASE_OWNERVARCHAR(30) or MVARCHAR(30)Owner of the resource used
4BASE_NAMEVARCHAR(30) or MVARCHAR(30)ID of the resource used
5BASE_TYPECHAR(1)Type of the resource used:
A: Abstract data type

(25) SQL_PLUGINS table

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

NumberColumn nameData typeContents
1PLUGIN_SCHEMAVARCHAR(30) or MVARCHAR(30)Plug-in owner
2PLUGIN_NAMEVARCHAR(30) or MVARCHAR(30)Plug-in name
3PLUGIN_TYPECHAR(1)Plug-in type:
D: Data type plug-in
I: Index type plug-in
4TYPE_SCHEMAVARCHAR(30) or MVARCHAR(30)Owner of the abstract data type or index type
5TYPE_NAMEVARCHAR(30) or MVARCHAR(30)Name of the abstract data type or index type
6CREATE_TIMECHAR(14)Plug-in creation time
7PLUGIN_LIB_NAMEVARCHAR(255)Library path name
8PLUGIN_COMMENTVARCHAR(255)Comment
(The initial value is a null value; null value is also used if there is no comment.)
9PLUGIN_VERSIONVARCHAR(10)Plug-in version
(Null value if the plug-in is the initial version.)
10PLUGIN_EXT_FUNCVARCHAR(255)Plug-in extended function code (information used in the system)

(26) SQL_PLUGIN_ROUTINES table

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

NumberColumn nameData typeContents
1ROUTINE_SCHEMAVARCHAR(30) or MVARCHAR(30)Routine owner
2PLUGIN_NAMEVARCHAR(30) or MVARCHAR(30)Plug-in name
3OPERATION_NAMEVARCHAR(255)Operation name
4SPECIFIC_NAMEVARCHAR(30) or MVARCHAR(30)Specific name1
5N_PARAMINTEGERNumber of parameters
6TIMING_DESCRIPTORVARCHAR(30)Timing descriptor
7OPERATION_
DESCRIPTOR
VARCHAR(255)Operation modification information
1 A plug-in routine is named in the following format:
'P' function-name registration-date-and-time
P
Code that indicates a function provided by a plug-in
function-name
The leading characters (maximum 15 characters) are truncated so that the specific name is within 30 characters.
registration-date-and-time
Indicates the year, month, hour, minute, and second with 14 characters.

(27) SQL_PLUGIN_ROUTINE_PARAMS table

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

NumberColumn nameData typeContents
1ROUTINE_SCHEMAVARCHAR(30) or MVARCHAR(30)Owner
2PLUGIN_NAMEVARCHAR(30) or MVARCHAR(30)Plug-in name
3SPECIFIC_NAMEVARCHAR(30) or MVARCHAR(30)Specific name
4PARAMETER_NAMEVARCHAR(30) or MVARCHAR(30)Parameter name
5PARAMETER_MODECHAR(7)Parameter I/O attribute:
IN: Input mode
OUT: Output mode
INOUT: Input/output mode
RETURNS: Return value attribute
PICKUP: ROWID output attribute
6PARAMETER_ DESCRIPTORVARCHAR(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 )
7SPECIFIC_BIND_ OPERATION_NAMEVARCHAR(30) or MVARCHAR(30)Specific bind operation name
(Null value if bind operation is not specified.)
8PARAMETER_TYPECHAR(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.
9PARAMETER_NOINTEGERParameter specification order position for abstract data type functions
10DATA_TYPECHAR(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.)
11DATA_TYPE_CODESMALLINTParameter data code1
(Null value if the parameter mode is D, K, P, R, U, or T.)
12DATA_LENGTH_
CODE
SMALLINTParameter data type definition length code2
(Null value if the parameter mode is D, K, P, R, U, or T.)
13DATA_LENGTHCHAR(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.)
14LOB_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.
15LOB_LENGTHCHAR(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.
16LOB_LENGTH_TYPECHAR(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.)
17UDT_OWNERVARCHAR(30) or MVARCHAR(30)Parameter data type owner
(Null value if the data type is not a user-defined type.)
18UDT_NAMEVARCHAR(30) or MVARCHAR(30)Parameter data type name
(Null value if the data type is not a user-defined type.)
19UDT_TYPE_IDINTEGERParameter data type ID
(Null value if the data type is not a user-defined type.)
1 For the specified data types and the values to be stored, see Table B-2 Data codes and data lengths set in the SQL Descriptor Area.
2 For the DECIMAL, INTERVAL YEAR TO DAY, and INTERVAL HOUR TO SECOND types, precision and scale are each stored in 1 byte. In all other cases, size (number of characters for the NCHAR and NVARCHAR types) is stored in the 2-byte binary format. Note that the value is 0 for the BLOB and abstract data types.
3 The specified column length is stored in binary format in 8 bytes, divided into 4-byte segments.
4 SQL results are not subject to endian conversion, even for connection modes with different endians. Therefore, applications must handle the endian.

(28) SQL_INDEX_TYPES table

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

NumberColumn nameData typeContents
1INDEX_TYPE_
SCHEMA
VARCHAR(30) or MVARCHAR(30)Index type owner
2INDEX_TYPE_NAMEVARCHAR(30) or MVARCHAR(30)Index type name
3INDEX_TYPE_IDINTEGERIndex type ID
4CREATE_TIMECHAR(14)Creation time
5ADT_OWNERVARCHAR(30) or MVARCHAR(30)Abstract data type owner
6ADT_NAMEVARCHAR(30) or MVARCHAR(30)Abstract data type name
7N_FUNCTIONINTEGERNumber of abstract data type functions that can be used in an index-type-defined index

(29) SQL_INDEX_RESOURCES table

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

NumberColumn nameData typeContents
1TABLE_SCHEMAVARCHAR(30) or MVARCHAR(30)Owner of the index definition table
2INDEX_NAMEVARCHAR(30) or MVARCHAR(30)Index name
3BASE_OWNERVARCHAR(30) or MVARCHAR(30)Owner of the resource used
4BASE_NAMEVARCHAR(30) or MVARCHAR(30)ID of the resource used
5BASE_TYPECHAR(1)Type of the resource used:
I: Index type

(30) SQL_INDEX_DATATYPE table

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

NumberColumn nameData typeContents
1TABLE_SCHEMAVARCHAR(30) or MVARCHAR(30)Table owner
2TABLE_NAMEVARCHAR(30) or MVARCHAR(30)Name of the table that contains the index
3INDEX_NAMEVARCHAR(30) or MVARCHAR(30)Index name
4INDEX_IDINTEGERIndex ID
5COLUMN_NAMEVARCHAR(30) or MVARCHAR(30)Column name (index column name)
6N_LEVELSMALLINTNumber of levels (number used to identify the name order of attributes constituting an abstract data type)
7ADT_OWNERVARCHAR(30) or MVARCHAR(30)Owner of the abstract data type
8ADT_NAMEVARCHAR(30) or MVARCHAR(30)Name of the abstract data type
9ADT_ATTR_NAMEVARCHAR(30) or MVARCHAR(30)Name of the abstract data type attribute
10ADT_ATTR_IDSMALLINTAttribute position

(31) SQL_INDEX_FUNCTION table

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

NumberColumn nameData typeContents
1TABLE_SCHEMAVARCHAR(30) or MVARCHAR(30)Table owner
2TABLE_NAMEVARCHAR(30) or MVARCHAR(30)Name of the table that contains the index
3INDEX_NAMEVARCHAR(30) or MVARCHAR(30)Index name
4INDEX_IDINTEGERIndex ID
5COLUMN_NAMEVARCHAR(30) or MVARCHAR(30)Column name (index column name)
6ADT_OWNERVARCHAR(30) or MVARCHAR(30)Owner name of the abstract data type function
7ADT_FUNCTION_
NAME
VARCHAR(30) or MVARCHAR(30)Name of the abstract data type function (routine name)
8ADT_FUNCTION_
OBJECT_ID
INTEGERObject ID of the abstract data type function

(32) SQL_TYPE_RESOURCES table

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

NumberColumn nameData typeContents
1TYPE_SCHEMAVARCHAR(30) or MVARCHAR(30)User-defined type owner
2TYPE_NAMEVARCHAR(30) or MVARCHAR(30)User-defined type name
3BASE_OWNERVARCHAR(30) or MVARCHAR(30)Owner of the resource used
4BASE_NAMEVARCHAR(30) or MVARCHAR(30)ID of the resource used
5BASE_TYPECHAR(1)ID of the resource used
A: Abstract data type

(33) SQL_INDEX_TYPE_FUNCTION table

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

NumberColumn nameData typeContents
1INDEX_TYPE_
SCHEMA
VARCHAR(30) or MVARCHAR(30)Index type owner
2INDEX_TYPE_NAMEVARCHAR(30) or MVARCHAR(30)Index name
3ADT_OWNERVARCHAR(30) or MVARCHAR(30)Owner of the abstract data type function
4ADT_FUNCTION_
NAME
VARCHAR(30) or MVARCHAR(30)ID of the abstract data type function1
5ADT_FUNCTION_
OBJECT_ID
INTEGERObject ID of the abstract data type function
1 This is not a specific name.

(34) SQL_EXCEPT table

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

NumberColumn nameData typeContents
1TABLE_SCHEMAVARCHAR(30) or MVARCHAR(30)Index owner
2TABLE_NAMEVARCHAR(30) or MVARCHAR(30)Name of the table that contains the index
3INDEX_NAMEVARCHAR(30) or MVARCHAR(30)Index name
4INDEX_IDINTEGERIndex ID
5TABLE_IDINTEGERTable ID
6EXCEPT_VALUEVARCHAR(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.)

(35) SQL_FOREIGN_SERVERS table

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

NumberColumn nameData typeContents
1FOREIGN_SERVER_
NAME
VARCHAR(30) or MVARCHAR(30)Foreign server name
Null value after DROP SERVER is executed.3
2FOREIGN_SERVER_IDINTEGERForeign server ID
3FOREIGN_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
4FOREIGN_SERVER_
VERSION
VARCHAR(30)Server version1
Null value after DROP SERVER is executed.3
5AUTHORIZATION_
IDENTIFIER
VARCHAR(30) or MVARCHAR(30)Foreign server owner
Null value after DROP SERVER is executed.3
6CREATE_TIMECHAR(14)Foreign server creation time (YYYYMMDDHHMMSS)
Null value after DROP SERVER is executed.3
7CHANGE_TIMECHAR(14)Foreign server definition change time (YYYYMMDDHHMMSS)
Null value when a row is created and after DROP SERVER is executed.3
8N_FOREIGN_TABLEINTEGERNumber of tables defined in the foreign server
9USING_BESCHAR(8)Name of the back-end server that accesses the foreign server.2
Null value after DROP SERVER is executed.3
1 The server type and server version of the foreign server accessed by HiRDB are set as follows:
DBMS product nameServer typeServer version
XDM/RD E2XDMRD6.0
HiRDB Version 5.0HIRDB5.0
HiRDB Version 6HIRDB6.0
HiRDB Version 7HIRDB6.0
Oracle8.1.5 (for the HP-UX version)ORACLE8.1.5
Oracle8.1.7 (for the AIX 5L version)ORACLE8.1.5
DB2 Universal Database for OS/390 Version 6DB2_UDB_OS3906.0
2 If the name is less than 8 bytes when left justified, the remaining spaces are filled with blank spaces.
3 If DROP SERVER is executed to reuse a foreign server ID, the row is not deleted and all columns except the one for a foreign server ID (FOREIGN_SERVER_ID) become null values. Note however that the number of defined tables (N_FOREIGN_TABLE) becomes 0. When CREATE SERVER is subsequently executed, the minimum value among the unused foreign server IDs is assigned. If there are no unused foreign server IDs, maximum-value + 1 is assigned.

(36) SQL_USER_MAPPINGS table

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

NumberColumn nameData typeContents
1AUTHORIZATION_
IDENTIFIER
VARCHAR(30) or MVARCHAR(30)HiRDB authorization identifier that is the conversion source of mapping (always PUBLIC)
2FOREIGN_SERVER_
NAME
VARCHAR(30) or VARCHAR(30)Name of the external server
3FOREIGN_SERVER_IDINTEGERExternal server ID
4CREATE_TIMECHAR(14)User mapping creation date and time (YYYYMMDDHHMMSS)
5CHANGE_TIMECHAR(14)User mapping definition modification date and time (YYYYMMDDHHMMSS)
6USER_IDVARCHAR(30) or VARCHAR(30)User name at the external server

(37) SQL_IOS_GENERATIONS table contents

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

NumberColumn nameData typeContents
1FILE_SYSTEM_NAMEVARCHAR(165)HiRDB file system area name (absolute path name)
2GENERATION_NUMBERSMALLINTGeneration number
3SERVER_NAMECHAR(8)Server name (BES or SDS)*
4ORIGINAL_FILE_SYSTEM_NAMEVARCHAR(165)Original HiRDB file system area name (absolute path name)
* Even when a dictionary table of a HiRDB/Parallel Server is used in a HiRDB/Single Server without any modification, the server name is not changed.
If the name is less than 8 characters when left justified, the remaining spaces are filled with blank spaces.

(38) SQL_TRIGGERS table contents

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

NumberColumn nameData typeContents
1TRIGGER_SCHEMAVARCHAR(30) or
MVARCHAR(30)
Trigger owner
2TRIGGER_NAMEVARCHAR(30) or
MVARCHAR(30)
Trigger name
3OBJECT_IDINTEGERObject ID
4TABLE_SCHEMAVARCHAR(30) or
MVARCHAR(30)
Owner of the table for which the trigger is defined.
5TABLE_NAMEVARCHAR(30) or
MVARCHAR(30)
Name of the table for which the trigger is defined.
6TRIGGER_VALIDCHAR(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
7INDEX_VALIDCHAR(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
8ACTION_TIMECHAR(1)Trigger action timing
A: AFTER
B: BEFORE
9EVENTCHAR(1)Trigger event type
I: INSERT
D: DELETE
U: UPDATE
10ACTION_TYPECHAR(1)Trigger action unit
R: ROW
S: STATEMENT
11OLD_ROW_NAMEVARCHAR(30) or
MVARCHAR(30)
Old values correlation name (correlation name specified in OLD ROW)
Null value if OLD ROW is not specified.
12NEW_ROW_NAMEVARCHAR(30) or
MVARCHAR(30)
New values correlation name (correlation name specified in NEW ROW)
Null value if NEW ROW is not specified.
13CREATE_TIMEVARCHAR(16)Trigger definition creation time
14ALTER_TIMECHAR(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.
15DEF_SOURCE_LENINTEGERTrigger definition source length
16SPECIFIC_NAMEVARCHAR(30) or
MVARCHAR(30)
Specific name of the trigger action procedure
17N_UPDATE_COLUMNSSMALLINTNumber of trigger event columns
Null value for an UPDATE trigger for which no INSERT trigger, DELETE trigger, or trigger event column is specified.
18REFERENCING_TABLE_IDINTEGERTable ID of the referencing table
Null value for triggers that are not created by a referential constraint action.
19REFERENCE_ACTIONCHAR(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.
20CONSTRAINT_NAMEVARCHAR(30) or
MVARCHAR(30)
Constraint name of referential trigger
Null value for triggers that are not created by a referential constraint action.

(39) SQL_TRIGGER_COLUMNS table contents

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

NumberColumn nameData typeContents
1TRIGGER_SCHEMAVARCHAR(30) or
MVARCHAR(30)
Trigger owner
2TRIGGER_NAMEVARCHAR(30) or
MVARCHAR(30)
Trigger name
3TABLE_SCHEMAVARCHAR(30) or
MVARCHAR(30)
Owner of the table for which the trigger is defined.
4TABLE_NAMEVARCHAR(30) or
MVARCHAR(30)
Name of the table for which the trigger is defined.
5COLUMN_NAMEVARCHAR(30) or
MVARCHAR(30)
Column name specified for the column list
6TABLE_IDINTEGERID of the table for which the trigger is defined.

(40) SQL_TRIGGER_DEF_SOURCE table contents

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

NumberColumn nameData typeContents
1TRIGGER_SCHEMAVARCHAR(30) or
MVARCHAR(30)
Trigger owner
2TRIGGER_NAMEVARCHAR(30) or
MVARCHAR(30)
Trigger name
3TABLE_SCHEMAVARCHAR(30) or
MVARCHAR(30)
Owner of the table for which the trigger is defined.
4TABLE_NAMEVARCHAR(30) or
MVARCHAR(30)
Name of the table for which the trigger is defined.
5SOURCE_NOINTEGERDefinition source serial number
6DEF_SOURCEVARCHAR(32000) or
MVARCHAR(32000)
Definition source (excluding SQL compile options and WITH PROGRAM)

(41) SQL_TRIGGER_USAGE table contents

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

NumberColumn nameData typeContents
1TRIGGER_SCHEMAVARCHAR(30) or
MVARCHAR(30)
Trigger owner
2TRIGGER_NAMEVARCHAR(30) or
MVARCHAR(30)
Trigger name
3TABLE_SCHEMAVARCHAR(30) or
MVARCHAR(30)
Owner of the table for which the trigger is defined.
4TABLE_NAMEVARCHAR(30) or
MVARCHAR(30)
Name of the table for which the trigger is defined.
5BASE_SCHEMAVARCHAR(30) or
MVARCHAR(30)
Owner of the resource being used
6BASE_TABLEVARCHAR(30) or
MVARCHAR(30)
Table name of the resource being used
Null value if the type of the resource being used is F (function).
7BASE_NAMEVARCHAR(30) or
MVARCHAR(30)
Name of the resource being used (specific name or column name)
8BASE_TYPECHAR(1)Type of resource being used
F: Function
C: Column name
9TABLE_IDINTEGERTable ID
Null value if the type of the resource being used is F (function).
10BASE_IDINTEGERID of the resource being used (object ID or column ID)

(42) SQL_PARTKEY table contents

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

NumberColumn nameData typeContents
1TABLE_SCHEMAVARCHAR(30) or
MVARCHAR(30)
Table owner
2TABLE_NAMEVARCHAR(30) or
MVARCHAR(30)
Table name
3KEY_NOSMALLINTPartitioning key number (dimension number 1 or 2)
4KEY_NAMEVARCHAR(30) or
MVARCHAR(30)
Partitioning key column name
5COLUMN_IDSMALLINTPartitioning key column ID
6N_DIVISIONSMALLINTNumber of divisions inside the key
7HASH_KEY_NOSMALLINTSequence number in hash key column
Null value for dimensions of boundary value partitioning.

(43) SQL_PARTKEY_DIVISION table contents

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

NumberColumn nameData typeContents
1TABLE_SCHEMAVARCHAR(30) or
MVARCHAR(30)
Table owner
2TABLE_NAMEVARCHAR(30) or
MVARCHAR(30)
Table name
3KEY_NOSMALLINTPartitioning key number (dimension number 1 or 2)
4IN_DIM_NOSMALLINTSerial number inside a partitioning key
5DCVALUESVARCHAR(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.

(44) SQL_AUDITS table contents

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

NumberColumn nameData typeContents
1EVENT_TYPEVARCHAR(30)Name of the event type1 specified by the CREATE AUDIT FOR operation type or 'ANY'.
2EVENT_SUBTYPEVARCHAR(30)Event sub-type name 2 or 'ANY'
Null value if CREATE AUDIT FOR ANY is specified.
3OBJECT_TYPEVARCHAR(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.
4OBJECT_SCHEMAVARCHAR(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.
5OBJECT_NAMEVARCHAR(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.
6USER_NAMEVARCHAR(30) or
MVARCHAR(30)
Authorization identifier of event executor (null value).
7ANY_VALIDCHAR(1)Whether or not CREATE AUDIT WHENEVER ANY is specified:
Y: Specified
N: Not specified
8SUCCESSFUL_VALIDCHAR(1)Whether or not CREATE AUDIT WHENEVER SUCCESSFUL is specified:
Y: Specified
N: Not specified
9UNSUCCESSFUL_ANY_VALIDCHAR(1)Whether or not CREATE AUDIT WHENEVER UNSUCCESSFUL is specified:
Y: Specified
N: Not specified
10AUDIT_TYPECHAR(1)Acquisition information type:
E: CREATE AUDIT AUDITTYPE EVENT is specified
A: CREATE AUDIT AUDITTYPE ANY is specified
Null value: CREATE AUDIT AUDITTYPE PRIVILEGE is specified or AUDITTYPE is omitted.
1 The following event types are available:
SESSION, PRIVILEGE, DEFINITION, ACCESS, and UTILITY
2 The following event sub-types are available:
CONNECT, AUTHORIZATION, GRANT, REVOKE, CREATE, DROP, ALTER, SELECT, INSERT, UPDATE, DELETE, PURGE, CALL, OPEN, LOCK, PDLOAD, PDRORG, and PDEXP
3 The following object types are available:
ALIAS, FOREIGN INDEX, FOREIGN TABLE, FUNCTION, INDEX, PROCEDURE, SCHEMA, SERVER, TABLE, TRIGGER, DATA TYPE, USER MAPPING, VIEW, and LIST

(45) SQL_REFERENTIAL_CONSTRAINTS table contents

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

NumberColumn nameData typeContents
1CONSTRAINT_NAMEVARCHAR(30) or MVARCHAR(30)Constraint name
2CONSTRAINT_SCHEMAVARCHAR(30) or MVARCHAR(30)Constraint owner
3TABLE_NAMEVARCHAR(30) or MVARCHAR(30)Name of the table for which the constraint is defined
4TABLE_SCHEMAVARCHAR(30) or MVARCHAR(30)Owner of the table for which the constraint is defined
5COLUMN_COUNTSMALLINTNumber of columns in the foreign key
6COLUMN_NAMEVARCHAR(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.
7COLUMN_NOVARCHAR(32)Column IDs (16 IDs) of the table containing the foreign key*
8R_OWNERVARCHAR(30) or MVARCHAR(30)Owner of the table to be referenced
9R_TABLE_NAMEVARCHAR(30) or MVARCHAR(30)Name of the table to be referenced
10DELETE_RULECHAR(11)Deletion rule (RESTRICT or CASCADE)
11UPDATE_RULECHAR(11)Update rule (RESTRICT or CASCADE)
12CONSTRAINT_TIMECHAR(14)Date and time when the constraint was defined (YYYYMMDDHHMMSS)
13CHECK_PENDCHAR(1)Type of check pending status
C: Pending
Null value: Non-pending
14DELETE_TRIGGER_NAMEVARCHAR(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.
15UPDATE_TRIGGER_NAMEVARCHAR(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.
16R_COLUMN_NAMEVARCHAR(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.
17R_COLUMN_NOVARCHAR(32)Column IDs (16 IDs) of the columns that make up the main key*
* Endian conversion is not performed on the SQL results even if the connection modes have different endians. Therefore, when an application accesses the SQL results, the SQL must consider the endian and convert the endian if necessary.

(46) SQL_KEYCOLUMN_USAGE table contents

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

NumberColumn nameData typeContents
1CONSTRAINT_SCHEMAVARCHAR(30) or MVARCHAR(30)Constraint owner
2CONSTRAINT_NAMEVARCHAR(30) or MVARCHAR(30)Constraint name
3TABLE_SCHEMAVARCHAR(30) or MVARCHAR(30)Owner of the table for which the constraint was defined
4TABLE_NAMEVARCHAR(30) or MVARCHAR(30)Name of the table for which the constraint was defined
5COLUMN_NAMEVARCHAR(30) or MVARCHAR(30)Name of the column for which the constraint was defined
6COLUMN_ORDERSMALLINTPosition of the column for which the constraint was defined

(47) SQL_TABLE_CONSTRAINTS table contents

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

NumberColumn nameData typeContents
1CONSTRAINT_SCHEMAVARCHAR(30) or MVARCHAR(30)Constraint owner
2CONSTRAINT_NAMEVARCHAR(30) or MVARCHAR(30)Constraint name
3CONSTRAINT_TYPEVARCHAR(30)Constraint type
FOREIGN KEY: Foreign key
CHECK: Check constraint
4TABLE_SCHEMAVARCHAR(30) or MVARCHAR(30)Owner of the table for which the constraint was defined
5TABLE_NAMEVARCHAR(30) or MVARCHAR(30)Name of the table for which the constraint was defined

(48) SQL_CHECKS table contents

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

NumberColumn nameData typeContents
1CONSTRAINT_SCHEMAVARCHAR(30) or MVARCHAR(30)Check constraint owner
2CONSTRAINT_NAMEVARCHAR(30) or MVARCHAR(30)Constraint name
3TABLE_SCHEMAVARCHAR(30) or MVARCHAR(30)Owner of the table for which the constraint was defined
4TABLE_NAMEVARCHAR(30) or MVARCHAR(30)Name of the table for which the constraint was defined
5CHK_SOURCE_LENINTEGERLength of the check constraint search conditions
6CHK_SOURCEBINARY(2000000​)Check constraint search conditions
7CREATE_TIMECHAR(14)Date and time when the search constraint was defined (YYYYMMDDHHMMSS)
8CHECK_PEND2CHAR(1)Check pending status type
C: Pending
Null value: Non-pending
9N_CHK_COLUMNINTEGERNumber of constraint columns specified in the check constraint definition (number of duplicate exclusion columns)

(49) SQL_CHECK_COLUMNS table contents

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

NumberColumn nameData typeContents
1CONSTRAINT_SCHEMAVARCHAR(30) or MVARCHAR(30)Check constraint owner
2CONSTRAINT_NAMEVARCHAR(30) or MVARCHAR(30)Constraint name
3TABLE_SCHEMAVARCHAR(30) or MVARCHAR(30)Owner of the table for which the constraint was defined
4TABLE_NAMEVARCHAR(30) or MVARCHAR(30)Name of the table for which the constraint was defined
5COLUMN_NAMEVARCHAR(30) or MVARCHAR(30)Name of the column used by the constraint

(50) SQL_DIV_TYPE table contents

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

NumberColumn nameData typeContents
1TABLE_SCHEMAVARCHAR(30) or MVARCHAR(30)Table owner
2TABLE_NAMEVARCHAR(30) or MVARCHAR(30)Table name
3KEY_NOSMALLINTPartitioning key number (dimension number)
4DIV_TYPECHAR(1)Partitioning type in the dimension
P: Boundary value partitioning
F: FIX hash partitioning
H: Flexible hash partitioning
5HASH_NAMEVARCHAR(30) or MVARCHAR(30)Hash function name
"HASH1"
"HASH2"
"HASH3"
"HASH4"
"HASH5"
"HASH6"
"HASH0"
Null value for dimensions without hash partitioning
6N_DIV_COLUMNSMALLINTNumber of partitioning columns in the dimension

(51) SQL_SYSPARAMS table contents

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

NumberColumn nameData typeContents
1PARAM_KINDVARCHAR(20)Parameter type (CONNECTION_SECURITY)
2FUNCTION_KEYVARCHAR(20)Function name
CONNECT: Limit on the number of consecutive certification failures
PASSWORD: Password character sting limit
3PARAM_KEYVARCHAR(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
4INT_VALUEINTEGERINT-type data value*
5CHAR_VALUEVARCHAR(30)CHAR-type data value*
* The table below shows the values that are stored for the INT-type and CHAR-type data values.
PARAM_KEY setting valueValue specified in SQLINT_VALUECHAR_VALUE
PERMISSION_COUNTConstantConstantConstant
No specification22
LOCK_MINUTEConstantConstantConstant
UNLIMITEDNull valueUNLIMITED
No specification14401440
LOCK_MINUTE_CODEConstantConstantConstant
UNLIMITEDNull valueUNLIMITED
No specification1000000​1000000​
MIN_LENGTHConstantConstantConstant
No specification88
USER_IDENTIFIERRESTRICTNull valueRESTRICT
UNRESTRICTNull valueUNRESTRICT
No specificationNull valueRESTRICT
SIMILARRESTRICTNull valueRESTRICT
UNRESTRICTNull valueUNRESTRICT
No specificationNull valueRESTRICT