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

Teradata Parallel Transporter Reference

Product
Parallel Transporter
Release Number
16.10
Published
July 2017
Language
English (United States)
Last Update
2018-06-28
dita:mapPath
egk1499705348414.ditamap
dita:ditavalPath
Audience_PDF_include.ditaval
dita:id
B035-2436
lifecycle
previous
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 Teradata Database, using your user name, password, Teradata Database, 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 from the session with the Teradata Database.
  4. If the SQL Inserter operator job is successful, terminate the job and report the total number of records successfully sent to the Teradata 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.