Document Outline

• HP Neoview Transporter User Guide
• Table of Contents
• About This Document
  • Intended Audience
  • New and Changed Information in This Edition
  • Related Documentation
    • Neoview Customer Library
  • HP Encourages Your Comments
  • General Syntax Notation
  • Publishing History
• 1 Overview
  • Network Changes for the Neoview Platform
  • Load and Extract Operations
  • The Transporter Control File
  • Client Components
• 2 Transporter Configuration
  • Client Directory Structure
  • Security Parameters Saved
  • The Transporter API
• 3 Functions and Features
  • Enhanced Initial Load (EIL)
    • Control File Options for EIL
    • Error Logging
      • EIL Exception Tables
      • Error Threshold With EIL
    • Restrictions for EIL
  • Staging Tables
  • Parallel Streams
  • Parallel Query Extract
  • Prehashing
  • JMS Trickle Feed For Data Loads
  • Transporter Job Statistics on the Neoview Platform
  • Reflexive Update
    • Reflexive Update Considerations
  • Updates Using Constant, NULL, or Expression
  • Identity Columns
  • Data Compression
  • Multi-session Side-tree Inserts
  • Using Virtual Partitions for Load and Extract
• 4 Security
  • Password Encryption
  • Encryption Files
  • Installing the Encryption Utility
  • The Encryption Utility — nvtencrsrv
    • Sample Commands for the nvtencrsrv Utility
• 5 Control File Organization and Syntax
  • Creating a Control File
  • Control File Limits
  • Control File Organization and Syntax
    • Version
    • Options
    • Typeformats
    • Dataformats
    • Maps
    • Sources
    • Jobs
    • Comments
    • Include
  • Supported Data Types
• 6 Control File Options
  • autotran
  • baddatafile
  • commitsize
  • compression
  • crossoveryear
  • datasource
  • deleteonerror
  • discards
  • enabletriggers
  • encoding
    • Encoding For A Load Job
    • Encoding For An Extract Job
    • Changing Default Encoding Behavior Using Transporter Properties
  • endpart
  • endseq
  • errors
  • exceptiontable
  • faileddatafile
  • forcestaging
  • inlinesort
  • loadid
  • multipart
  • noaudit
  • nullstring
  • operation
  • parallel
  • parallelstreams
  • password
  • retries
  • rowsetsize
  • sorted
  • startpart
  • startseq
  • system
  • taskrowsetsize
  • teamsize
  • tenacity
  • timeout
  • truncate
  • url
  • user
• 7 Load and Extract Operations
  • Steps for Performing Load and Extract Operations
  • Starting the Transporter Client
    • Starting the Client on UNIX-type Systems
    • Starting the Client on Windows Systems
    • Displaying the Installed Version of Transporter
  • Stopping the Client
  • The Transporter Job
  • Sources and Targets
  • Parallel Streams
    • Parallel Streams for Load Jobs
    • Parallel Streams for Extract Jobs
  • Transaction Modes for Load Jobs
  • Loading Data With JMS Trickle Feed
    • Requirements
  • Parallel Processing for Load Operations
  • Considerations for Extract Jobs
  • Considerations for Update Operations
  • Considerations for Upsert Operations
  • Considerations for Delete Operations
• 8 Data Processing
  • Data For Load Operations
  • Processing Data for Load Operations
    • Delimited Data for Load Operations
    • Fixed—Width Data for Load Operations
  • Delimited Data
    • Field Delimiter Character
    • Record Separator Character
    • Quote Processing For Load Operations
    • Quote Processing For Extract Operations
  • Considerations for Character Data
• 9 Troubleshooting
  • Logs
    • Log Files on the Client
    • Setting Up a Custom Log File Location
    • Logging to the Console
    • The EMS Log
  • Job Recovery
    • Considerations for Job Recovery
    • The -recover Command Line Option
  • Job Statistics on the Neoview Platform
    • Control File Metadata Tables
    • Using Transporter Metadata Tables
• A Control File Examples
• B Enhanced Initial Load Control File Examples
  • Examples
• C Control File Editor and Control File Generator
  • Control File Editor
    • Features
    • Restrictions
    • Packaging
    • Using the Control File Editor
      • Creating a New Control File
      • Opening an Existing Control File
      • Adding Content to a Control File
      • Saving a Control File to a Local System
      • Checking the Syntax of a Control File
      • Validating a Control File
      • Setting the Default Folder
      • Switching Views in the Control File Editor
      • Including Another Control File
  • Control File Generator
    • Required Arguments
    • Optional Arguments
      • Restrictions for Delimited Table Names
    • Error Message and Behavior
    • Packaging
• D Global Options Table
• E Reserved Keywords
  • Transporter Reserved Keywords
• F Transporter Exit Codes
• Glossary
• Index