The SQL Inserter Operator Function in a Teradata Job Script - Parallel Transporter

Teradata® Parallel Transporter Reference

Product
Parallel Transporter
Release Number
17.10
Published
February 2022
Language
English (United States)
Last Update
2023-11-29
dita:mapPath
abr1608578396711.ditamap
dita:ditavalPath
obe1474387269547.ditaval
dita:id
ogv1478610452101
Product Category
Teradata Tools and Utilities

When you use the SQL Inserter operator in a Teradata PT job, it does the following:

  1. Log on to the database, using your user name, password, database name, and account ID information specified in the job script.
  2. Load the data from the Teradata PT data stream into a target table specified in the SQL INSERT statement defined in the Teradata PT APPLY statement.

    Only one INSERT statement is allowed to be specified in the APPLY statement. If more than one INSERT statement is found in the APPLY statement, the SQL Inserter operator will issue an error message to both console and private logs and terminate the job.

  3. Log off the database.
  4. If the SQL Inserter operator job is successful, terminate the job and report the total number of records successfully sent to the database.
  5. If the job is unsuccessful, terminate the job and provide information about the job so that you can correct any problem and restart the job.