Data Express

All Machine ID./Companies

Window Components

Machine ID./Company Grid

Multiple Class Selection

Object Distribution

Column Headings in the Grid Area

Available Grid Operations

Data Changer Data Store Properties

Window Contents

Data Changer Data Element Selection

Window Contents

Data Store Information

Icon Bar

List of Data Elements

Data Changer Data Element Properties

General Data Element Properties

Additional Data Element Properties

Data Changer - Work with Classes

Window Contents

Data Changer Properties

Set Application ID

Define Unload Output Data Store

Options

Work with Data Changer Jobs

Data Store Data Changer Job Creation

Create Data Changer Job Creation

Distributed Exporter

Window Contents

Writing Routine Parameters

Exit Routines

Writing Exit Routines

Discard Exit Routines

Discard Routine Parameters

UDCUSSL Discard Exit Routine Example

Modification Exit Routines

Predefined Modification Exit Routines List

Modification Exit Routines Parameters

Logging Exit Routines

Predefined Masking and Logging Exit Routines List

Masking Routine UDCMASPG - Prototype

Masking Routine UDCLOGPG – Prototype

Logging Table HSLOGTAB

Appendix A: COBOL Masking Routines Technical Description

A.1. Masking Routines Interface

A.2. Interface Source

A.2.1. Data Express for z/OS

A.2.2. Data Express for Distributed Systems

A.3. Interface Description

A.4. UR-ACTION Values

Appendix B: C Masking Routines for ODBC - Technical Description

Appendix C: C Masking Routines for OCI - Technical Description

Data Model Guide

Table and Column Descriptions

Sequential Files

Combined List Interface

DB2 Catalog Synchronization Information

DB2 Catalog Synchronization - HEADER

DB2 Catalog Synchronization - INTERNAL KEY

DB2 Catalog Synchronization - EXTERNAL KEY

DB2 Catalog Synchronization - IMAGE COPY

Load Copy Information from External Interface

Flag replace Parameter

Flag associate Parameter

Copy Tolerance Parameter

COBOL Decimal Seperator Parameter

Maximum Progressive of I/O Area Parameter

Statement Length in PL/I Source Parameter

Load Data Store Information from External Interface

DB2 Databases

Direct Access – API Load Sequential File

Direct Access – HEADER

Direct Access – DETAIL

Access from Unload

VSAM Databases

Sequential and GDG Databases

DL/I Databases

ADABAS Data Stores

ADABAS – API Load Sequential File - HEADER

ADABAS Data Store – DETAIL

Load Referential Integrity Relation Information

Import Classification from Data Dictionary

IMPSRC - Modified Sources

HEADER

DETAIL

Method List Interface

Multi-format List Interface

Data Subset Extraction Guide

Who should read this guide

Data Subset Extraction considerations

Getting Started

General characteristics of use

Starting Data Subset Extraction

Menus

Context menus

Column sorting

Grid functions

Introduction to Data Subset Extraction window

Window components

Node pane

Icons

Context menu

Column headers by group

List of groups

List of methods in group

List of Steps in Method Group

Column headers by creator

List of creators

List of methods created by

List of steps in method creator

Work with Groups

Introduction to Work with Groups

Introduction to New Method wizard

New Method wizard

Creating a new method

Definition of general method characteristics

Definition of primary extraction criteria

Definition of relationship criteria

Method Confirmation phase

Work with Method

Introduction to the Work with Method area

Method elaboration

Method Activation phase

Extraction Batch Job Launch phase

Fields

Steps context menu

Tabs

Elaborations

Excluded files

Work with Method selection class/filter properties

Introduction to selection class/filter properties

Window contents

Column headings in top grid

Global filter fields

Filter types

Filter type properties

Work with Method work with steps

Introduction Work with Method work with steps

Window contents

Display mode

Insert mode

Introduction to Work with Method method properties

Work with Method method properties

Introduction to Work with Method elaboration properties

Method activation

Work with Method elaboration properties

Window contents

Method’s description

Elaboration’s description

Introduction to Work with Method define reload rules

Work with Method define reload rules

Create reload jobs from reload rules

Job creation

JCL information

Options

Introduction to Options

Window contents

General

Server information

Introduction to data subset extraction jobs

Data subset extraction jobs

Job creation

Test environment creation

Create allocation jobs

Create unload jobs

Create extraction jobs

Create reload jobs

Distributed Exporter

Distributed Statistics Loader

Introduction to Work with Method multiple filters

Work with Method multiple filters

More than one single filter for the same data store

Filter types

Filter examples more than one single filter

More than one combined filter involving more than one data element

Filter types

Filter examples more than one data element

Error Messages

Error Message Format

Mainframe Messages WRC0001 to WRC0199

Mainframe Messages WRC0200 to WRC0299

Mainframe Messages WRC0300 to WRC0399

Mainframe Messages WRC0400 to WRC0499

Mainframe Messages WRC0500 to WRC0599

Mainframe Messages WRC2000 to WRC4999

Data Express Extension Messages

Front End Guide

General Features

Considerations

Getting Started with Data Builder

General characteristics of use

Starting the Data Builder module

Work environment settings

Machine identifier creation

Company creation

Application identifier creation

Default environment parameter settings selection

Analysis parameter modification

Default copy analysis parameter modification

Database interface specification

Database access modes

Process identifier and database types relationships

Main functions - phase execution

Menus

Context menu

Main Window - Work with Data Stores

Window pages

Structure page

Classes page

Assigned to Copy page

Data Changer page

Column headings in the grid area

Available grid operations

Work with Data Store Window

Window contents

Node pane

Grid

Data Elements columns

Associated Copybook columns

Associated Copybook - CopybookName columns

Assigned Classes columns

Sampling columns

Sampling – DataElementName columns

Context menu

Data element properties

Assign an Application ID Window

Window contents - Assign Single

Window contents - Assign Multiple

Add to Combined Data Element Window

Combined data element requirements and limitations

Work with Machine IDs window

Work with Classes

Work with Classes window

Work with Machine IDs

Work with Companies

Work with Application IDs

Work with Routines

Work with Process IDs

Data Element Attributes page

Work with Data Elements

Window contents

Select Data Elements page

Available Filters area

Naming Convention page

Data Store Attributes page

Data Element Class page

Classes - Assignment page

All classes hierarchy

Class Attributes area

List of Scheduled Jobs grid

Estimated Classes - Confirm page

Class Attributes area

Selected Data Element Attributes area

Work with Jobs

Window contents

List of Jobs grid

Window fields

Job creation

Class Field Assignment job

Sections and fields

Create Deletion Statements

Create Format Selector job

DB2 Catalog Synchronization job

Data Store / Copybook Relationship Analysis job

Data Store Data Element Sampling job

Export Class Assignment Information

Export Classes Information

Export Combined Data Elements Information

Export Copybook Information

Export Data Store Information

Export DB2 Table Information

Export Methods Information

Delete Data Stores from Method

Export Multi-format Data Stores Information

Load Distributed Sampling Results job

Import Classes Information

Import Classification from Data Dictionary job

Import Classification from Referential Integrity job

Import Combined Data Elements Information

Import Method from Referential Integrity job

Import Methods Information

Import Multi-format Data Stores Information

Load Copy Information from External Interface job

Load DB2 Table Information by Unload job

Load DL/I Database Information job

Load Data Store Information from External Interface job

Load SEQ/GDG Data Set Information job

Load VSAM Data Set Information job

Custom jobs

New Custom Query Wizard

Starting the New Custom Query wizard

Options

Window contents

General

Filter settings

Confirmation messages

Confirmation routine name

Server information

File Properties

Window contents

General attributes page

System page

Object attributes page

Dates page

Associated Copybook page

Filter by Data Store

Window contents

Associated Copybook page

Scheduling page

Compare Layouts - Copybook

Sample Graph - Data Sampling

DB2 database alias creation

Show Synthetic Data Element Contents

Work with Copybooks

Distributed Loader

Appendix A. Standard Mode

Architecture

Database connection prerequisite

Authorizations and privileges

Appendix B. Client / Server Mode

Architecture

Server connection prerequisite

Defining server connection information

Authorizations and privileges

Starting Server-side Executables as Windows Services

Life Cycle Guide

Considerations

Life Cycle Introduction

Life Cycle Phases

Phase 1: Changed Data Stores Identification

Phase 2: Changed Data Elements Identification

Phase 3: Apply Identified Changes

Sequential Steps

Concepts and Terms

Backup Company

Log Files

Working with Life Cycle

Definition of Environment

Work with Companies

New Company Creation

Execute Life Cycle Phase 1

Modification of Guide Files

Work with Changed Data Stores

Case 1 - New copybook is not associated with data store

Case 2 - Existing copybook is associated with an existing data store

Case 3 - Existing copybook is not associated with any data store

Case 4 - New copybook is associated with new data store (for DB2 files only)

Execute Life Cycle Phase 2

Work with Changed Data Elements

Execute Life Cycle Phase 3

Work with Life Cycle Jobs

Clear Life Cycle History Job Creation

Life Cycle Job Creation