Teradata ODBC paramter insert using SQL_ATTR_PARAMSET_SIZE not working.

Connectivity

Teradata ODBC paramter insert using SQL_ATTR_PARAMSET_SIZE not working.

Has anyone had success using the SQL_ATTR_PARAMSET_SIZE parameter with SQLSetStmtAttr for bulk inserts? When ever I set this parameter to lets say 32 if I then proceed to do a SQLGetStmtAttr(statement, SQL_ATTR_PARAMSET_SIZE, ...), the return value is still one.

I have followed the instructions in the “ODBC Driver for Teradata Users Guide” in the “Using Parameter Arrays” section. This code works with all of the other major RDBMS vendors.

The ODBC version being used is 03.05.00.04 on Windows 32 (2000 sp4) which should work. I have tried all version of the ODBC driver 03.05 and higher and none seem to work.

Thanks-
3 REPLIES
Enthusiast

Re: Teradata ODBC paramter insert using SQL_ATTR_PARAMSET_SIZE not working.

It has been a while, it seems there's still difficulty of setting up PARAMETER ARRAY in ODBC 13.10

I can't find SQL_ATTR_PARAMSET_SIZE in the ODBC trace log. The insert performance is pretty bad.

Enthusiast

Re: Teradata ODBC paramter insert using SQL_ATTR_PARAMSET_SIZE not working.

$ ldd /opt/teradata/teragss/13.10.00.06/lib/libtdgss.so

linux-gate.so.1 =>  (0xffffe000)

libpthread.so.0 => /lib/libpthread.so.0 (0xf7e1d000)

libdl.so.2 => /lib/libdl.so.2 (0xf7e19000)

libc.so.6 => /lib/libc.so.6 (0xf7cd3000)

libresolv.so.2 => /lib/libresolv.so.2 (0xf7cbf000)

/lib/ld-linux.so.2 (0x00745000)

$ ldd lib/DWtera24.so 

linux-vdso.so.1 =>  (0x00007fff3e3fc000)

libpthread.so.0 => /lib64/libpthread.so.0 (0x00002ba117f6f000)

librt.so.1 => /lib64/librt.so.1 (0x00002ba11818b000)

libDWicu24.so => /opt/Informatica/PowerCenter8.6.1/ODBC6.0/lib/libDWicu24.so (0x00002ba118394000)

libcliv2.so => /opt/teradata/client/13.0/lib64/libcliv2.so (0x00002ba118faa000)

libtdgss.so => /opt/teradata/teragss/13.00.01.02/lib/libtdgss.so (0x00002ba1190ff000)

libtdusr.so => /opt/teradata/client/13.0/lib64/libtdusr.so (0x00002ba1193c5000)

libdl.so.2 => /lib64/libdl.so.2 (0x00002ba1194c6000)

libstdc++.so.6 => /usr/lib64/libstdc++.so.6 (0x00002ba1196cb000)

libm.so.6 => /lib64/libm.so.6 (0x00002ba1199cb000)

libc.so.6 => /lib64/libc.so.6 (0x00002ba119c4e000)

libgcc_s.so.1 => /lib64/libgcc_s.so.1 (0x00002ba119fa6000)

/lib64/ld-linux-x86-64.so.2 (0x0000003ef1a00000)

libresolv.so.2 => /lib64/libresolv.so.2 (0x00002ba11a1b4000)

Both ODBC drivers provided by Teradata and DataDirect have not Array Insert exposed. Have to create staging table to load the data, and then run INSERT command in BTEQ.

Teradata Employee

Re: Teradata ODBC paramter insert using SQL_ATTR_PARAMSET_SIZE not working.

The ODBC Driver for Teradata supports Parameter Array; but I am not familiar with the DataDirect ODBC driver.

Is this a custom application or are you using Informatica? I think Informatica PowerCenter 8.6.1 does not support Parameter Array with the Teradata Database. Can you post a code snippet if you developed the application?