TPT Inserter Operator

[Cvinodh]

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]

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.

[RT127583]

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]

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]

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.

[RT127583]

Thanks Steve.