Home | Previous Page | Next Page

Contents

In This Introduction

About This Manual

Software Dependencies

Assumptions About Your Locale

Demonstration Databases

Documentation Conventions

Typographical Conventions

Feature, Product, and Platform

Syntax Diagrams

Example Code Conventions

Additional Documentation

Installation Guides

Informix Error Messages

IBM Informix Dynamic Server Version 10.0 and CSDK Version 2.90 Documentation Set

Compliance with Industry Standards

IBM Welcomes Your Comments

High-Performance Loader Overview

In This Chapter

Overview of Features

onpload Utility

onpladm Utility

onpload Database

Starting onpload

Relationships Among the Parts of the HPL

Environment Variables

DBONPLOAD Environment Variable

PLCONFIG Environment Variable

PLOAD_SHMBASE Environment Variable

PLOAD_LO_PATH Environment Variable

PLOAD_SHMAT Environment Variable

Architecture of the onpload Utility

Deluxe-Mode Loads

Express-Mode Loads

Getting Started

In This Chapter

Data-Load Example

Preparing to Use ipload

Creating a File of Data

Creating a Database

The ipload Utility

Starting ipload

Choosing a Project

Checking the Defaults

Load Job Windows

Load Job Select Window

Load Job Window

Device-Array Windows

Device Array Selection Window

Device-Array Definition Window

Format Views Window

Record Formats Window

Format-Definition Window

Filter, Discard Records, and Logfile Text Boxes

Filter Text Box

Discard Records Text Box

Logfile Text Box

Map Views Window

Map Views Window

Load Record Maps Window

Map-Definition Window

Load Options Window

Active Job Window

Verifying the Data Transfer

Performing a Level-0 Backup

Generate Options

Starting the Example

Preparing the Unload-Job Window

Performing the Unload

Using the High-Performance Loader Windows

In This Chapter

Starting ipload

Using the ipload GUI

HPL Main Window

Component-Selection Windows

Component-Definition Windows

Load Job and Unload Job Windows

Selection-List Windows

Message Windows

Using the HPL Buttons

Toolbar Buttons

Using the Online Help

Using UNIX Keyboard Commands to Move the Cursor

Defining Projects

In This Chapter

Project Organization

Projects Window

Creating a New Project

Selecting a Project

Configuring the High-Performance Loader

In This Chapter

Configuring ipload

Selecting a Database Server

Using the Connect Server Window

Creating the onpload Database

Modifying the onpload Defaults

Defaults Window

Changing the onpload Defaults

Selecting a Driver

Using the Drivers Window

Modifying the Machine Description

Machines Window

Using the Machines Window

Defining Device Arrays

In This Chapter

Using Multiple Devices in a Device Array

Using the Device-Array Selection Window

Using the Device-Array Definition Window

Defining Formats

In This Chapter

Fixed-Length Records

Creating a Fixed Format

Editing a Format

Creating a Fixed Format That Uses Carriage Returns

Creating a Fixed Format That Includes BYTE or TEXT Data

Creating a Fixed Format That Includes Ext Type or Simple LO Data

Delimited Records

Creating a Delimited Format

Creating a Delimited Format That Includes BYTE or TEXT Data

Creating a Delimited Format with Extended Data Types

Creating a COBOL Format

Picture and Usage Descriptions

Modifying Fixed and COBOL Formats

Modifying Delimited-Format Options

Format Views Window

Defining Queries

In This Chapter

Creating a Query

Using the Table Button

Editing the WHERE Clause

Editing a Query

Exporting and Importing Queries

Importing a Query

Exporting a Query

Database Views Window

In This Chapter

Load and Unload Maps

Using the Map-Definition Window

Creating a Load Map

Creating an Unload Map

Unloading Data Using Functions

Mapping Options

Using Mapping Options

Setting the Mapping Options

Editing Options

Using the Delete Button

Using the Find Button

Using the Specs Button

Map Views Window

Defining Filters

In This Chapter

Creating a Filter

Editing a Filter

Filters with Code-Set Conversion (GLS)

Unloading Data from a Database

In This Chapter

Components of the Unload Job

Choosing the Database Server

Running Multiple Jobs

Unload Job Windows

Creating an Unload Job

Running the Unload Job

Specifying to Write to the End of the Tape

Using the Command-Line Information

Changing the Unload Options

Editing an Unload Job

Generate Options

Loading Data to a Database Table

In This Chapter

Components of the Load Job

Choosing the Database Server

Running Multiple Jobs

Preparing User Privileges and the Violations Table

Load Job Windows

Creating a Load Job

Running the Load Job

Specifying to Read to the End of the Tape

Using the Command-Line Information

Changing the Load Options

Editing a Load Job

Generate Options

Generate Options

In This Chapter

Types of Generate Tasks

Generating from the Load Job Window

Using the Autogenerate Load Components Window

Generating from the Unload Job Window

Using the Autogenerate Unload Components Window

Generating from the Components Menu

Generate Window

Generating Load and Unload Components

Using the No Conversion Job Option

In This Chapter

Browsing Options

Previewing Data-File Records

Reviewing Records That the Conversion Rejected

Viewing the Violations Table

Viewing the Status of a Load Job or Unload Job

Managing the High-Performance Loader

In This Chapter

How Express Mode and Deluxe Mode Work

Rejected Records from the Input File

Constraint Violations

Viewing Error Records

Configuration Parameters

Express-Mode Limitations

onstat Options for onpload

Devices for the Device Array

Performance Hints

Limitation When Using the Excalibur Text DataBlade Module Indexes

The onpload Utility

In This Chapter

Understanding the onpload Utility

onpload Filename Size Limitations on UNIX

Starting the onpload Utility

Using the onpload Utility

The onpload Utility Syntax

Setting the Run Mode with the -f Option

Typing the -f Flags

Interpreting the -d and -f Options Together

Modifying Parameter Size

Using the -i Option

Overriding the onpload Database Values

Loading Data into Collection Data Type Columns

The onpladm Utility

In This Chapter

Description of the onpladm Utility

The onpladm Utility Features

Specification-File Conventions

Modifying a Job by Using a Detailed Specification File

Describing a Job

Listing All Jobs in a Project

Defining Device Arrays

Creating a Device Array

Modifying a Device Array

Describing a Device Array

Listing Project Device Arrays

Deleting a Device Array

Describing a Map

Modifying a Map Using A Detailed Specification File

Listing All Maps in a Project

Defining Formats

Creating a Format

Modifying a Format Using a Specification File

Describing a Format

Listing all Formats in a Project

Deleting a Format

Defining Queries

Creating a Query

Modifying a Query

Describing a Query

Listing all Queries in a Project

Deleting a Query

Defining Filters

Creating a Filter

Modifying a Filter

Describing a Filter

Listing all Filters in a Project

Deleting a Filter

Defining Projects

Creating a New Project

Running All Jobs in a Project

Listing all Projects

Deleting a Project

Defining Machine Types

Creating a Machine Type

Modifying a Machine Type

Describing a Machine

Listing all Existing Machine Types

Deleting a Machine Type

Defining Database Operations

Creating a Database Project

Configuring Target-Server Attributes

Appendix A. onpload Database

Delimiters Table

FilteritemTable

Formatitem Table

Mapoption Table

Appendix B. High-Performance Loader Configuration File

Configuration Parameter Descriptions

File Conventions

HPL_DYNAMIC_LIB_PATH

Appendix C. Picture Strings

Alphanumeric Pictures

Numeric Pictures

Appendix D. Match Condition Operators and Characters

Operator Descriptions and Examples

Appendix E. Custom-Conversion Functions

Custom Conversion Example

The onpload Conversion Process

Appendix F. onstat -j Option

Using the onstat -j Option

Appendix G. HPL Log-File and Pop-Up Messages

How the Messages Are Ordered

Message Categories

Log-File Messages

Pop-Up Messages

Appendix H. Custom Drivers

Adding a Custom Driver to the onpload Utility

Adding the Driver Name to the onpload Database

Preparing the Custom-Driver Code

Rebuilding the Shared-Library File

Connecting Your Code to onpload at Runtime

Driver Initialization

Registering Driver Functions

Available Driver Methods

Available API Support Functions

pl_inherit_methods(driver, methodtable)

pl_set_method_function(methodtable, method, function)

pl_driver_inherit(method)

pl_get_recordlength()

pl_set_informix_conversion(flag)

pl_lock_globals()

pl_reset_inherit_chain(method)

Appendix I. Running Load and Unload Jobs on a Windows Computer

Using the onpladm Utility on Windows

Running the Run Job or Run Project Commands

Running onpladm on UNIX with Dynamic Server Running on Windows

Preparing Jobs for Windows with the ipload Utility

Appendix J. Conversion and Reversion Scripts for HPL Database Migration

Upgrading the High-Performance Loader onpload Database

Reverting from the Current onpload Database

Appendix K. Accessibility

Dotted Decimal Syntax Diagrams

Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]