DBNAME contains information about an entry in a database name table.
|
Column name |
Column description |
Data type |
Null specifi- cation |
|---|---|---|---|
|
DBTABLE |
Name of database name table. |
CHAR(8) |
NOT NULL |
|
NAME |
Database name entry in the database name table. If this column contains *DEFAULT, the row represents the default subschema mapping for the database name table. |
CHAR(8) |
NOT NULL |
|
DMCL |
Reserved for future use. |
CHAR(8) |
NOT NULL |
|
NODE |
Reserved for future use. |
CHAR(8) |
NOT NULL |
|
LOADLIST |
Reserved for future use. |
CHAR(8) |
NOT NULL |
|
FLAG |
Database name flag:
|
BINARY(1) |
NOT NULL |
|
CTIME |
Date and time when the database name was created. |
TIMESTAMP |
NOT NULL |
|
UTIME |
Date and time when the database name was last updated. |
TIMESTAMP |
NOT NULL |
|
CUSER |
ID of the user who created the database name. |
CHAR(18) |
NOT NULL |
|
UUSER |
ID of the user who last updated the database name. |
CHAR(18) |
NOT NULL |
|
GROUPFLAG |
DB Group flag:
|
CHAR(1) |
NOT NULL |
|
NUMSEGMENTS |
Number of segments associated with the database name. |
SMALLINT |
NOT NULL |
|
NUMSUBSCHEMAS |
Number of subschemas associated with the database name. |
SMALLINT |
NOT NULL |
|
USAGEFLAG |
Indicates general use or utility use only. x'80' DBName for utility use only. |
BINARY(1) |
NOT NULL |
|
FILLER |
Reserved for future use. |
BINARY(17) |
NOT NULL |
|
Copyright © 2014 CA.
All rights reserved.
|
|