15.00 - Teradata MultiLoad Reference - MultiLoad

prodname: MultiLoad
vrm_release: 15.00
category: Programming Reference
featnum: B035-2409-034K

Preface
Audience
Supported Releases
Prerequisites
Changes to This Book
Additional Information
Product Safety Information
Chapter 1 Overview
Teradata MultiLoad Utility
Description
What it Does
How it Works
Operating Features and Capabilities
Operating Modes
Character Sets
Task Status Reporting
Data Conversion Capabilities
Checkpoints
Teradata MultiLoad Commands
Teradata MultiLoad Command Input
Teradata MultiLoad Support Activity Commands
Teradata MultiLoad Task Activity Commands
Teradata SQL Statements
A Teradata MultiLoad Example
Dropping the Employee Table
Creating the Source Data File
Writing the Teradata MultiLoad Job Script
Running the Teradata MultiLoad Job
Verifying the Import Task
Other Alternatives
Chapter 2 Using Teradata MultiLoad
Invoking Teradata MultiLoad
File Requirements
Interactive Mode
Batch Mode
Run-time Parameters
z/OS Example
UNIX and Windows Systems Examples
Terminating Teradata MultiLoad
Normal Termination
Abort Termination
After Terminating a Teradata MultiLoad Job
Reinitializing After Terminating a Teradata MultiLoad Job
Implications of Dropping Required Teradata MultiLoad-Created Tables
Restarting a Paused Teradata MultiLoad Job
After Using the PAUSE ACQUISITION Command
After a Teradata MultiLoad Job Script Error
After an Unrecoverable I/O Error
After a Down AMP is Recovered
After a Teradata Database Restart
After a Teradata Database System Reconfiguration
After a Job Abort or Client System Failure
Programming Considerations
Teradata MultiLoad Configuration File
Teradata MultiLoad Command Conventions
Data Conversion Factors
Variables
ANSI/SQL DateTime Specifications
Comments
Character Set Specification
Graphic Data Types
Graphic Constants
Import Tasks
Delete Tasks
Dealing with AMPS
Using Locks
Restrictions and Limitations
Termination Return Codes
UNIX Signals
Using INMOD and Notify Exit Routines
Overview
Programming Considerations for Using Routines
Programming Structure
Teradata MultiLoad/INMOD Routine Interface
Teradata MultiLoad/Notify Exit Routine Interface
Rules and Restrictions for Routines
Writing a Teradata MultiLoad Job Script
Definition
Procedure
Estimating Space Requirements
Definition
Procedure
Preparing the Preliminary Estimate
Adjusting the Preliminary Estimate
Computing the Restart Log Table Requirements
Handling Teradata MultiLoad Errors
Error Recording
Acquisition Error Table
Application Error Table
Determining the Cause of Errors
Monitoring Teradata MultiLoad Performance
Performance Considerations
Troubleshooting Performance Problems
Handling RDBMS Retryable and Restartable Error Codes
MultiLoad TMSM Integration
Chapter 3 Teradata MultiLoad Commands
Syntax Notes
Object Name Restrictions
LOB Data Restrictions
Geospatial Data Restrictions
Upsert Example
Chapter 4 Troubleshooting
Compiler Versions
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 Invocation Examples
z/OS
Using the Reduced Print Output (BRIEF) Parameter
Using the Character Set Selection (CHARSET) Parameter
Using the Error Logging (ERRLOG) Parameter
Specifying Multiple Parameters
UNIX OS and Windows
Using the Reduced Print Output (-b) Parameter
Using the Character Set (-c) Selection Parameter
Using the Error Logging (-e) Parameter
Using the Runfile (-r) Parameter
Specifying Multiple Parameters
Appendix C INMOD and Notify Exit Routine Examples
z/OS
C INMOD Example
COBOL INMOD Example
COBOL Pass Thru INMOD Example
PL/I INMOD Example
UNIX OS
C Notify Exit Parameters
#endif /* MLDNFYXT_H */Compiling and Linking Routines
Windows
Generating Routines
Sample INMOD Routine
Sample Notify Exit Routine
Appendix D Teradata MultiLoad Job Script Examples
Import Task
Delete Task
Upsert Task
DDL for PERSONNEL Database Tables
Appendix E User-Defined Types and User-Defined Methods
User-Defined Types and User-Defined Methods
User-Defined-Methods (UDMs)
Creating UDTs with Teradata MultiLoad
Inserting and Retrieving UDTs with Client Products
External Types
Inserting UDTs with Teradata MultiLoad
Retrieving UDTs with Teradata MultiLoad
Retrieving UDT Metadata with Teradata MultiLoad
Appendix F .DEBUG TRACE Command
Purpose
.DEBUG TRACE IO [LOW|MEDIUM|HIGH];
.DEBUG TRACE MEMORY;
.DEBUG TRACE ALL;
Glossary

Back to home page