15.00 - Teradata Parallel Transporter Reference - Parallel Transporter

Product: Parallel Transporter
Release Number: 15.00
Language: English (United States)
Last Update: 2018-09-27

Preface
Audience
Supported Releases
Prerequisites
Changes to This Book
Additional Information
Product Safety Information
Chapter 1 Teradata PT Utility Commands
Command Syntax
Chapter 2 Object Definitions and the APPLY Statement
Object Definition Statements
Syntax for Attribute Declarations
Syntax
Job Types
Example: Job with Single APPLY Statement
Job Steps
Example: Job Steps
Syntax
Usage Notes
Examples of DEFINE SCHEMA Statements
Syntax
DEFINE OPERATOR Statement: Definition
Syntax
Chapter 3 DataConnector Operator
DataConnector Operator Capabilities
Syntax
Required Specifications
Required and Optional Attributes
Usage Notes
Format
OpenMode
TextDelimiter and EscapeTextDelimiter
Rules for Quoted Delimited Data Handling
Processing Hadoop Files and Tables
Operational Considerations
z/OS Considerations
End of Record Markers for Text Formatted Data
Considerations when Processing Hadoop Files and Tables
DataConnector Operator Events
Chapter 4 DDL Operator
DDL Operator Capabilities
The DDL Operator Function in a Teradata PT Job
Syntax
Required Specifications
Required and Optional Attributes
Usage Notes
Specifying DDL Statements in the Teradata PT APPLY Statement
Grouping SQL Statements in the Teradata PT APPLY Statement
Restrictions and Limitations
Operational Considerations
Chapter 5 Export Operator
Export Operator Capabilities
The Export Operator Function in a Teradata PT Job
FastExport Utility and the Export Operator
Syntax
Required and Optional Attributes
Usage Notes
NoSpool Mode
Restrictions and Limitations
Job Options
Limiting Output
Checkpointing and Restarting
Using the Large Decimal Teradata Database Feature
Operational Considerations
Sessions and Instances
Multiple Databases
Exporting VARBYTE Data
Chapter 6 FastExport OUTMOD Adapter Operator
FastExport OUTMOD Adapter Operator Capabilities
Syntax
Required Specifications
Required and Optional Attributes
Usage Notes
Job Options
Operational Considerations
Chapter 7 FastLoad INMOD Adapter Operator
FastLoad INMOD Adapter Operator Capabilities
Syntax
Required Specifications
Required and Optional Attributes
Usage Notes
Job Options
Operational Considerations
Chapter 8 Load Operator
Load Operator Capabilities
Load Operator Interface
The Load Operator Function in a Teradata PT Job
Load Operation Phases
FastLoad Utility and the Load Operator
Syntax
Required Specifications
Required and Optional Attributes
Usage Notes
ErrorTable1
ErrorTable2
Auto-Generation of Error Tables
Normalized Tables
Restrictions and Limitations
Job Options
ErrorLimit
Staged Loading
Operational Considerations
Space Requirements
Sessions and Instances
Limits on Load Jobs
Checkpointing and Restarting
Load Operator as Standalone Operator
Chapter 9 MultiLoad INMOD Adapter Operator
MultiLoad INMOD Adapter Operator Capabilities
Syntax
Required Specifications
Required and Optional Attributes
Usage Notes
Input Record Format
Chapter 10 ODBC Operator
ODBC Operator Capabilities
The ODBC Operator Function in a Teradata PT Job
Syntax
Required Specifications
Required and Optional Attributes
Usage Notes
DataBlockSize
Job Options
Using ODBC Operator with Oracle DATE Fields
Configuring ODBC Initialization Files
Using the ODBC Operator on HP-UX
Using the ODBC Operator on IBM z/OS
Support for NUMBER Data Type
Operational Considerations
TD Wallet
Chapter 11 OS Command Operator
OS Command Operator Capabilities
The OS Command Operator Function in a Teradata PT Job
Syntax
Required Specifications
Required and Optional Attributes
Usage Notes
Chapter 12 Schema Mapping Operator
Schema Mapping Operator Capabilities
Syntax
Required Specifications
Optional Attributes
Attribute Relationships
Schema Mapping Output Examples
DumpFieldsWithTrans
DumpRecordsNoTrans
DumpRecordsWithTrans
FormatFields
Chapter 13 SQL Inserter Operator
SQL Inserter Operator Capabilities
The SQL Inserter Operator Function in a Teradata Job Script
SQL Inserter Operator and the Load Operator
Syntax
Required Specifications
Required and Optional Attributes
Job Options
Data Integrity
Data Loading
Operational Considerations
Restrictions and Limitations
Chapter 14 SQL Selector Operator
SQL Selector Operator Capabilities
SQL Selector Operator and the Export Operator Compared
Defining an SQL Selector Operator in a Teradata PT Script
Syntax
Required Specifications
Required and Optional Attributes
Usage Notes
LOB Loading Attributes
Restrictions and Limitations
Job Options
Operational Considerations
Chapter 15 Stream Operator
Stream Operator Capabilities
The Stream Operator Function in a Teradata PT Script
TPump Utility and the Stream Operator
Syntax
Required Specifications
Required and Optional Attributes
Usage Notes
ErrorTable
DML Statement
Restrictions and Limitations
Job Options
Robust and Non-Robust Mode
Recovery Logic and Overhead
Data Quality Affects Performance
Statement Packing
Array Support
Latency Interval
MacroCharSet
Operational Considerations
Space Requirements
Sessions and Instances
Checkpointing and Restarting
Dropped Tables
DML Option Categories
Temporal Tables
Chapter 16 Update Operator
Update Operator Capabilities
Update Operator as Standalone Operator
The Update Operator Function in a Teradata PT Job Script
Functional Description of the Update Operator
Update Phases
MultiLoad Utility and the Update Operator
Syntax
Required Specifications
Required and Optional Attributes
Usage Notes
TargetTable
ErrorTable
WorkTable
Auto-Generation of Error and Work Tables
Extended MultiLoad Protocol
Normalized Tables
Restrictions and Limitations
Job Options
Upserts
AMP Usage
VARCHAR ARRAY Tables
Operational Considerations
Sessions and Instances
Limits on Update Jobs
Delete Task Option
Using Delete Task
Why Choose the Delete Task Option?
Example 1: Delete Task Option
Example 2: Delete Task Option
Chapter 17 Notify Exit Routines
Notify Exit Routines
Export Operator Events
Load Operator Events
Update Operator Events
Stream Operator Events
DataConnector Operator Events
Using Notify Exit Routines to Monitor Events
Interface
Samples
Compiling and Linking Notify Exit Routines
UNIX Systems
Windows Platforms
Chapter 18 Advanced Teradata Database Considerations
Query Banding Considerations
Large Objects
Defining LOB Data in a Teradata PT Schema
Inline Method
Deferred Method
Moving LOB Data from one Teradata Database Table to Another
Loading LOB Data into a Teradata Database Table from External Data Files
Extracting LOB Data from Teradata Database Tables and Writing LOB Data to an External Target
User Considerations
Limitations on LOB Processing
JavaScript Object Notation
Data Conversions
Supporting User-Defined-Types and User-Defined-Methods
User-Defined-Types (UDTs)
User-Defined-Methods (UDMs)
Creating UDTs with Teradata PT
Inserting and Retrieving UDTs with Client Products
Inserting UDTs with Teradata PT
Retrieving UDTs with Teradata PT
Retrieving UDT Metadata with Teradata PT
Supporting User-Defined-Functions and External-Stored-Procedures
User-Defined-Functions (UDFs)
External-Stored-Procedures (XSPs)
Creating UDFs with Teradata PT
Chapter 19 Extended Character Sets
Teradata PT-Supported Character Sets
Network-Attached Character Sets
Mainframe-Attached Character Sets
Using Extended Character Sets
Character Set Hierarchy
Specifying an Extended Character Set in a Teradata PT Job Script
Extended Session Character Set Data
Specifying Unicode in the tbuild Command
Options for Specifying UTF-8 and UTF-16 in a Job Script
Using LONG VARCHAR with Unicode Character Sets
Appendix A How to Read Syntax Diagrams
Syntax Diagram Conventions
Paths
Required Entries
Optional Entries
Strings
Abbreviations
Loops
Excerpts
Multiple Legitimate Phrases
Sample Syntax Diagram
Diagram Identifier
Appendix B Deprecated Syntax
Appendix C Restricted Words
Appendix D Teradata PT Publications
Teradata PT Publications
Glossary

Back to home page