How to Set Block Insert Size Parameters in Teradata

Question

I am using odbc insert command in the statistics package Stata (v14.2) on an Ubuntu 14.04.2 LTS server to insert some data into a Teradata DB (v14.10).

This Stata command has a block option, which makes Stata send the data in blocks of 1000 rows. Unfortunately the ODBC driver appears to be doing single-row inserts (according to the DBA who monitors the system).

Is it possible to alter the ODBC driver behavior?

If so, how does one specify the block size for the ODBC driver to use in the .odbc.ini file or a connection string?

I've looked the TD ODBC manual and Googled, but I could not find anything useful.

Impropriate

Teradata's ODBC driver supports parameter arrays (info.teradata.com/htmlpubs/db_ttu_14_00/index.html#page/…), don't know if Stata can utilize it. – Baseman

@Baseman Do you know what I would need to alter in .odbc.ini or in the connection string? – Impropriate

No, sorry. I assume this would be a setting in Stata because the client needs to provide those arrays. – Baseman

for python library there is batch=true Parametr github.com/Teradata/PyTd/issues/4 check if it helps – Perryperryman

Did you ever figure this out? – Albanian

@PearlySpencer Unfortunately not. – Impropriate

Is this a Stata issue or a more general ODBC driver problem? – Albanian

I am not sure. I don't think remember if I tried other software with ODBC. I no longer work with Teradata, so I don't even have a way of testing this. – Impropriate