Tags for operator
Calling BTEQ with file within PowerShell
Hi, Currently, I execute BTEQ scripts via a generated .Bat file with each script having a call to BTEQ similar to below: bteq <Bteq\"File_1.btq" >> bteq_output.txt 2>&1
bteq powershell cmd operator <
Sum Of Squares Operator
What is the Teradata operator equivalent for Excels SUMSQ (Sum of Squares)? Thanks
operator
Problem using RowErrFileName
Hi, I've been trying to implent a TPT using the feature RowErrFileName but it does't seems to work, when I load a Input File with some errors like incomplete columns it doesn't send the bad rows to the 'RowErrFileName' instead of this the TPT goes to FatalError and crashes. Any Help? This is how I am writing the TPT DataConnector Operator DEFINE OPERATOR CONECTOR_PRODUCER DESCRIPTION 'DataConnector' TYPE DATACONNECTOR PRODUCER SCHEMA PnrItineraries_SCHEMA ATTRIBUTES ( VARCHAR PrivateLogName = 'dataconector_log' ,
tpt operator dataconnector rowerrfilename
Who can explain TPT instance count and its details
In TPT apply clause, you can specify number of instances used for each operator. For example APPLY ('INSERT INTO TARGET TABLE (COL1, COL2) VALUES (:COL1, :COL2);') IGNORE DUPLICATE ROWS TO OPERATOR ( LOAD_OPERATOR[2]) SELECT * FROM OPERATOR(READ_OPERATOR[3]); In this sample, my load_operator is a update operator, while read_operator is DATACONNECTOR PRODUCER hook up to a single file. specifying the instance on the loader and reader makes me wondering what will happen in reality:
tpt operator instance count
Accessing DB2 Using the TPT ODBC operator on z/OS
On z/OS, the ODBC operator can be used to extract data from DB2.  The purpose of this article is to demystify the use of the ODBC operator in conjunction with DB2 on IBM’s z/OS operating system.  
tpt db2 odbc operator z/os v_tools
Teradata Parallel Transporter User Guide 13.10
This book provides information on how to use Teradata Parallel Transporter (Teradata PT), an object-oriented client application that provides scalable, high-speed, parallel data extraction, loading, and updating. These capabilities can be extended with customizations or third-party products.
load etl tpt fastload multiload teradata parallel transporter fastexport tpump operator directory scan extract tpt-api transform v_tools
Teradata Parallel Transporter API Programmer Guide 13.10
This book provides information on how to use the Teradata Parallel Transporter (Teradata PT) Application Programming Interface. There are instructions on how to set up the interface, adding checkpoint and restart, error reporting, and code examples.
load etl tpt teradata fastload multiload fastexport tpump operator directory scan extract parallel tpt-api transform transporter v_tools
Teradata Parallel Transporter Reference 13.10
This book provides reference information about the components of Teradata Parallel Transporter (Teradata PT), an object-oriented client application that provides scalable, high-speed, parallel data extraction, loading, and updating. These capabilities can be extended with customizations or with third-party products.
load etl tpt teradata fastload multiload fastexport tpump operator directory scan extract parallel tpt-api transform transporter v_tools
Teradata Parallel Transporter Reference 13.0
This book provides reference information about the components of Teradata Parallel Transporter (Teradata PT), an object-oriented client application that provides scalable, high-speed, parallel data extraction, loading, and updating. These capabilities can be extended with customizations or with third-party products.
load etl tpt teradata fastload multiload fastexport tpump operator directory scan extract parallel tpt-api transform transporter
Introduction to the Teradata Parallel Transporter Operators
The Teradata Parallel Transporter (Teradata PT) operators play a vital role in high-speed data extraction and loading geared towards the Teradata Database. Besides interfacing with the Teradata Database, some of the Teradata PT operators provide access to external sources such as files, ODBC-compliant DBMS, and message-oriented middleware.
data load tpt teradata parallel transporter teradata pt operator data extraction v_tools