About the TPT Editor - Teradata Studio

Teradata Studio IDE Plug-in User Guide

Product
Teradata Studio
Release Number
15.12
Published
August 2016
Language
English (United States)
Last Update
2018-05-03
dita:mapPath
pts1468860020550.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2043
lifecycle
previous
Product Category
Teradata Tools and Utilities

The TPT Editor enables you to develop and manage scripts for Teradata Parallel Transporter (TPT). TPT is an object-oriented client application that provides scalable, high-speed, parallel data operations such as Extraction, Loading and Update for Teradata Database. TPT provides a scripting language similar to SQL in which you can specify the appropriate operators to read/load/update data from/into Teradata Database.

Using the TPT Editor you can create and edit TPT scripts, perform syntax checking, find and resolve errors, and save and organize your script files.


Open New TPT Editor
Click this button to open additional editing tabs to script and edit job variable files.
Project Navigator
You can create new .tpt and .jvf files using the menu and toolbar options of the Navigator. To open existing .tpt and .jvf files, double-click a file shown in the expandable navigation tree. The file opens in the Script Editor pane.
TPT Editor Tab
By default the TPT Editor opens one TPT script editing tab when you launch the editor. Use the Open New TPT Editor button to open additional tabs in which to script or edit files.
Outline Pane
Use the Outline view to review the attributes of an open script and quickly move to a different section of the script. Select an item from the Outline to jump to that location in the script.
Script Editor Pane
The TPT Editor supports opening and editing a single script multiple job variable file and single job variable file multiple scripts. Job variable (JVF) files are automatically created after you import a script into the TPT Editor. Be sure to create logical groups for script and job variable files in a single TPT Editor tab for accomplishing a particular job.
You can format a script by selecting text and right-clicking to select indentation, alignment, and other options. Content Assist helps you to look up next keywords, and syntax coloring and error markers assist in scripting, code validation, and debugging.
Markers Tab
The Markers view shows a list of marked errors.
Problems Tab
The Problems view shows a list of syntax errors. You can double-click an item in the view to show line and highlight the keyword in the Script Editor pane.