Notices

Preface

1. Overview of HiRDB Dataextractor

1.1 Features

1.2 Functions

2. HiRDB Dataextractor Environment Setup

2.1 Software configuration

2.2 Environment setup procedure

2.2.1 Environment setup procedure

2.2.2 Installing HiRDB Dataextractor

2.2.3 Specifying environment variables

2.2.4 Files required in order to use HiRDB Dataextractor

2.3 Preparations before execution

2.3.1 Preparing tables

2.3.2 Preparing for data transfer

3. Extracting and Importing Data and Creating Files

3.1 Extracting data (HiRDB)

3.1.1 Extracting selected data

3.1.2 Adding columns to extracted data

3.1.3 Converting the data type of extracted data

3.1.4 Converting the character codes of extracted data

3.2 Extracting data (ORACLE)

3.2.1 Extracting selected data

3.2.2 Adding columns to extracted data

3.2.3 Converting the data type of extracted data

3.2.4 Converting the character codes of extracted data

3.3 Importing data

3.4 Creating files

4. Extracting Data from HiRDB and Importing It into HiRDB

4.1 Extraction and import conventions

4.1.1 Conventions for extraction

4.1.2 Conventions for import

4.2 Command

4.2.1 Command format

4.2.2 xtrep command

4.2.3 Additional data extraction and import functions

4.2.4 Contents of files specified with the xtrep command

4.3 Formats of output listings

4.4 Examples

5. Extracting Data from ORACLE and Importing It into HiRDB

5.1 Command

5.1.1 Command format

5.1.2 xtrepO command

5.1.3 Additional data extraction and import functions

5.1.4 Contents of files specified with the xtrepO command

5.2 Formats of output listings

5.3 Examples

6. Operation

6.1 Operating procedure

6.2 Starting and terminating HiRDB Dataextractor

6.2.1 Starting and terminating HiRDB Dataextractor when using TCP/IP

6.2.2 Starting and terminating HiRDB Dataextractor when using OSI

7. Error Handling Procedures

7.1 HiRDB Dataextractor error handling procedures

8. Messages

8.1 Overview of messages

8.1.1 Message format

8.1.2 Message explanatory format

8.1.3 Message output destinations

8.2 Details of messages

Appendixes

A. Memory and File Requirements

B. Functional Differences with Windows

C. Functional Differences with Solaris

D. Functional Differences with Linux

E. Functional Differences with AIX

Index

[Trademarks]

All rights reserved. Copyright (C) 2007, Hitachi, Ltd.