The Update Operator Function in a Teradata PT Job Script - Parallel Transporter

Teradata Parallel Transporter Reference

Product
Parallel Transporter
Release Number
15.00
Language
English (United States)
Last Update
2018-09-27
dita:id
B035-2436
lifecycle
previous
Product Category
Teradata Tools and Utilities

The Update Operator Function in a Teradata PT Job Script

When you use the Update operator in a Teradata PT job, each parallel instance of the Update operator:

1 Log on to the Teradata Database, using your user name, password, Teradata Database, and account ID information specified in the job script.

2 Loads the data from the Teradata PT data streams into the Teradata Database.

3 Logs off from the Teradata Database.

4 If the Update operator job is successful, terminates the job and provides information about the job in the log or to the user, such as:

  • Total number of records sent to the Teradata Database
  • Number of errors posted to the error tables
  • Number of Inserts, Updates, and Deletes applied
  • A status code indicating the success of the job
  • 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.