All Forums Tools
Cvinodh 32 posts Joined 10/11
29 May 2015
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

feinholz 1234 posts Joined 05/08
01 Jun 2015

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

RT127583 3 posts Joined 02/12
30 Dec 2015

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

RT127583 3 posts Joined 02/12
30 Dec 2015

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

feinholz 1234 posts Joined 05/08
04 Jan 2016

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

RT127583 3 posts Joined 02/12
04 Jan 2016

Thanks Steve.

You must sign in to leave a comment.