TPT Inserter Operator

Tools

TPT Inserter Operator

Hi,

Does TPT SQL Inserter operator supports error limit attribute?. Looking at the manual it seems it doesn't. But Stream operator does seems to support it. currently we are looking for alternatives to Load operator for low volume imports but our alternative solution must support error limit and skip row features.

Thanks,

Charles

Tags (2)
5 REPLIES
Teradata Employee

Re: TPT Inserter Operator

The Inserter does not support error limit.

The Skip Rows feature is for the DataConnector operator, not the Inserter.

So, that will be supported no matter which loading operator you use.

-- SteveF

Re: TPT Inserter Operator

Does TPT INSERTER (TPT 14.10) supports PACK like BTEQ does?  I did not find it in the User Reference.  However we all know TPT INSERT is like BTEQ IMPORT.

Thanks,

Randy Tsai

Re: TPT Inserter Operator

Just clarify my question.  We have a job using TPT INSERTER (actually version 14.0.0.8, Database version is 14.10) to load only 200+ rows and it took almost 2 hours.  After analysis, it was because the job was treated like Single Row Inserts (DBQL track every row inserted as a standalone entry).  While during peak hours, TASM put every single row into workload delay that caused the long elapsed time.

We are trying to find out why it was treated as Single Row Insert.  At the meantime we suggest the user use "PACK" parameter but could not find the syntax.  Is it not supported in TPT INSERTER or not at this version?

Thanks,

Randy

Teradata Employee

Re: TPT Inserter Operator

The TPT Inserter operator does not support PACK and there are no plans to add that feature.

Please use the Stream operator for that type of functionality.

-- SteveF

Re: TPT Inserter Operator

Thanks Steve.