This chapter describes the system tables that are available in all SQLMODEs. These system tables belong to the user 'DOMAIN'. In all SQLMODEs other than ADABAS, the name of the user 'DOMAIN' must be placed in front of the name of the system table.
COLUMNS Columns of all tables, views, snapshots, synonyms, and results accessible to the user
OWNER CHAR ( 18) Owner name of the table, view, snapshot, synonym, result
TABLENAME CHAR ( 18) Table, view, snapshot, synonym or result name
COLUMNNAME CHAR ( 18) Column name
MODE CHAR ( 3) Mode of the column (key / man / opt)
DATATYPE CHAR ( 10) Data type of the column (boolean / char / date / fixed / float / long / time / timestamp)
CODETYPE CHAR ( 8) Code type of the column (ascii / ebcdic / byte)
LEN FIXED ( 4) Length or precision of the column
DEC FIXED ( 3) Digits to the right of the decimal point in a FIXED-type column
COLUMNPRIVILEGES CHAR ( 8) User's privileges for the column
DEFAULT CHAR (254) Default value for the column
DOMAINNAME CHAR ( 18) Domain name
POS FIXED ( 3) Original position of the column in the table
KEYPOS FIXED ( 3) Original position of the key in the table
CREATEDATE DATE Creation date of the column
CREATETIME TIME Creation time of the column
ALTERDATE DATE Alteration date of the column
ALTERTIME TIME Alteration time of the column
TABLETYPE CHAR ( 8) Type of the table
COMMENT LONG Comment on columns of accessible tables, snapshots and views
COL_REFS_DOM Relationship Column Refers to Domain
DEFOBJTYPE CHAR ( 6) COLUMN
DEFOWNER CHAR ( 18) Owner name of the table
DEFTABLENAME CHAR ( 18) Table name
DEFCOLUMNNAME CHAR ( 18) Column name
RELTYPE CHAR ( 6) REFERS
REFOBJTYPE CHAR ( 6) DOMAIN
REFOWNER CHAR ( 18) Owner name of the domain
REFDOMAINNAME CHAR ( 18) Domain name
CREATEDATE DATE Creation date of the relationship
CREATETIME TIME Creation time of the relationship
COL_USES_COL Relationship Column Uses Column
DEFOBJTYPE CHAR ( 6) COLUMN
DEFOWNER CHAR ( 18) Owner name of the table
DEFTABLENAME CHAR ( 18) Table name
DEFCOLUMNNAME CHAR ( 18) Column name
RELTYPE CHAR ( 4) USES
REFOBJTYPE CHAR ( 6) COLUMN
REFOWNER CHAR ( 18) Owner name of the table
REFTABLENAME CHAR ( 18) Table name
REFCOLUMNNAME CHAR ( 18) Column name
CREATEDATE DATE Creation date of the relationship
CREATETIME TIME Creation time of the relationship
CONNECTEDUSERS All connected users
USERNAME CHAR ( 18) User name
TERMID CHAR ( 18) Terminal identification
SESSION FIXED ( 10) Session
CATALOG_CACHE_SIZE FIXED ( 10) Catalog cache size
DBPROC_CACHE_SIZE FIXED ( 10) DB procedure cache size
TEMP_CACHE_SIZE FIXED ( 10) Temporary cache size
SERVERDB CHAR ( 18) SERVERDB name
CONNECTPARAMETERS Connect parameters for the current user
SQLMODE CHAR ( 8) SQLMODE
ISOLEVEL FIXED ( 10) ISOLATION LEVEL
TIMEOUT FIXED ( 10) Value for the session timeout
CACHELIMIT FIXED ( 10) CACHELIMIT value
TERMCHARSETNAME CHAR ( 18) TERMCHAR SET name
CONSTRAINTS <constraint definitions> on accessible tables
OWNER CHAR ( 18) Owner name of the table
TABLENAME CHAR ( 18) Name of the table with the <constraint definition>
CONSTRAINTNAME CHAR ( 18) <constraint definition> name
DEFINITION LONG <constraint definition> text
DBFUNCPARAMS Parameters of a DB function that is accessible to the user
OWNER CHAR ( 18) Owner name of the DB function
DBFUNCNAME CHAR ( 18) DB function name
PARAMETERNAME CHAR ( 18) Parameter name
POS FIXED ( 3) Original position of the parameter in the DB function
IN/OUT-TYPE CHAR ( 6) Mode of the parameter (in / out)
DATATYPE CHAR ( 10) Data type of the column (boolean / char / date / fixed / float / time / timestamp)
LEN FIXED ( 4) Length or precision of the parameter
DEC FIXED ( 3) Digits to the right of the decimal point in FIXED-type parameters
CREATEDATE DATE Creation date of the DB function
CREATETIME TIME Creation time of the DB function
DBFUNCTIONS DB functions accessible to the user
OWNER CHAR ( 18) Owner name of the DB function
DBFUNCNAME CHAR ( 18) DB function name
CREATEDATE DATE Creation date of the DB function
CREATETIME TIME Creation time of the DB function
COMMENT LONG Comment on the DB function
DBF_CONT_PRM Relationship DB Function Contains Parameter
DEFOBJTYPE CHAR ( 10) DBFUNCTION
DEFOWNER CHAR ( 18) Owner name of the DB function
DEFDBFUNCNAME CHAR ( 18) DB function name
RELTYPE CHAR ( 8) CONTAINS
REFOBJTYPE CHAR ( 11) DBFUNCTIONPARAM
REFOWNER CHAR ( 18) Owner name of the DB function
REFDBFUNCNAME CHAR ( 18) DB function name
REFPARAMETERNAME CHAR ( 18) Parameter name
POS FIXED ( 3) Original position of the parameter in the DB function
CREATEDATE DATE Creation date of the relationship
CREATETIME TIME Creation time of the relationship
DBF_REFS_MOD Relationship DB Function Refers to Module
DEFOBJTYPE CHAR ( 10) DBFUNCTION
DEFOWNER CHAR ( 18) Owner name of the DB function
DEFDBFUNCNAME CHAR ( 18) DB function name
RELTYPE CHAR ( 6) REFERS
REFOBJTYPE CHAR ( 6) MODULE
REFOWNER CHAR ( 18) Owner name of the module
REFPROGRAMNAME CHAR ( 18) Program name
REFMODULENAME CHAR ( 18) Module name
REFPROGLANG CHAR ( 6) Programming language of the module (c/cobol ...)
CREATEDATE DATE Creation date of the relationship
CREATETIME TIME Creation time of the relationship
DBPROCEDURES DB procedures accessible to the user
OWNER CHAR ( 18) Owner name of the DB procedure
PROGRAMNAME CHAR ( 18) Program name
DBPROCNAME CHAR ( 18) DB procedure name
ALIASNAME CHAR ( 18) Short name of the DB procedure
PARAMETER FIXED ( 3) Number of parameters of the DB procedure
EXECUTABLE CHAR ( 3) DB procedure is executable (yes/no)
GRANT CHAR ( 3) User is authorized to grant the right to execute the DB procedure (yes/no)
CREATEDATE DATE Creation date of the DB procedure
CREATETIME TIME Creation time of the DB procedure
COMMENT LONG Comment on the DB procedure
DBPROCPARAMS Parameters of a DB procedure that is accessible to the user
OWNER CHAR ( 18) Owner name of the DB procedure
PROGRAMNAME CHAR ( 18) Program name
DBPROCNAME CHAR ( 18) DB procedure name
PARAMETERNAME CHAR ( 18) Parameter name
POS FIXED ( 3) Original position of the parameter in the DB procedure
IN/OUT-TYPE CHAR ( 6) Mode of the parameter (in/out)
DATATYPE CHAR ( 10) Data type of the parameter (boolean / char / date / fixed / float / time / timestamp)
LEN FIXED ( 4) Length or precision of the parameter
DEC FIXED ( 3) Digits to the right of the decimal point in a parameter
CREATEDATE DATE Creation date of the DB procedure
CREATETIME TIME Creation time of the DB procedure
DBP_CONT_PRM Relationship DB Procedure Contains Parameter
DEFOBJTYPE CHAR ( 11) DBPROCEDURE
DEFOWNER CHAR ( 18) Owner name of the DB procedure
DEFPROGRAMNAME CHAR ( 18) Program name
DEFDBPROCNAME CHAR ( 18) DB procedure name
RELTYPE CHAR ( 8) CONTAINS
REFOBJTYPE CHAR ( 11) DBPROCEDUREPARAM
REFOWNER CHAR ( 18) Owner name of the DB procedure
REFPROGRAMNAME CHAR ( 18) Program name
REFDBPROCNAME CHAR ( 18) DB procedure name
REFPARAMETERNAME CHAR ( 18) Parameter name
POS FIXED ( 3) Original position of the parameter in the DB procedure
CREATEDATE DATE Creation date of the relationship
CREATETIME TIME Creation time of the relationship
DBP_REFS_MOD Relationship DB Procedure Refers to Module
DEFOBJTYPE CHAR ( 11) DBPROCEDURE
DEFOWNER CHAR ( 18) Owner name of the DB procedure
DEFPROGRAMNAME CHAR ( 18) Program name
DEFDBPROCNAME CHAR ( 18) DB procedure name
RELTYPE CHAR ( 6) REFERS
REFOBJTYPE CHAR ( 6) MODULE
REFOWNER CHAR ( 18) Owner name of the module
REFPROGRAMNAME CHAR ( 18) Program name
REFMODULENAME CHAR ( 18) Module name
REFPROGLANG CHAR ( 6) Programming language of the module (c/cobol ...)
CREATEDATE DATE Creation date of the relationship
CREATETIME TIME Creation time of the relationship
DOMAINCONSTRAINTS <constraint definition> for a domain
OWNER CHAR ( 18) Owner name of the domain
DOMAINNAME CHAR ( 18) Domain name
CONSTRAINTNAME CHAR ( 18) <constraint definition> name
DEFINITION LONG <constraint definition> text
DOMAINS All domains
OWNER CHAR ( 18) Owner name of the domain
DOMAINNAME CHAR ( 18) Domain name
DATATYPE CHAR ( 10) Data type of the domain (boolean / char / date / fixed / float / long / time / timestamp)
CODETYPE CHAR ( 8) Code type of the domain (ascii / ebcdic / byte)
LEN FIXED ( 4) Length or precision of the domain
DEC FIXED ( 3) Digits to the right of the decimal point in a FIXED-type domain
DEFAULT CHAR (254) Default value for the domain
DEFINITION LONG Text of the domain definition
CREATEDATE DATE Creation date of the domain
CREATETIME TIME Creation time of the domain
COMMENT LONG Comment on the domain
EASYCOMMANDS EASY commands of the user
OWNER CHAR ( 18) Owner name of the EASY command
COMMANDNAME CHAR ( 18) EASY command name
TABLEOWNER CHAR ( 18) Owner name of the table
TABLENAME CHAR ( 18) Table name
CREATEDATE DATE Creation date of the EASY command
CREATETIME TIME Creation time of the EASY command
ALTERDATE DATE Alteration date of the EASY command
ALTERTIME TIME Alteration time of the EASY command
COMMENT LONG Comment on the EASY command
EASYFORMS EASY forms accessible to the user
OWNER CHAR ( 18) Owner name of the EASY form
TABLENAME CHAR ( 18) Table name
FORMNAME CHAR ( 18) EASY form name
CREATEDATE DATE Creation date of the EASY form
CREATETIME TIME Creation time of the EASY form
ALTERDATE DATE Alteration date of the EASY form
ALTERTIME TIME Alteration time of the EASY form
COMMENT LONG Comment on the EASY form
ECM_USES_COL Relationship EASY Command Uses Column
DEFOBJTYPE CHAR ( 18) EASYCOMMAND
DEFOWNER CHAR ( 18) Owner name of the EASY command
DEFCOMMANDNAME CHAR ( 18) EASY command name
DEFTABLEOWNER CHAR ( 18) Owner name of the table
DEFTABLENAME CHAR ( 18) Table name
RELTYPE CHAR ( 18) USES
REFOBJTYPE CHAR ( 18) COLUMN
REFOWNER CHAR ( 18) Owner name of the table
REFTABLENAME CHAR ( 18) Table name
REFCOLUMNNAME CHAR ( 18) Column name
CREATEDATE DATE Creation date of the relationship
CREATETIME TIME Creation time of the relationship
ECM_USES_SNP Relationship EASY Command Uses Snapshot
DEFOBJTYPE CHAR ( 18) EASYCOMMAND
DEFOWNER CHAR ( 18) Owner name of the EASY command
DEFCOMMANDNAME CHAR ( 18) EASY command name
DEFTABLEOWNER CHAR ( 18) Owner name of the table
DEFTABLENAME CHAR ( 18) Table name
RELTYPE CHAR ( 18) USES
REFOBJTYPE CHAR ( 18) Snapshot
REFOWNER CHAR ( 18) Owner name of the snapshot table
REFSNAPSHOTNAME CHAR ( 18) Snapshot table name
CREATEDATE DATE Creation date of the relationship
CREATETIME TIME Creation time of the relationship
ECM_USES_SYN Relationship EASY Command Uses Synonym
DEFOBJTYPE CHAR ( 18) EASYCOMMAND
DEFOWNER CHAR ( 18) Owner name of the EASY command
DEFCOMMANDNAME CHAR ( 18) EASY command name
DEFTABLEOWNER CHAR ( 18) Owner name of the table
DEFTABLENAME CHAR ( 18) Table name
RELTYPE CHAR ( 18) USES
REFOBJTYPE CHAR ( 18) SYNONYM
REFOWNER CHAR ( 18) Owner name of the synonym
REFSYNONYMNAME CHAR ( 18) Synonym name
CREATEDATE DATE Creation date of the relationship
CREATETIME TIME Creation time of the relationship
ECM_USES_TAB Relationship EASY Command Uses Table
DEFOBJTYPE CHAR ( 18) EASYCOMMAND
DEFOWNER CHAR ( 18) Owner name of the EASY command
DEFCOMMANDNAME CHAR ( 18) EASY command name
DEFTABLEOWNER CHAR ( 18) Owner name of the table
DEFTABLENAME CHAR ( 18) Table name
RELTYPE CHAR ( 18) USES
REFOBJTYPE CHAR ( 18) TABLE
REFOWNER CHAR ( 18) Owner name of the table
REFTABLENAME CHAR ( 18) Table name
CREATEDATE DATE Creation date of the relationship
CREATETIME TIME Creation time of the relationship
ECM_USES_VIE Relationship EASY Command Uses View
DEFOBJTYPE CHAR ( 18) EASYCOMMAND
DEFOWNER CHAR ( 18) Owner name of the EASY command
DEFCOMMANDNAME CHAR ( 18) EASY command name
DEFTABLEOWNER CHAR ( 18) Owner name of the table
DEFTABLENAME CHAR ( 18) Table name
RELTYPE CHAR ( 18) USES
REFOBJTYPE CHAR ( 18) VIEW
REFOWNER CHAR ( 18) Owner name of the view table
REFVIEWNAME CHAR ( 18) View table name
CREATEDATE DATE Creation date of the relationship
CREATETIME TIME Creation time of the relationship
EFM_USES_COL Relationship EASY Form Uses Column
DEFOBJTYPE CHAR ( 18) EASYFORM
DEFOWNER CHAR ( 18) Owner name of the table
DEFTABLENAME CHAR ( 18) Table name
DEFFORMNAME CHAR ( 18) EASY form name
RELTYPE CHAR ( 18) USES
REFOBJTYPE CHAR ( 18) COLUMN
REFOWNER CHAR ( 18) Owner name of the table
REFTABLENAME CHAR ( 18) Table name
REFCOLUMNNAME CHAR ( 18) Column name
CREATEDATE DATE Creation date of the relationship
CREATETIME TIME Creation time of the relationship
EFM_USES_SNP Relationship EASY Form Uses Snapshot
DEFOBJTYPE CHAR ( 18) EASYFORM
DEFOWNER CHAR ( 18) Owner name of the table
DEFTABLENAME CHAR ( 18) Table name
DEFFORMNAME CHAR ( 18) EASY form name
RELTYPE CHAR ( 18) USES
REFOBJTYPE CHAR ( 18) SNAPSHOT
REFOWNER CHAR ( 18) Owner name of the snapshot table
REFSNAPSHOTNAME CHAR ( 18) Snapshot table name
CREATEDATE DATE Creation date of the relationship
CREATETIME TIME Creation time of the relationship
EFM_USES_SYN Relationship EASY Form Uses Synonym
DEFOBJTYPE CHAR ( 18) EASYFORM
DEFOWNER CHAR ( 18) Owner name of the table
DEFTABLENAME CHAR ( 18) Table name
DEFFORMNAME CHAR ( 18) Easy form name
RELTYPE CHAR ( 18) USES
REFOBJTYPE CHAR ( 18) SYNONYM
REFOWNER CHAR ( 18) Owner name of the synonym
REFSYNONYMNAME CHAR ( 18) Synonym name
CREATEDATE DATE Creation date of the relationship
CREATETIME TIME Creation time of the relationship
EFM_USES_TAB Relationship EASY Form Uses Table
DEFOBJTYPE CHAR ( 18) EASYFORM
DEFOWNER CHAR ( 18) Owner name of the table
DEFTABLENAME CHAR ( 18) Table name
DEFFORMNAME CHAR ( 18) EASY form name
RELTYPE CHAR ( 18) USES
REFOBJTYPE CHAR ( 18) TABLE
REFOWNER CHAR ( 18) Owner name of the table
REFTABLENAME CHAR ( 18) Table name
CREATEDATE DATE Creation date of the relationship
CREATETIME TIME Creation time of the relationship
EFM_USES_VIE Relationship EASY Form Uses View
DEFOBJTYPE CHAR ( 18) EASYFORM
DEFOWNER CHAR ( 18) Owner name of the table
DEFTABLENAME CHAR ( 18) Table name
DEFFORMNAME CHAR ( 18) Easy form name
RELTYPE CHAR ( 18) USES
REFOBJTYPE CHAR ( 18) VIEW
REFOWNER CHAR ( 18) Owner name of the view table
REFVIEWNAME CHAR ( 18) View table name
CREATEDATE DATE Creation date of the relationship
CREATETIME TIME Creation time of the relationship
FKC_REFS_COL Relationship Foreign Key Column Refers to Column (foreign key)
DEFOBJTYPE CHAR ( 6) FOREIGNKEYCOLUMN
DEFOWNER CHAR ( 18) Owner name of the table
DEFTABLENAME CHAR ( 18) Table name
DEFCOLUMNNAME CHAR ( 18) Column name
DEFFKEYNAME CHAR ( 18) Name of the <referential constraint definition>
RELTYPE CHAR ( 6) REFERS
REFOBJTYPE CHAR ( 6) COLUMN
REFOWNER CHAR ( 18) Owner name of the table
REFTABLENAME CHAR ( 18) Table name
REFCOLUMNNAME CHAR ( 18) Column name
RULE CHAR ( 18) Delete rule
CREATEDATE DATE Creation date of the relationship
CREATETIME TIME Creation time of the relationship
FKEYCOMMENT LONG Comment on the <referential constraint definition>
FOK_REFS_TAB Relationship Foreign Key Refers to Table
DEFOBJTYPE CHAR ( 10) FOREIGNKEY
DEFOWNER CHAR ( 18) Owner name of the table
DEFTABLENAME CHAR ( 18) Table name
DEFFKEYNAME CHAR ( 18) Name of the <referential constraint definition>
RELTYPE CHAR ( 6) REFERS
REFOBJTYPE CHAR ( 5) TABLE
REFOWNER CHAR ( 18) Owner name of the table
REFTABLENAME CHAR ( 18) Table name
CREATEDATE DATE Creation date of the relationship
CREATETIME TIME Creation time of the relationship
FOK_USES_COL Relationship Foreign Key Uses Column
DEFOBJTYPE CHAR ( 10) FOREIGNKEY
DEFOWNER CHAR ( 18) Owner name of the table
DEFTABLENAME CHAR ( 18) Table name
DEFFKEYNAME CHAR ( 18) Name of the <referential constraint definition>
RELTYPE CHAR ( 4) USES
REFOBJTYPE CHAR ( 6) COLUMN
REFOWNER CHAR ( 18) Owner name of the table
REFTABLENAME CHAR ( 18) Table name
REFCOLUMNNAME CHAR ( 18) Column name
CREATEDATE DATE Creation date of the relationship
CREATETIME TIME Creation time of the relationship
FOREIGNKEYS <referential constraint definition>s accessible to the user
OWNER CHAR ( 18) Owner name of the table
TABLENAME CHAR ( 18) Table name
FKEYNAME CHAR ( 18) Name of the <referential constraint definition>
RULE CHAR ( 18) Delete rule
CREATEDATE DATE Creation date of the <referential constraint definition>
CREATETIME TIME Creation time of the <referential constraint definition>
COMMENT LONG Comment on the <referential constraint definition>
INDEXES Indexes accessible to the user
OWNER CHAR ( 18) Owner name of the index
TABLENAME CHAR ( 18) Table name
INDEXNAME CHAR ( 18) Index name
TYPE CHAR ( 6) Type of the index (unique/null)
CREATEDATE DATE Creation date of the index
CREATETIME TIME Creation time of the index
COMMENT LONG Comment on the index
IND_USES_COL Relationship Index Uses Column
DEFOBJTYPE CHAR ( 5) INDEX
DEFOWNER CHAR ( 18) Owner name of the index
DEFTABLENAME CHAR ( 18) Table name
DEFINDEXNAME CHAR ( 18) Index name
RELTYPE CHAR ( 4) USES
REFOBJTYPE CHAR ( 6) COLUMN
REFOWNER CHAR ( 18) Owner name of the table
REFTABLENAME CHAR ( 18) Table name
REFCOLUMNNAME CHAR ( 18) Column name
TYPE CHAR ( 6) Type of the index (unique/null)
POS FIXED ( 3) Original position of the column in the index
SORT CHAR ( 4) Sort order (asc/desc)
CREATEDATE DATE Creation date of the relationship
CREATETIME TIME Creation time of the relationship
INDEXCOMMENT LONG Comment on the index
LITERALS Literals accessible to the user
OWNER CHAR ( 18) Owner name of the literal
LITERALNAME CHAR ( 18) Literal name
LANGUAGE CHAR ( 18) Literal language
S_LABEL CHAR ( 8) Small label
M_LABEL CHAR ( 12) Medium label
L_LABEL CHAR ( 18) Large label
XL_LABEL CHAR ( 80) Extra large label
CREATEDATE DATE Creation date of the literal
CREATETIME TIME Creation time of the literal
ALTERDATE DATE Alteration date of the literal
ALTERTIME TIME Alteration time of the literal
COMMENT LONG Comment on the literal
MAPCHARSETS All MAPCHAR SETs
MAPCHARSETNAME CHAR ( 18) Name of the MAPCHAR SET
CODE CHAR ( 8) Code type for which the MAPCHAR SET was defined (ascii/ebcdic)
INTERN CHAR ( 1) The original form in hexadecimal format
MAP_CODE CHAR ( 2) The target form in hexadecimal notation
MAP_CHARACTER CHAR ( 2) The target form with printable characters
MODULES Modules accessible to the user
OWNER CHAR ( 18) Owner name of the module
PROGRAMNAME CHAR ( 18) Program name
MODULENAME CHAR ( 18) Module name
PROGLANG CHAR ( 18) Programming language of the module (c/cobol ...)
CREATEDATE DATE Creation date of the module
CREATETIME TIME Creation time of the module
ALTERDATE DATE Alteration date of the module
ALTERTIME TIME Alteration time of the module
COMMENT LONG Comment on the module
MOD_CALL_DBP Relationship Module Calls DB Procedure
DEFOBJTYPE CHAR ( 18) MODULE
DEFOWNER CHAR ( 18) Owner name of the module
DEFPROGRAMNAME CHAR ( 18) Program name
DEFMODULENAME CHAR ( 18) Module name
DEFPROGLANG CHAR ( 18) Programming language of the module (c/cobol ...)
RELTYPE CHAR ( 18) CALLS
REFOBJTYPE CHAR ( 18) DBPROCEDURE
REFOWNER CHAR ( 18) Owner name of the DB procedure
REFPROGRAMNAME CHAR ( 18) Program name
REFDBPROCNAME CHAR ( 18) DB procedure name
CREATEDATE DATE Creation date of the relationship
CREATETIME TIME Creation time of the relationship
MOD_CALL_MOD Relationship Module Calls Module
DEFOBJTYPE CHAR ( 18) MODULE
DEFOWNER CHAR ( 18) Owner name of the module
DEFPROGRAMNAME CHAR ( 18) Program name
DEFMODULENAME CHAR ( 18) Module name
DEFPROGLANG CHAR ( 18) Programming language of the module (c/cobol ...)
RELTYPE CHAR ( 18) CALLS
REFOBJTYPE CHAR ( 18) MODULE
REFOWNER CHAR ( 18) Owner name of the module
REFPROGRAMNAME CHAR ( 18) Program name
REFMODULENAME CHAR ( 18) Module name
REFPROGLANG CHAR ( 18) Programming language of the module (c/cobol ...)
CREATEDATE DATE Creation date of the relationship
CREATETIME TIME Creation time of the relationship
MOD_USES_COL Relationship Module Uses Column
DEFOBJTYPE CHAR ( 18) MODULE
DEFOWNER CHAR ( 18) Owner name of the module
DEFPROGRAMNAME CHAR ( 18) Program name
DEFMODULENAME CHAR ( 18) Module name
DEFPROGLANG CHAR ( 18) Programming language of the module (c/cobol ...)
RELTYPE CHAR ( 18) USES
REFOBJTYPE CHAR ( 18) COLUMN
REFOWNER CHAR ( 18) Owner name of the table
REFTABLENAME CHAR ( 18) Table name
REFCOLUMNNAME CHAR ( 18) Column name
CREATEDATE DATE Creation date of the relationship
CREATETIME TIME Creation time of the relationship
MOD_USES_DOM Relationship Module Uses Domain
DEFOBJTYPE CHAR ( 18) MODULE
DEFOWNER CHAR ( 18) Owner name of the module
DEFPROGRAMNAME CHAR ( 18) Program name
DEFMODULENAME CHAR ( 18) Module name
DEFPROGLANG CHAR ( 18) Programming language of the module (c/cobol ...)
RELTYPE CHAR ( 18) USES
REFOBJTYPE CHAR ( 18) DOMAIN
REFOWNER CHAR ( 18) Owner name of the domain
REFDOMAINNAME CHAR ( 18) Domain name
CREATEDATE DATE Creation date of the relationship
CREATETIME TIME Creation time of the relationship
MOD_USES_QCM Relationship Module Uses QUERY Command
DEFOBJTYPE CHAR ( 18) MODULE
DEFOWNER CHAR ( 18) Owner name of the module
DEFPROGRAMNAME CHAR ( 18) Program name
DEFMODULENAME CHAR ( 18) Module name
DEFPROGLANG CHAR ( 18) Programming language of the module (c/cobol ...)
RELTYPE CHAR ( 18) USES
REFOBJTYPE CHAR ( 18) QUERYCOMMAND
REFOWNER CHAR ( 18) Owner name of the QUERY command
REFCOMMANDNAME CHAR ( 18) QUERY command name
CREATEDATE DATE Creation date of the relationship
CREATETIME TIME Creation time of the relationship
MOD_USES_SNP Relationship Module Uses Snapshot
DEFOBJTYPE CHAR ( 18) MODULE
DEFOWNER CHAR ( 18) Owner name of the module
DEFPROGRAMNAME CHAR ( 18) Program name
DEFMODULENAME CHAR ( 18) Module name
DEFPROGLANG CHAR ( 18) Programming language of the module (c/cobol ...)
RELTYPE CHAR ( 18) USES
REFOBJTYPE CHAR ( 18) SNAPSHOT
REFOWNER CHAR ( 18) Owner name of the snapshot table
REFSNAPSHOTNAME CHAR ( 18) Snapshot table name
CREATEDATE DATE Creation date of the relationship
CREATETIME TIME Creation time of the relationship
MOD_USES_SYN Relationship Module Uses Synonym
DEFOBJTYPE CHAR ( 18) MODULE
DEFOWNER CHAR ( 18) Owner name of the module
DEFPROGRAMNAME CHAR ( 18) Program name
DEFMODULENAME CHAR ( 18) Module name
DEFPROGLANG CHAR ( 18) Programming language of the module (c/cobol ...)
RELTYPE CHAR ( 18) USES
REFOBJTYPE CHAR ( 18) SYNONYM
REFOWNER CHAR ( 18) Owner name of the synonym
REFSYNONYMNAME CHAR ( 18) Synonym name
CREATEDATE DATE Creation date of the relationship
CREATETIME TIME Creation time of the relationship
MOD_USES_TAB Relationship Module Uses Table
DEFOBJTYPE CHAR ( 18) MODULE
DEFOWNER CHAR ( 18) Owner name of the module
DEFPROGRAMNAME CHAR ( 18) Program name
DEFMODULENAME CHAR ( 18) Module name
DEFPROGLANG CHAR ( 18) Programming language of the module (c/cobol ...)
RELTYPE CHAR ( 18) USES
REFOBJTYPE CHAR ( 18) TABLE
REFOWNER CHAR ( 18) Owner name of the table
REFTABLENAME CHAR ( 18) Table name
CREATEDATE DATE Creation date of the relationship
CREATETIME TIME Creation time of the relationship
MOD_USES_VIE Relationship Module Uses View
DEFOBJTYPE CHAR ( 18) MODULE
DEFOWNER CHAR ( 18) Owner name of the module
DEFPROGRAMNAME CHAR ( 18) Program name
DEFMODULENAME CHAR ( 18) Module name
DEFPROGLANG CHAR ( 18) Programming language of the module (c/cobol ...)
RELTYPE CHAR ( 18) USES
REFOBJTYPE CHAR ( 18) VIEW
REFOWNER CHAR ( 18) Owner name of the view table
REFVIEWNAME CHAR ( 18) View table name
CREATEDATE DATE Creation date of the relationship
CREATETIME TIME Creation time of the relationship
PROGRAMS Programs accessible to the user
OWNER CHAR ( 18) Owner name of the program
PROGRAMNAME CHAR ( 18) Program name
PROGLANG CHAR ( 18) Programming language of the program (c/cobol ...)
CREATEDATE DATE Creation date of the program
CREATETIME TIME Creation time of the program
ALTERDATE DATE Alteration date of the program
ALTERTIME TIME Alteration time of the program
COMMENT LONG Comment on the program
PRO_CONT_MOD Relationship Program Contains Module
DEFOBJTYPE CHAR ( 7) PROGRAM
DEFOWNER CHAR ( 18) Owner name of the program
DEFPROGRAMNAME CHAR ( 18) Program name
DEFPROGLANG CHAR ( 18) Programming language of the program (c/cobol ...)
RELTYPE CHAR ( 8) CONTAINS
REFOBJTYPE CHAR ( 6) MODULE
REFOWNER CHAR ( 18) Owner name of the module
REFPROGRAMNAME CHAR ( 18) Program name
REFMODULENAME CHAR ( 18) Module name
REFPROGLANG CHAR ( 18) Programming language of the module (c/cobol ...)
CREATEDATE DATE Creation date of the relationship
CREATETIME TIME Creation time of the relationship
QCM_USES_COL Relationship QUERY Command Uses Column
DEFOBJTYPE CHAR ( 18) QUERYCOMMAND
DEFOWNER CHAR ( 18) Owner name of the QUERY command
DEFCOMMANDNAME CHAR ( 18) QUERY command name
RELTYPE CHAR ( 18) USES
REFOBJTYPE CHAR ( 18) COLUMN
REFOWNER CHAR ( 18) Owner name of the table
REFTABLENAME CHAR ( 18) Table name
REFCOLUMNNAME CHAR ( 18) Column name
CREATEDATE DATE Creation date of the relationship
CREATETIME TIME Creation time of the relationship
QCM_USES_SNP Relationship QUERY Command Uses Snapshot
DEFOBJTYPE CHAR ( 18) QUERYCOMMAND
DEFOWNER CHAR ( 18) Owner name of the QUERY command
DEFCOMMANDNAME CHAR ( 18) QUERY command name
RELTYPE CHAR ( 18) USES
REFOBJTYPE CHAR ( 18) SNAPSHOT
REFOWNER CHAR ( 18) Owner name of the snapshot table
REFSNAPSHOTNAME CHAR ( 18) Snapshot table name
CREATEDATE DATE Creation date of the relationship
CREATETIME TIME Creation time of the relationship
QCM_USES_SYN Relationship QUERY Command Uses Synonym
DEFOBJTYPE CHAR ( 18) QUERYCOMMAND
DEFOWNER CHAR ( 18) Owner name of the QUERY command
DEFCOMMANDNAME CHAR ( 18) QUERY command name
RELTYPE CHAR ( 18) USES
REFOBJTYPE CHAR ( 18) SYNONYM
REFOWNER CHAR ( 18) Owner name of the synonym
REFSYNONYMNAME CHAR ( 18) Synonym name
CREATEDATE DATE Creation date of the relationship
CREATETIME TIME Creation time of the relationship
QCM_USES_TAB Relationship QUERY Command Uses Table
DEFOBJTYPE CHAR ( 18) QUERYCOMMAND
DEFOWNER CHAR ( 18) Owner name of the QUERY command
DEFCOMMANDNAME CHAR ( 18) QUERY command name
RELTYPE CHAR ( 18) USES
REFOBJTYPE CHAR ( 18) TABLE
REFOWNER CHAR ( 18) Owner name of the table
REFTABLENAME CHAR ( 18) Table name
CREATEDATE DATE Creation date of the relationship
CREATETIME TIME Creation time of the relationship
QCM_USES_VIE Relationship QUERY Command Uses View
DEFOBJTYPE CHAR ( 18) QUERYCOMMAND
DEFOWNER CHAR ( 18) Owner name of the QUERY command
DEFCOMMANDNAME CHAR ( 18) QUERY command name
RELTYPE CHAR ( 18) USES
REFOBJTYPE CHAR ( 18) VIEW
REFOWNER CHAR ( 18) Owner name of the view table
REFVIEWNAME CHAR ( 18) View table name
CREATEDATE DATE Creation date of the relationship
CREATETIME TIME Creation time of the relationship
QPCOMMANDS QueryPlus commands accessible to the user
OWNER CHAR ( 18) Owner name of the QueryPlus command
COMMANDNAME CHAR (150) QueryPlus command name
CREATEDATE DATE Creation date of the QueryPlus command
CREATETIME TIME Creation time of the QueryPlus command
ALTERDATE DATE Alteration date of the QueryPlus command
ALTERTIME TIME Alteration time of the QueryPlus command
COMMENT LONG Comment on the QueryPlus command
QPC_USES_COL Relationship QueryPlus Command Uses Column
DEFOBJTYPE CHAR ( 18) QPCOMMAND
DEFOWNER CHAR ( 18) Owner name of the QueryPlus command
DEFCOMMANDNAME CHAR (150) QueryPlus command name
RELTYPE CHAR ( 18) USES
REFOBJTYPE CHAR ( 18) COLUMN
REFOWNER CHAR ( 18) Owner name of the table
REFTABLENAME CHAR ( 18) Table name
REFCOLUMNNAME CHAR ( 18) Column name
CREATEDATE DATE Creation date of the relationship
CREATETIME TIME Creation time of the relationship
QPC_USES_SNP Relationship QueryPlus Command Uses Snapshot
DEFOBJTYPE CHAR ( 18) QPCOMMAND
DEFOWNER CHAR ( 18) Owner name of the QueryPlus command
DEFCOMMANDNAME CHAR (150) QueryPlus command name
RELTYPE CHAR ( 18) USES
REFOBJTYPE CHAR ( 18) SNAPSHOT
REFOWNER CHAR ( 18) Owner name of the snapshot table
REFSNAPSHOTNAME CHAR ( 18) Snapshot table name
CREATEDATE DATE Creation date of the relationship
CREATETIME TIME Creation time of the relationship
QPC_USES_SYN Relationship QueryPlus Command Uses Synonym
DEFOBJTYPE CHAR ( 18) QPCOMMAND
DEFOWNER CHAR ( 18) Owner name of the QueryPlus command
DEFCOMMANDNAME CHAR (150) QueryPlus command name
RELTYPE CHAR ( 18) USES
REFOBJTYPE CHAR ( 18) SYNONYM
REFOWNER CHAR ( 18) Owner name of the synonym
REFSYNONYMNAME CHAR ( 18) Synonym name
CREATEDATE DATE Creation date of the relationship
CREATETIME TIME Creation time of the relationship
QPC_USES_TAB Relationship QueryPlus Command Uses Table
DEFOBJTYPE CHAR ( 18) QPCOMMAND
DEFOWNER CHAR ( 18) Owner name of the QueryPlus command
DEFCOMMANDNAME CHAR (150) QueryPlus command name
RELTYPE CHAR ( 18) USES
REFOBJTYPE CHAR ( 18) TABLE
REFOWNER CHAR ( 18) Owner name of the table
REFTABLENAME CHAR ( 18) Table name
CREATEDATE DATE Creation date of the relationship
CREATETIME TIME Creation time of the relationship
QPC_USES_VIE Relationship QueryPlus Command Uses View
DEFOBJTYPE CHAR ( 18) QPCOMMAND
DEFOWNER CHAR ( 18) Owner name of the QueryPlus command
DEFCOMMANDNAME CHAR (150) QueryPlus command name
RELTYPE CHAR ( 18) USES
REFOBJTYPE CHAR ( 18) VIEW
REFOWNER CHAR ( 18) Owner name of the view table
REFVIEWNAME CHAR ( 18) View table name
CREATEDATE DATE Creation date of the relationship
CREATETIME TIME Creation time of the relationship
QPEXCELLINKS QueryPlus ExcelLinks accessible to the user
OWNER CHAR ( 18) Owner name of the QueryPlus ExcelLink
EXCELLINKNAME CHAR (150) QueryPlus ExcelLink name
CREATEDATE DATE Creation date of the QueryPlus ExcelLink
CREATETIME TIME Creation time of the QueryPlus ExcelLink
ALTERDATE DATE Alteration date of the QueryPlus ExcelLink
ALTERTIME TIME Alteration time of the QueryPlus ExcelLink
COMMENT LONG Comment on the QueryPlus ExcelLink
QPE_USES_QPC Relationship QueryPlus ExcelLink Uses QueryPlus Command
DEFOBJTYPE CHAR ( 18) QPEXCELLINK
DEFOWNER CHAR ( 18) Owner name of the QueryPlus ExcelLink
DEFEXCELLINKNAME CHAR (150) QueryPlus ExcelLink name
RELTYPE CHAR ( 18) USES
REFOBJTYPE CHAR ( 18) QPCOMMAND
REFOWNER CHAR ( 18) Owner name of the QueryPlus command
REFCOMMANDNAME CHAR (150) QueryPlus command name
CREATEDATE DATE Creation date of the relationship
CREATETIME TIME Creation time of the relationship
QPE_USES_QPQ Relationship QueryPlus ExcelLink Uses QueryPlus Query
DEFOBJTYPE CHAR ( 18) QPEXCELLINK
DEFOWNER CHAR ( 18) Owner name of the QueryPlus ExcelLink
DEFEXCELLINKNAME CHAR (150) QueryPlus ExcelLink name
RELTYPE CHAR ( 18) USES
REFOBJTYPE CHAR ( 18) QPQUERY
REFOWNER CHAR ( 18) Owner name of the QueryPlus query
REFQUERYNAME CHAR (150) QueryPlus query name
CREATEDATE DATE Creation date of the relationship
CREATETIME TIME Creation time of the relationship
QPQUERYS QueryPlus queries accessible to the user
OWNER CHAR ( 18) Owner name of the QueryPlus query
QUERYNAME CHAR (150) QueryPlus query name
CREATEDATE DATE Creation date of the QueryPlus query
CREATETIME TIME Creation time of the QueryPlus query
ALTERDATE DATE Alteration date of the QueryPlus query
ALTERTIME TIME Alteration time of the QueryPlus query
COMMENT LONG Comment on the QueryPlus query
QPQ_USES_COL Relationship QueryPlus Query Uses Column
DEFOBJTYPE CHAR ( 18) QPQUERY
DEFOWNER CHAR ( 18) Owner name of the QueryPlus query
DEFQUERYNAME CHAR (150) QueryPlus query name
RELTYPE CHAR ( 18) USES
REFOBJTYPE CHAR ( 18) COLUMN
REFOWNER CHAR ( 18) Owner name of the table
REFTABLENAME CHAR ( 18) Table name
REFCOLUMNNAME CHAR ( 18) Column name
CREATEDATE DATE Creation date of the relationship
CREATETIME TIME Creation time of the relationship
QPQ_USES_SNP Relationship QueryPlus Query Uses Snapshot
DEFOBJTYPE CHAR ( 18) QPQUERY
DEFOWNER CHAR ( 18) Owner name of the QueryPlus query
DEFQUERYNAME CHAR (150) QueryPlus query name
RELTYPE CHAR ( 18) USES
REFOBJTYPE CHAR ( 18) SNAPSHOT
REFOWNER CHAR ( 18) Owner name of the snapshot table
REFSNAPSHOTNAME CHAR ( 18) Snapshot table name
CREATEDATE DATE Creation date of the relationship
CREATETIME TIME Creation time of the relationship
QPQ_USES_SYN Relationship QueryPlus Query Uses Synonym
DEFOBJTYPE CHAR ( 18) QPQUERY
DEFOWNER CHAR ( 18) Owner name of the QueryPlus query
DEFQUERYNAME CHAR (150) QueryPlus query name
RELTYPE CHAR ( 18) USES
REFOBJTYPE CHAR ( 18) SYNONYM
REFOWNER CHAR ( 18) Owner name of the synonym
REFSYNONYMNAME CHAR ( 18) Synonym name
CREATEDATE DATE Creation date of the relationship
CREATETIME TIME Creation time of the relationship
QPQ_USES_TAB Relationship QueryPlus Query Uses Table
DEFOBJTYPE CHAR ( 18) QPQUERY
DEFOWNER CHAR ( 18) Owner name of the QueryPlus query
DEFQUERYNAME CHAR (150) QueryPlus query name
RELTYPE CHAR ( 18) USES
REFOBJTYPE CHAR ( 18) TABLE
REFOWNER CHAR ( 18) Owner name of the table
REFTABLENAME CHAR ( 18) Table name
CREATEDATE DATE Creation date of the relationship
CREATETIME TIME Creation time of the relationship
QPQ_USES_VIE Relationship QueryPlus Query Uses View
DEFOBJTYPE CHAR ( 18) QPQUERY
DEFOWNER CHAR ( 18) Owner name of the QueryPlus query
DEFQUERYNAME CHAR (150) QueryPlus query name
RELTYPE CHAR ( 18) USES
REFOBJTYPE CHAR ( 18) VIEW
REFOWNER CHAR ( 18) Owner name of the view table
REFVIEWNAME CHAR ( 18) View table name
CREATEDATE DATE Creation date of the relationship
CREATETIME TIME Creation time of the relationship
QPWORDLINKS QueryPlus WordLinks accessible to the user
OWNER CHAR ( 18) Owner name of the QueryPlus WordLink
WORDLINKNAME CHAR (150) QueryPlus WordLink name
CREATEDATE DATE Creation date of the QueryPlus WordLink
CREATETIME TIME Creation time of the QueryPlus WordLink
ALTERDATE DATE Alteration date of the QueryPlus WordLink
ALTERTIME TIME Alteration time of the QueryPlus WordLink
COMMENT LONG Comment on the QueryPlus WordLink
QPW_USES_QPC Relationship QueryPlus WordLink Uses QueryPlus Command
DEFOBJTYPE CHAR ( 18) QPWORDLINK
DEFOWNER CHAR ( 18) Owner name of the QueryPlus WordLink
DEFWORDLINKNAME CHAR (150) QueryPlus WordLink name
RELTYPE CHAR ( 18) USES
REFOBJTYPE CHAR ( 18) QPCOMMAND
REFOWNER CHAR ( 18) Owner name of the QueryPlus command
REFCOMMANDNAME CHAR (150) QueryPlus command name
CREATEDATE DATE Creation date of the relationship
CREATETIME TIME Creation time of the relationship
QPW_USES_QPQ Relationship QueryPlus WordLink Uses QueryPlus Query
DEFOBJTYPE CHAR ( 18) QPWORDLINK
DEFOWNER CHAR ( 18) Owner name of the QueryPlus WordLink
DEFWORDLINKNAME CHAR (150) QueryPlus WordLink name
RELTYPE CHAR ( 18) USES
REFOBJTYPE CHAR ( 18) QPQUERY
REFOWNER CHAR ( 18) Owner name of the QueryPlus query
REFQUERYNAME CHAR (150) QueryPlus query name
CREATEDATE DATE Creation date of the relationship
CREATETIME TIME Creation time of the relationship
QUERYCOMMANDS QUERYcommands accessible to the user
OWNER CHAR ( 18) Owner name of the QUERY command
COMMANDNAME CHAR ( 18) QUERY command name
CREATEDATE DATE Creation date of the QUERY command
CREATETIME TIME Creation time of the QUERY command
ALTERDATE DATE Alteration date of the QUERY command
ALTERTIME TIME Alteration time of the QUERY command
COMMENT LONG Comment on the QUERY command
SEQUENCES Sequences accessible to the user
OWNER CHAR ( 18) Owner name of the sequence
SEQUENCE_NAME CHAR ( 18) Sequence name
MIN_VALUE FIXED ( 10) Minimum value of the sequence
MAX_VALUE FIXED ( 10) Maximum value of the sequence
INCREMENT_BY FIXED ( 10) Value by which the sequence is incremented
CYCLE_FLAG CHAR ( 1) Does the sequence wrap around on reaching the limit?
ORDER_FLAG CHAR ( 1) Are sequence numbers generated in order?
CACHE_SIZE FIXED ( 10) Number of sequence values loaded into the cache
LAST_NUMBER FIXED ( 10) Last sequence number written to disk
CREATEDATE DATE Creation date of the sequence
CREATETIME TIME Creation time of the sequence
COMMENT LONG Comment on the sequence
SERVERDBS All SERVERDBs
NO FIXED ( 4) SERVERDB number
STATE CHAR ( 8) SERVERDB state
MAJORITY CHAR ( 8) SERVERDB belongs to the majority (yes/no)
SERVERDB CHAR ( 18) SERVERDB name
SERVERNODE CHAR ( 64) SERVERNODE in the network
SNAPSHOTDEFS Definition of a snapshot table accessible to the user
OWNER CHAR ( 18) Owner name of the snapshot table
SNAPSHOTNAME CHAR ( 18) Snapshot table name
FAST_REFRESHABLE CHAR ( 3) Snapshot table can be refreshed fast (yes/no)
MASTER_OWNER CHAR ( 18) Owner name of the base table on which the snapshot table was built
MASTER_TABLENAME CHAR ( 18) Table name of the base table on which the snapshot table was built
LEN FIXED ( 4) Length of the snapshot table definition
DEFINITION LONG Text of the snapshot table definition
SNAPSHOTS Snapshot tables accessible to the user
OWNER CHAR ( 18) Owner name of the snapshot table
SNAPSHOTNAME CHAR ( 18) Snapshot table name
PRIVILEGES CHAR ( 30) User's privileges for the snapshot table
TYPE CHAR ( 8) Type of the table
CREATEDATE DATE Creation date of the snapshot table
CREATETIME TIME Creation time of the snapshot table
UPDSTATDATE DATE Date of the last <update statistics> performed on the snapshot table
UPDSTATTIME TIME Time of the last <update statistics> performed on the snapshot table
ALTERDATE DATE Alteration date of the snapshot table
ALTERTIME TIME Alteration time of the snapshot table
REPLICATION CHAR ( 3) Snapshot table is replicated (yes/no/null)
SERVERDB CHAR ( 18) SERVERDB name
SERVERNODE CHAR ( 64) SERVERNODE in the network
COMMENT LONG Comment on the snapshot table
SNP_CONT_COL Relationship Snapshot Contains Column
DEFOBJTYPE CHAR ( 5) SNAPSHOT
DEFOWNER CHAR ( 18) Owner name of the snapshot table
DEFSNAPSHOTNAME CHAR ( 18) Snapshot table name
RELTYPE CHAR ( 8) CONTAINS
REFOBJTYPE CHAR ( 6) COLUMN
REFOWNER CHAR ( 18) Owner name of the snapshot table
REFTABLENAME CHAR ( 18) Table name
REFCOLUMNNAME CHAR ( 18) Column name
POS FIXED ( 3) Original position of the column in the snapshot table
CREATEDATE DATE Creation date of the relationship
CREATETIME TIME Creation time of the relationship
SNP_USES_SYN Relationship Snapshot Uses Synonym
DEFOBJTYPE CHAR ( 8) SNAPSHOT
DEFOWNER CHAR ( 18) Owner name of the snapshot table
DEFSNAPSHOTNAME CHAR ( 18) Snapshot table name
RELTYPE CHAR ( 4) USES
REFOBJTYPE CHAR ( 5) SYNONYM
REFOWNER CHAR ( 18) Owner name of the synonym
REFSYNONYMNAME CHAR ( 18) Synonym name
CREATEDATE DATE Creation date of the relationship
CREATETIME TIME Creation time of the relationship
SNP_USES_TAB Relationship Snapshot Uses Table
DEFOBJTYPE CHAR ( 8) SNAPSHOT
DEFOWNER CHAR ( 18) Owner name of the snapshot table
DEFSNAPSHOTNAME CHAR ( 18) Snapshot table name
RELTYPE CHAR ( 4) USES
REFOBJTYPE CHAR ( 5) TABLE
REFOWNER CHAR ( 18) Owner name of the table
REFTABLENAME CHAR ( 18) Table name
CREATEDATE DATE Creation date of the relationship
CREATETIME TIME Creation time of the relationship
SNP_USES_VIE Relationship Snapshot Uses View
DEFOBJTYPE CHAR ( 8) SNAPSHOT
DEFOWNER CHAR ( 18) Owner name of the snapshot table
DEFSNAPSHOTNAME CHAR ( 18) Snapshot table name
RELTYPE CHAR ( 4) USES
REFOBJTYPE CHAR ( 5) VIEW
REFOWNER CHAR ( 18) Owner name of the view table
REFVIEWNAME CHAR ( 18) View table name
CREATEDATE DATE Creation date of the relationship
CREATETIME TIME Creation time of the relationship
SYNONYMS Synonyms accessible to the user
OWNER CHAR ( 18) Owner name of the synonym
SYNONYMNAME CHAR ( 18) Synonym name
TABLEOWNER CHAR ( 18) Owner name of the table
TABLENAME CHAR ( 18) Table name
CREATEDATE DATE Creation date of the synonym
CREATETIME TIME Creation time of the synonym
COMMENT LONG Comment on the synonym
SYN_REFS_TAB Relationship Synonym Refers to Table
DEFOBJTYPE CHAR ( 7) SYNONYM
DEFOWNER CHAR ( 18) Owner name of the synonym
DEFSYNONYMNAME CHAR ( 18) Synonym name
RELTYPE CHAR ( 6) REFERS
REFOBJTYPE CHAR ( 5) TABLE
REFOWNER CHAR ( 18) Owner name of the table
REFTABLENAME CHAR ( 18) Table name
CREATEDATE DATE Creation date of the relationship
CREATETIME TIME Creation time of the relationship
TABLES Tables, views, snapshots, synonyms, results accessible to the user
OWNER CHAR ( 18) Owner name of the table, view, snapshot, synonym, result
TABLENAME CHAR ( 18) Table, view, snapshot, synonym, result name
PRIVILEGES CHAR ( 30) User's privileges for the table, view, snapshot, synonym, result
TYPE CHAR ( 8) Table type (table / view / synonym / snapshot / result)
CREATEDATE DATE Creation date of the table, view, snapshot, synonym, result
CREATETIME TIME Creation time of the table, view, snapshot, synonym, result
UPDSTATDATE DATE Date of the last <update statistics> performed on the table
UPDSTATTIME TIME Time of the last <update statistics> performed on the table
ALTERDATE DATE Alteration date of the table
ALTERTIME TIME Alteration time of the table
REPLICATION CHAR ( 3) Table is replicated (yes/no/null)
SERVERDB CHAR ( 18) SERVERDB name
SERVERNODE CHAR ( 64) SERVERNODE in the network
SNAPSHOT_LOG CHAR ( 3) Table has a snapshot log (yes/no)
COMMENT LONG Comment on the table, view, snapshot, synonym
TAB_CONT_COL Relationship Table Contains Column
DEFOBJTYPE CHAR ( 5) TABLE
DEFOWNER CHAR ( 18) Owner name of the table
DEFTABLENAME CHAR ( 18) Table name
RELTYPE CHAR ( 8) CONTAINS
REFOBJTYPE CHAR ( 6) COLUMN
REFOWNER CHAR ( 18) Owner name of the table
REFTABLENAME CHAR ( 18) Table name
REFCOLUMNNAME CHAR ( 18) Column name
POS FIXED ( 3) Original position of the column in the table
CREATEDATE DATE Creation date of the relationship
CREATETIME TIME Creation time of the relationship
TAB_CONT_TRG Relationship Table Contains Trigger
DEFOBJTYPE CHAR ( 5) TABLE
DEFOWNER CHAR ( 18) Owner name of the table
DEFTABLENAME CHAR ( 18) Table name
RELTYPE CHAR ( 8) CONTAINS
REFOBJTYPE CHAR ( 7) TRIGGER
REFOWNER CHAR ( 18) Owner name of the table
REFTABLENAME CHAR ( 18) Table name
REFTRIGGERNAME CHAR ( 18) Trigger name
CREATEDATE DATE Creation date of the relationship
CREATETIME TIME Creation time of the relationship
TAB_USES_CON Relationship Table Uses Constraint
DEFOBJTYPE CHAR ( 5) TABLE
DEFOWNER CHAR ( 18) Owner name of the table
DEFTABLENAME CHAR ( 18) Table name
RELTYPE CHAR ( 4) USES
REFOBJTYPE CHAR ( 10) CONSTRAINT
REFOWNER CHAR ( 18) Owner name of the table
REFTABLENAME CHAR ( 18) Table name
REFCONSTRAINTNAME CHAR ( 18) <constraint definition> name
TERMCHARSETS All TERMCHAR SETs
TERMCHARSETNAME CHAR ( 18) Name of the TERMCHAR SET
CODE CHAR ( 8) Code type for which the TERMCHAR SET was defined (ascii/ebcdic)
STATE CHAR ( 8) TERMCHAR SET is activated (enabled/disabled)
INTERN CHAR ( 1) The original form in hexadecimal format
EXTERN CHAR ( 1) The terminal-specific variant in hexadecimal format
COMMENT CHAR ( 8) Comment on the TERMCHAR SET
TRG_CONT_PRM Relationship Trigger Contains Parameter
DEFOBJTYPE CHAR ( 7) TRIGGER
DEFOWNER CHAR ( 18) Owner name of the table
DEFTABLENAME CHAR ( 18) Table name
DEFTRIGGERNAME CHAR ( 18) Trigger name
RELTYPE CHAR ( 8) CONTAINS
REFOBJTYPE CHAR ( 12) TRIGGERPARAM
REFOWNER CHAR ( 18) Owner name of the table
REFTABLENAME CHAR ( 18) Table name
REFTRIGGERNAME CHAR ( 18) Trigger name
REFPARAMETERNAME CHAR ( 18) Parameter name
POS FIXED ( 3) Original position of the parameter in the trigger
CREATEDATE DATE Creation date of the relationship
CREATETIME TIME Creation time of the relationship
TRG_REFS_MOD Relationship Trigger Refers to Module
DEFOBJTYPE CHAR ( 7) TRIGGER
DEFOWNER CHAR ( 18) Owner name of the table
DEFTABLENAME CHAR ( 18) Table name
DEFTRIGGERNAME CHAR ( 18) Trigger name
RELTYPE CHAR ( 6) REFERS
REFOBJTYPE CHAR ( 6) MODULE
REFOWNER CHAR ( 18) Owner name of the module
REFPROGRAMNAME CHAR ( 18) Program name
REFMODULENAME CHAR ( 18) Module name
REFPROGLANG CHAR ( 6) Programming language of the module (c/cobol ...)
CREATEDATE DATE Creation date of the relationship
CREATETIME TIME Creation time of the relationship
TRIGGERPARAMS Parameters of a trigger that is accessible to the user
OWNER CHAR ( 18) Owner name of the table
TABLENAME CHAR ( 18) Table name
TRIGGERNAME CHAR ( 18) Trigger name
PARAMETERNAME CHAR ( 18) Parameter name
POS FIXED ( 3) Original position of the parameter in the trigger
NEW/OLD-TYPE CHAR ( 3) Version of the parameter (new/old)
DATATYPE CHAR ( 10) Data type of the column (boolean / char / date / fixed / float / time / timestamp)
LEN FIXED ( 4) Length or precision of the column
DEC FIXED ( 3) Digits to the right of the decimal point in FIXED-type parameters
CREATEDATE DATE Creation date of the trigger
CREATETIME TIME Creation time of the trigger
TRIGGERS Triggers accessible to the user
OWNER CHAR ( 18) Owner name of the table
TABLENAME CHAR ( 18) Table name
TRIGGERNAME CHAR ( 18) Trigger name
INSERT CHAR ( 3) Type of the trigger
UPDATE CHAR ( 3) Type of the trigger
DELETE CHAR ( 3) Type of the trigger
CREATEDATE DATE Creation date of the trigger
CREATETIME TIME Creation time of the trigger
DEFINITION LONG Text of the trigger definition
COMMENT LONG Comment on the trigger
USERS All users
OWNER CHAR ( 18) Owner name of the user
GROUPNAME CHAR ( 18) Group name
USERNAME CHAR ( 18) User name
USERMODE CHAR ( 8) Class of the user (sysdba / dba / resource / standard)
CONNECTMODE CHAR ( 8) Connect mode (multiple/single)
PERMLIMIT FIXED ( 10) PERMLIMIT value
TEMPLIMIT FIXED ( 10) TEMPLIMIT value
MAXTIMEOUT FIXED ( 10) TIMEOUT value
COSTWARNING FIXED ( 10) COSTWARNING value
COSTLIMIT FIXED ( 10) COSTLIMIT value
CACHELIMIT FIXED ( 10) CACHELIMIT value
CREATEDATE DATE Creation date of the user
CREATETIME TIME Creation time of the user
ALTERDATE DATE Alteration date of the user
ALTERTIME TIME Alteration time of the user
PWCREADATE DATE Creation date of the password
PWCREATIME TIME Creation time of the password
SERVERDB CHAR ( 18) SERVERDB name
SERVERNODE CHAR ( 64) SERVERNODE in the network
COMMENT LONG Comment on the user
USR_OWNS_DBF Relationship User Owns DB Function
DEFOBJTYPE CHAR ( 4) USER
DEFOWNER CHAR ( 18) Owner name of the user
DEFGROUPNAME CHAR ( 18) Group name
DEFUSERNAME CHAR ( 18) User name
RELTYPE CHAR ( 4) OWNS
REFOBJTYPE CHAR ( 10) DBFUNCTION
REFOWNER CHAR ( 18) Owner name of the DB function
REFDBFUNCNAME CHAR ( 18) DB function name
CREATEDATE DATE Creation date of the relationship
CREATETIME TIME Creation time of the relationship
USR_OWNS_DOM Relationship User Owns Domain
DEFOBJTYPE CHAR ( 4) USER
DEFOWNER CHAR ( 18) Owner name of the user
DEFGROUPNAME CHAR ( 18) Group name
DEFUSERNAME CHAR ( 18) User name
RELTYPE CHAR ( 4) OWNS
REFOBJTYPE CHAR ( 6) DOMAIN
REFOWNER CHAR ( 18) Owner name of the domain
REFDOMAINNAME CHAR ( 18) Domain name
CREATEDATE DATE Creation date of the relationship
CREATETIME TIME Creation time of the relationship
USR_OWNS_USR Relationship User Owns User
DEFOBJTYPE CHAR ( 4) USER
DEFOWNER CHAR ( 18) Owner name of the user
DEFGROUPNAME CHAR ( 18) Group name
DEFUSERNAME CHAR ( 18) User name
RELTYPE CHAR ( 4) OWNS
REFOBJTYPE CHAR ( 4) USER
REFOWNER CHAR ( 18) Owner name of the user
REFGROUPNAME CHAR ( 18) Group name
REFUSERNAME CHAR ( 18) User name
CREATEDATE DATE Creation date of the relationship
CREATETIME TIME Creation time of the relationship
USR_USES_COL Relationship User Uses Column
DEFOBJTYPE CHAR ( 4) USER
DEFOWNER CHAR ( 18) Owner name of the user
DEFGROUPNAME CHAR ( 18) Group name
DEFUSERNAME CHAR ( 18) User name
RELTYPE CHAR ( 4) USES
REFOBJTYPE CHAR ( 6) COLUMN
REFOWNER CHAR ( 18) Owner name of the table
REFTABLENAME CHAR ( 18) Table, view or snapshot name
REFCOLUMNNAME CHAR ( 18) Column name
PRIVILEGES CHAR ( 30) User's privileges for the column
CREATEDATE DATE Creation date of the relationship
CREATETIME TIME Creation time of the relationship
USR_USES_DBP Relationship User Uses DB Procedure
DEFOBJTYPE CHAR ( 4) USER
DEFOWNER CHAR ( 18) Owner name of the user
DEFGROUPNAME CHAR ( 18) Group name
DEFUSERNAME CHAR ( 18) User name
RELTYPE CHAR ( 4) USES
REFOBJTYPE CHAR ( 11) DBPROCEDURE
REFOWNER CHAR ( 18) Owner name of the DB procedure
REFPROGRAMNAME CHAR ( 18) Program name
REFDBPROCNAME CHAR ( 18) DB procedure name
CREATEDATE DATE Creation date of the relationship
CREATETIME TIME Creation time of the relationship
USR_USES_PRO Relationship User Uses Program
DEFOBJTYPE CHAR ( 18) USER
DEFOWNER CHAR ( 18) Owner name of the user
DEFGROUPNAME CHAR ( 18) Group name
DEFUSERNAME CHAR ( 18) User name
RELTYPE CHAR ( 18) USES
REFOBJTYPE CHAR ( 18) PROGRAM
REFOWNER CHAR ( 18) Owner name of the program
REFPROGRAMNAME CHAR ( 18) Program name
REFPROGLANG CHAR ( 18) Programming language of the program (c/cobol ...)
PRIVILEGES CHAR ( 30) User's privileges for the program
CREATEDATE DATE Creation date of the relationship
CREATETIME TIME Creation time of the relationship
USR_USES_QCM Relationship User Uses QUERY Command
DEFOBJTYPE CHAR ( 18) USER
DEFOWNER CHAR ( 18) Owner name of the user
DEFGROUPNAME CHAR ( 18) Group name
DEFUSERNAME CHAR ( 18) User name
RELTYPE CHAR ( 18) USES
REFOBJTYPE CHAR ( 18) QUERYCOMMAND
REFOWNER CHAR ( 18) Owner name of the query command
REFCOMMANDNAME CHAR ( 18) Query command name
PRIVILEGES CHAR ( 30) User's privileges for the QUERY command
CREATEDATE DATE Creation date of the relationship
CREATETIME TIME Creation time of the relationship
USR_USES_QPC Relationship User Uses QueryPlus Command
DEFOBJTYPE CHAR ( 18) USER
DEFOWNER CHAR ( 18) Owner name of the user
DEFGROUPNAME CHAR ( 18) Group name
DEFUSERNAME CHAR ( 18) User name
RELTYPE CHAR ( 18) USES
REFOBJTYPE CHAR ( 18) QPCOMMAND
REFOWNER CHAR ( 18) Owner name of the QueryPlus command
REFCOMMANDNAME CHAR (150) QueryPlus command name
PRIVILEGES CHAR ( 30) User's privileges for the QueryPlus command
CREATEDATE DATE Creation date of the relationship
CREATETIME TIME Creation time of the relationship
USR_USES_QPE Relationship User Uses QueryPlus ExcelLink
DEFOBJTYPE CHAR ( 18) USER
DEFOWNER CHAR ( 18) Owner name of the user
DEFGROUPNAME CHAR ( 18) Group name
DEFUSERNAME CHAR ( 18) User name
RELTYPE CHAR ( 18) USES
REFOBJTYPE CHAR ( 18) QPEXCELLINK
REFOWNER CHAR ( 18) Owner name of the QueryPlus ExcelLink
REFEXCELLINKNAME CHAR (150) QueryPlus ExcelLink name
PRIVILEGES CHAR ( 30) User's privileges for the QueryPlus ExcelLink
CREATEDATE DATE Creation date of the relationship
CREATETIME TIME Creation time of the relationship
USR_USES_QPQ Relationship User Uses QueryPlus Query
DEFOBJTYPE CHAR ( 18) USER
DEFOWNER CHAR ( 18) Owner name of the user
DEFGROUPNAME CHAR ( 18) Group name
DEFUSERNAME CHAR ( 18) User name
RELTYPE CHAR ( 18) USES
REFOBJTYPE CHAR ( 18) QPQUERY
REFOWNER CHAR ( 18) Owner name of the QueryPlus query
REFQUERYNAME CHAR (150) QueryPlus query name
PRIVILEGES CHAR ( 30) User's privileges for the QueryPlus query
CREATEDATE DATE Creation date of the relationship
CREATETIME TIME Creation time of the relationship
USR_USES_QPW Relationship User Uses QueryPlus WordLink
DEFOBJTYPE CHAR ( 18) USER
DEFOWNER CHAR ( 18) Owner name of the user
DEFGROUPNAME CHAR ( 18) Group name
DEFUSERNAME CHAR ( 18) User name
RELTYPE CHAR ( 18) USES
REFOBJTYPE CHAR ( 18) QPWORDLINK
REFOWNER CHAR ( 18) Owner name of the QueryPlus WordLink
REFWORDLINKNAME CHAR (150) QueryPlus WordLink name
PRIVILEGES CHAR ( 30) User's privileges for the QueryPlus WordLink
CREATEDATE DATE Creation date of the relationship
CREATETIME TIME Creation time of the relationship
USR_USES_TAB Relationship User Uses table
DEFOBJTYPE CHAR ( 4) USER
DEFOWNER CHAR ( 18) Owner name of the user
DEFGROUPNAME CHAR ( 18) Group name
DEFUSERNAME CHAR ( 18) User name
RELTYPE CHAR ( 4) USES
REFOBJTYPE CHAR ( 5) TABLE
REFOWNER CHAR ( 18) Owner name of the table
REFTABLENAME CHAR ( 18) Table name
PRIVILEGES CHAR ( 30) User's privileges for the table
CREATEDATE DATE Creation date of the relationship
CREATETIME TIME Creation time of the relationship
VERSIONS Version
KERNEL CHAR ( 40) Version of the ADABAS server
RUNTIMEENVIRONMENT CHAR ( 40) Version of the runtime environment
VIEWDEFS Definition of a view accessible to the user
OWNER CHAR ( 18) Owner name of the view table
VIEWNAME CHAR ( 18) View table name
LEN FIXED ( 4) Length of the view table definition
DEFINITION LONG Text of the view table definition
VIEWS View tables accessible to the user
OWNER CHAR ( 18) Owner name of the view table
VIEWNAME CHAR ( 18) View table name
PRIVILEGES CHAR ( 30) User's privileges for the view table
TYPE CHAR ( 8) Type of the table
CREATEDATE DATE Creation date of the view table
CREATETIME TIME Creation time of the view table
UPDSTATDATE DATE Date of the last <update statistics> performed on the view table
UPDSTATTIME TIME Time of the last <update statistics> performed on the view table
ALTERDATE DATE Alteration date of the view
ALTERTIME TIME Alteration time of the view
REPLICATION CHAR ( 3) Table is replicated (yes/no/null)
SERVERDB CHAR ( 18) SERVERDB name
SERVERNODE CHAR ( 64) SERVERNODE in the network
COMMENT LONG Comment on the view table
VIE_CONT_COL Relationship View Contains Column
DEFOBJTYPE CHAR ( 5) VIEW
DEFOWNER CHAR ( 18) Owner name of the view table
DEFVIEWNAME CHAR ( 18) View table name
RELTYPE CHAR ( 8) CONTAINS
REFOBJTYPE CHAR ( 6) COLUMN
REFOWNER CHAR ( 18) Owner name of the view table
REFTABLENAME CHAR ( 18) Table name
REFCOLUMNNAME CHAR ( 18) Column name
POS FIXED ( 3) Original position of the column in the view table
CREATEDATE DATE Creation date of the relationship
CREATETIME TIME Creation time of the relationship
VIE_USES_SNP Relationship View Uses Snapshot
DEFOBJTYPE CHAR ( 4) VIEW
DEFOWNER CHAR ( 18) Owner name of the view table
DEFVIEWNAME CHAR ( 18) View table name
RELTYPE CHAR ( 4) USES
REFOBJTYPE CHAR ( 5) SNAPSHOT
REFOWNER CHAR ( 18) Owner name of the snapshot table
REFSNAPSHOTNAME CHAR ( 18) Snapshot table name
CREATEDATE DATE Creation date of the relationship
CREATETIME TIME Creation time of the relationship
VIE_USES_SYN Relationship View Uses Synonym
DEFOBJTYPE CHAR ( 4) VIEW
DEFOWNER CHAR ( 18) Owner name of the view table
DEFVIEWNAME CHAR ( 18) View table name
RELTYPE CHAR ( 4) USES
REFOBJTYPE CHAR ( 5) SYNONYM
REFOWNER CHAR ( 18) Owner name of the synonym
REFSYNONYMNAME CHAR ( 18) Synonym name
CREATEDATE DATE Creation date of the relationship
CREATETIME TIME Creation time of the relationship
VIE_USES_TAB Relationship View Uses Table
DEFOBJTYPE CHAR ( 4) VIEW
DEFOWNER CHAR ( 18) Owner name of the view table
DEFVIEWNAME CHAR ( 18) View table name
RELTYPE CHAR ( 4) USES
REFOBJTYPE CHAR ( 5) TABLE
REFOWNER CHAR ( 18) Owner name of the view table
REFTABLENAME CHAR ( 18) Table name
CREATEDATE DATE Creation date of the relationship
CREATETIME TIME Creation time of the relationship
VIE_USES_VIE Relationship View Uses View
DEFOBJTYPE CHAR ( 4) VIEW
DEFOWNER CHAR ( 18) Owner name of the view table
DEFVIEWNAME CHAR ( 18) View table name
RELTYPE CHAR ( 4) USES
REFOBJTYPE CHAR ( 5) VIEW
REFOWNER CHAR ( 18) Owner name of the view table
REFVIEWNAME CHAR ( 18) View table name
CREATEDATE DATE Creation date of the relationship
CREATETIME TIME Creation time of the relationship