Micro Focus Relativity Designer for Windows

Micro Focus Relativity Designer for Windows

Relativity Overview

Relativity Designer

Relativity Database Management System

Relativity Products

Micro Focus End User License Agreement

The Micro Focus Community

Contacting Micro Focus

Further Information and Customer Care

Information We Need

Creating Debug Files

Getting Started

Starting and Stopping the Relativity Designer

Starting the Relativity Designer

Exit the Relativity Designer

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 Designer Window

Setting a Theme for the Relativity Designer Window

Setting Options

General Options

Catalog Options

Date Format Options

COBOL Data Types Options

Advanced Options

Preparing the COBOL Source

Importing COBOL File Definitions into Relativity

The COBOL Syntax File

Importing from a COBOL Source File or COBOL Syntax File

Extraction Restrictions

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

Augmenting the COBOL File Definition in the FD Form

Displaying Data Item Properties

Defining Default Column Names

Editing Default Column Names

Redefining Data Items

Redefining a Data Item

Defining Conditions

Adding a Condition

Editing a Condition

Deleting a Condition

Defining Record Types

Adding a Record Type

Editing a Record Type

Renaming a Record Type

Deleting a Record Type

Defining Record Type Filters

Adding a Factor to a Record Type Filter

Defining Default Values

Defining a Default Value

Defining Custom Data Types

Creating a Custom Data Type

Editing a Custom Data Type

Deleting a Custom Data Type

Specifying Treatment of the OCCURS Clause

Identifying Coinciding OCCURS Clauses

Marking Items as Coinciding OCCURS

Removing Coinciding OCCURS Items

Flattening OCCURS

Adding Subscript Conditions to Flatten the OCCURS

Eliminating Unused Occurrences

Identifying Implicit OCCURS DEPENDING ON Clauses

Identifying the OCCURS DEPENDING ON Control Item

Changing or Removing the OCCURS DEPENDING ON Control Item

Using Functions and Transforms

Transforms

Hexadecimal Transforms

Standard Date and Time Transforms

Modifiers for Date and Time Transforms

User-Configurable Date Transforms

Math Transforms

Special Date and Date Time Transforms

LogicalOrder Column Transforms

Enabling the LogicalOrder Column Transform

Apply the LogicalOrder Column Transform on an Entire Data Source

Apply the LogicalOrder Column Transform on an Individual Column

Internal Functions

CombineDateTime

ComputeCenturyDate

ComputeCenturyDateTime

ComputeDateTime

Synthesize a Data Item Using an Internal Function

Defining Item Sets

Configuring Items in an Item Set

Defining Null Information

Specifying Comments

Filtering File Definitions

Exporting File Definitions

Defining Relational Tables in the Table Form

Creating and Editing Table Definitions

Creating a Table Definition

Editing a Table Definition

Copying a Table Definition

Deleting a Table Definition

Defining Columns on Repeating Data Items

Binding a Column to a Subscript

Handling Multiple Record Types

Defining Table Filters

Creating a Table Filter

Editing a Table Filter

Deleting a Table Filter

Defining Transforms on Columns

Building Writable Tables

Defining Insertable Tables

Building a New Record

Rules for Insertable Tables

Repeating Item Rule

Record Type Rule

Only One 01 Rule

Null Condition Rule

Nullable Columns Rule

Determining Occurrence Count

Determining Record Type

Modifying an Existing Record

Using the Nullable Columns Report

Running the Nullable Columns Report

Establishing Table Instances

Creating a Table Instance

Editing a Table Instance

Deleting a Table Instance

Determining Micro Focus COBOL Indexed File Formats

Supporting Multi-file Tables

Enabling Multi-File Support

Configuring Tables for Multi-File Support

Previewing Table Data

Previewing Table Data from the Table Form

Using the Query Builder

Analyzing Table Definition Errors

Maintaining the Relativity Database

File Definition Maintenance

Updating COBOL Data File Definitions

Updating FDs from a COBOL Source File or COBOL Syntax File

Merging Definitions from Another Relativity Catalog

Merging from Another Relativity Data Source

Relational Maintenance

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

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

Change the Owner of Catalog

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

COBOL Items Reports

Cross-reference Reports

Connections Reports

Privileges Reports

Reference Information

Database Logon Window

File Menu Commands

Tools Menu Commands

Help Menu Commands

Pattern Matching

Regular Expression Syntax Used in Pattern Matching

Pattern Matching Examples

Pattern Match Anywhere

Pattern Match at Beginning

Pattern Match at Ending

Pattern Match Entire Searched String

Match the Beginning of a String

Match the Ending of a String

Pattern Match Any Single Character

Pattern Match Zero or More Characters

Pattern Match Any Single Digit

Pattern Match Special Character

Pattern Match Any Character in a Range

Pattern Match Any Character Outside a Range

Use Back References in Replacement Strings

SQL Reserved Words

Glossary of Terms

COBOL Name property

coinciding OCCURS

CombineDateTime

Comment property

ComputeCenturyDate

ComputeCenturyDateTime

ComputeDateTime

conditional variable

Constrain property

custom data types

Custom Data Type property

Default Column Name property

Default Value property

entered numerics

file label item

filter subexpression

Hexadecimal condition values

internal function

Not Null property

Null Value property

ODBC-enabled application

ODO control item

Open Database Connectivity

record type filter

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

Standard character sets

Structured Query Language

subscripted data item

table definition

Transform property

Copyright and Legal Information

Copyright and Trademarks