Micro Focus Relativity DBA for Windows
Relativity Overview
Relativity Designer
Relativity DBA
Relativity Database Management System
Micro Focus End User License Agreement
The Micro Focus Community
Contacting Micro Focus
Further Information and Product Support
Information We Need
Creating Debug Files
Getting Started
Starting and Stopping the Relativity DBA
Starting the Relativity DBA
Exit the Relativity DBA
Relativity Catalogs
Configuring Relativity Data Sources
Single-tier and Client/Server Data Sources
Relativity Drivers
Setting up a New Data Source
Opening an Existing Data Source
Closing a Data Source
Configuring the Workspace
Relativity DBA Window
Setting a Theme for the Relativity DBA Window
Setting Options
General Options
Creating Table Instances
Creating a Table Instance
Using the Query Builder
Configuring Tables for Multi-File Support
Deleting a Table Instance
Maintaining the Relativity Database
Defining Date Constants
Define Base Date for Days Count
Define the Structure and Base Year for YY Dates
Define the Structure and Base Date for YYYY Dates
Maintaining Character Sets
Adding a Standard Character Set
Adding a Non-standard Character Set
Changing Existing Character Sets for a Data Source
Changing the Location of the Euro Character in a Character Set
Define Nonstandard Character Sets
Unicode Consortium's Format A
Supported Standard Character Sets
Defining a Nonstandard Character Set
Modifying an Existing Relativity Character Set
Importing a Standard Character Set Not Supported by Relativity
Error Messages When Importing a Character Set
Distributing Catalogs
Distributing Updated Catalogs
Merging a Catalog
Rules File for Merging a Catalog
Sample Rules File
Defining Security for Relativity Databases
Securing Relativity Databases
Catalog Ownership
Defining Groups and Users
Add a User Group to the Catalog
Add a User to a Group
Delete a Group from the Catalog
Delete a User from a Group
Change a Group Name and Password
Change a User Name and Password
Defining Group Privileges
Administrator Privileges
Enable Administrator Privileges
Create Users Privilege
Enable the Create Users Privilege
Create Tables Privilege
Enable the Create Tables Privilege
Table Access Privileges
Enable Table Access Privileges
Column Access Privileges
Enable Column Access Privileges
Enable Public Table Access Privileges
Reporting
Running and Exporting Reports
Users Reports
Connections Reports
Privileges Reports
Reference Information
Database Logon Window
File Menu Commands
Tools Menu Commands
Help Menu Commands
SQL Reserved Words
Glossary of Terms
88-level
catalog
Character Set
COBOL Name property
COBOL table
coinciding OCCURS
CombineDateTime
Comment property
Complement
ComputeCenturyDate
ComputeCenturyDateTime
ComputeDateTime
ComputeODO
ComputeTime
condition item
condition-name
conditional variable
Constrain property
custom data types
Custom Data Type property
data item
data source
data-name
database
date constants
Default Column Name property
entered numerics
domain
file label item
filter subexpression
filter
function item
function
Hexadecimal condition values
indexed file
internal function
ISAM file
IsNumeric
IsValidDate
item set
LogicalAnd
LogicalOr
Not Null property
null
Null Value property
nullable
ODBC data type
ODBC-enabled application
ODBC
ODO control item
Open Database Connectivity
property
RDBMS
record type filter
record type
Redefined By property
Redefines property
redundant data items
relational database management system
relational database
relational table
Relativity Data Client
Relativity Data Manager
Relativity Data Server
Relativity DBMS
repeating data item
SQL
Standard character sets
Structured Query Language
subscript item
subscripted data item
table
table definition
table filter
table name
transform
Transform property
Value property
Copyright and Legal Information
Copyright and Trademarks