O'Reilly logo

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Tera-Tom on Teradata Utilities V12-V13

Book Description

Teradata Utilities such as BTEQ, FastLoad, MultiLoad, TPump, and TPT can be difficult. Not any more because Tera-Tom makes these utilities simple to understand and use.

Table of Contents

  1. Cover
  2. Copyright
  3. Chapter 1 — Introduction
    1. The Teradata Utilities
    2. The Teradata Utilities (Continued)
    3. Considerations for using Block at a Time Utilities
    4. Maximum Amount of Block Utilities has changed!
    5. Considerations for using Row at a Time Utilities
    6. Fast Path Inserts inside the Teradata Database
    7. Fast Path DELETE inside the Teradata Database
    8. Freespace Percent and Loading Tables
    9. Referential Integrity and Load Utility Problems
    10. V13 - No Primary Index Tables
    11. NoPI CREATE Statement
    12. NoPI Row-ID Increments the Uniqueness Value
    13. NoPI Row-Hash Different on each AMP
    14. NoPI Options and Facts
    15. NoPI Restrictions
  4. Chapter 2 — BTEQ.
    1. Logging onto BTEQ Interactively
    2. Logging onto BTEQ in a Script
    3. Using BTEQ to submit queries in Interactive Mode
    4. The Brilliant BTEQ WITH BY Statement
    5. BTEQ can provide Grand Totals
    6. The Four Types of BTEQ Exports
    7. A BTEQ Export Script
    8. A BTEQ Export Script in REPORT Mode
    9. Output for Record Mode and Report Mode
    10. Using Report Mode to Export a CSV File
    11. Importing from a CSV File
    12. Two Ways to run a BTEQ Script
    13. Exporting large files in a UNIX MP-RAS System
    14. BTEQ IMPORT Script
    15. Importing a Comma Separated CSV File
    16. Multiple Sessions in BTEQ
    17. Fast Path Inserts Using BTEQ
    18. Cool commands in BTEQ - Sidetitles
    19. Using BTEQ Conditional Logic with ERRORCODE
    20. BTEQ Commands
    21. Sequence Control Commands
    22. Format Control Commands
  5. Chapter 3 — FastLoad
    1. Maximum Amount of Block Utilities has changed!
    2. FastLoad has Two Phases
    3. Acquisition Phase 1
    4. FastLoad Application Phase 2
    5. A Sample FastLoad Script
    6. Referential Integrity and Load Utility Problems
    7. Two ways to execute a FastLoad Script
    8. Building, Executing or Scheduling FastLoad with Nexus
    9. Building a FastLoad with Nexus SmartScript
    10. The SmartScript FastLoad Builder
    11. Executing FastLoad from the Nexus Chameleon
    12. Output Report from FastLoad
    13. Recovering FastLoad When it Fails
    14. Valid Data Types used in FastLoad
    15. FastLoad Commands
  6. Chapter 4 — MultiLoad
    1. Maximum Amount of Block Utilities has changed!
    2. The Five Phases of MultiLoad
    3. A Sample MultiLoad Script
    4. Referential Integrity and MultiLoad Problems
    5. Supported Input Formats
    6. A MultiLoad That INSERTS and UPDATES using
    7. Two Different Input Files
    8. A MultiLoad That INSERTS and UPDATES using
    9. Two Different Input Files Continued
    10. A MultiLoad That UPSERTS.
    11. A MultiLoad That UPSERTS Continued
    12. A MultiLoad That Deletes (Step 1 of 3)
    13. A MultiLoad That Deletes (Step 2 of 3)
    14. A MultiLoad That Deletes (Step 3 of 3)
    15. MultiLoad IMPORTS won’t work with NOPI Tables
    16. Two Easy Ways to Run a MultiLoad
    17. Building, Executing or Scheduling MultiLoad with Nexus
    18. Building a MultiLoad with Nexus SmartScript
    19. The SmartScript MultiLoad Builder
    20. Executing your MultiLoad Script
    21. The Output Report from MultiLoad
    22. Utility Locks
    23. Trouble Shooting and Restarting MultiLoad
  7. Chapter 5 — TPump.
    1. Limitations of TPump
    2. A Sample TPump Script
    3. Two Easy Ways to Run a TPump
    4. Building, Executing or Scheduling TPump with Nexus
    5. Building a TPump with Nexus SmartScript
    6. The SmartScript TPump Builder
    7. Executing your TPump Script
    8. Supported Input Formats
    9. TPump Script with Error Treatment Options
    10. A TPump Script that Uses Two Input Data Files
    11. A TPump UPSERT Sample Script
    12. Fundamentals of the .BEGIN Statement
    13. PACK
    14. RATE
    15. SERIALIZE
    16. TPump Commands and Parameters
    17. .BEGIN LOAD Parameters UNIQUE to TPump
    18. Monitoring TPump
    19. Handling Errors in TPump Using the Error Table
    20. Common Error Codes and What They Mean
    21. Restarting TPump
    22. TPump and MultiLoad Comparison Chart
  8. Chapter 6 — FastExport
    1. Maximum Amount of Block Utilities has changed!
    2. How FastExport Works
    3. FastExport Supported Operating Systems
    4. FastExport
    5. FastExport Enhancement – No Spool
    6. A FastExport in its Simplest Form
    7. FastExport Script that joins two tables
    8. FastExport Modes and Formats
    9. How Indicators can hurt your FastLoad
    10. How you can omit Indicators in your FastExport
    11. CREATE A FastLoad with INDICATORS
    12. A FastExport Script using Binary Mode
    13. FastExport Support and Task Commands
    14. Task Commands
    15. FastExport Supported SQL Commands
  9. Chapter 7 — Teradata Parallel Transport (TPT).
    1. The TPT Data Stream Flow
    2. TPT Operators
    3. Read from Multiple Source Files Simultaneously
    4. TPT Operators and their Functions
    5. TPT Operator Types
    6. TPT Operators and their Equivalent Load Utility
    7. TPT Operators and their Purpose in Life
    8. How to Run a TPT Script
    9. A Sample BTEQ Script for Comparison
    10. A TPT Script for the DDL Operator
    11. Script Sections
    12. Schemas
    13. Define Statement in the Declarative Section
    14. Processing Statements in the Executable Section
    15. Six Syntax Rules when Creating TPT Scripts
    16. Build that Job Header and Job Name
    17. Build that Schema
    18. Build that Multiple Schema
    19. Build that Producer Operator
    20. Build that Consumer Operator
    21. Build that APPLY Statement
    22. Build that Complex APPLY Statement
    23. Load Operator and Attributes
    24. Loading a Table from a Flat File
    25. Loading a Table from a Flat File Continued
    26. Export Operator SELECT Restrictions
    27. Export Attributes
    28. Export a Table to a Delimited Flat File
    29. Export a Table to a Delimited Flat File Continued
    30. Export a Table to a Binary Flat File
    31. Export a Table to a Binary Flat File Continued
    32. Loading to the Employee Table
    33. Loading to the Employee Table Continued
    34. The UPDATE Operator
    35. Script Example of the UPDATE Operator
    36. The STREAM Operator
    37. Build that Basic DELETE as a Standalone
    38. Build that Complex DELETE as a Standalone
    39. Build that Complex DELETE as a Consumer Task
    40. Moving LOB Data through the SQL INSERTER
    41. TPT Wizard
    42. TPT Utility Commands
    43. tbuild Commands
    44. tlogview Commands
    45. V13 - Expanded SQL in the DDL Operator
    46. V13 - To Drop or Not to Drop
    47. V13 - EXTRA ROWS Option for STREAM
    48. V13 - TPT now supports BLOBS and CLOBS
    49. V13 - PERIOD Data Type API Support
    50. V13 - Temporal Tables and TPT/API Constraints
    51. V13 - Tbuild – h Option
    52. V13 - Operator Type Validation
  10. Chapter 8 — INMOD Processing
    1. What is an INMOD
    2. Calling an INMOD from FastLoad
    3. Writing an INMOD
    4. Writing an INMOD for FastLoad
    5. Writing for MultiLoad, Tpump, and FastExport
    6. Migrating an INMOD
    7. Writing a NOTIFY Routine
    8. Sample INMOD
  11. Chapter 9 — OUTMOD Processing.
    1. What is of an OUTMOD
    2. How an OUTMOD Works
    3. Calling an OUTMOD from FastExport
    4. Writing an OUTMOD
    5. Writing a NOTIFY Routine
    6. Sample OUTMOD
  12. Chapter 10 — Support Environment.
    1. The Support Environment Commands
    2. Required Operational Command List
    3. Using a Variable in a Script
    4. The Support Environment System Variables
    5. Support Environment Example
  13. APPENDIX A: Mainframe Load Utility Examples.
    1. BTEQ MAINFRAME EXPORT EXAMPLE – JCL
    2. BTEQ MAINFRAME EXPORT SCRIPT EXAMPLE – DATA MODE
    3. BTEQ MAINFRAME IMPORT EXAMPLE – JCL
    4. BTEQ MAINFRAME IMPORT SCRIPT EXAMPLE – DATA MODE
    5. FASTEXPORT MAINFRAME EXAMPLE – JCL
    6. FASTEXPORT MAINFRAME SCRIPT EXAMPLE-RECORD MODE
    7. FASTLOAD MAINFRAME EXAMPLE – JCL
    8. FASTLOAD MAINFRAME SCRIPT EXAMPLE – TEXT MODE
    9. MULTILOAD MAINFRAME EXAMPLE – JCL
    10. MULTILOAD MAINFRAME SCRIPT EXAMPLE – TEXT MODE
    11. MULTILOAD MAINFRAME SCRIPT EXAMPLE – CONTINUED
    12. TPUMP MAINFRAME EXAMPLE – JCL
    13. TPUMP MAINFRAME SCRIPT EXAMPLE – TEXT
    14. Index of Contents