I use the odbc insert command in the Stata statistics package (v14.2) on the Ubuntu 14.04.2 LTS server to insert some data into the Teradata DB database (v14.10). This Stata command has a block parameter that allows Stata to send data in blocks of 1000 lines. Unfortunately, the ODBC driver seems to do single-line inserts (according to the DBA that monitors the system).
Can I change the behavior of an ODBC driver? If so, how do I determine the block size for the ODBC driver for use in the .odbc.ini file or in the connection string? I looked through the TD ODBC and Googled manual, but I did not find anything useful.
source share