Has anyone used DI on a Netezza DB? I’m using Netezza as target and was not able to insert into a table with more than 127 columns with BODI. Is this a limitation of the BODI interface to Netezza because I can insert into the same table with Netezza’s nzsql.
Cheers,
arrufus
arrufus 
(BOB member since 2006-07-19)
What ODBC driver are you using in your datastore to connect to the Netezza? What version of that driver?
What version of DI?
Certain specific Netezza drivers are on the official-platforms list for DI XIr2:
dnewton 
(BOB member since 2004-01-30)
I am using the Netezza ODBC version 3.5. It’s a curious error because when I use others tools to write straight insert scripts, it works. Also when I use template tables, DI succeeds in creating the table in Netezza but fails on inserting the data. I used a 127-column template table, it works and then fails when i increase it 128 columns. Strange and annoying 
The error log contains the following:
6772 7636 DBS-070401 9/29/06 9:47:28 AM |Dataflow DF_Test|Loader Query_fct_test
6772 7636 DBS-070401 9/29/06 9:47:28 AM ODBC data source <Netezza_BOW> error message for operation : .
5144 7208 DBS-070401 9/29/06 9:47:39 AM |Dataflow DF_Test|Loader Query_fct_test
5144 7208 DBS-070401 9/29/06 9:47:39 AM ODBC data source <Netezza_BOW> error message for operation : .
Mysteriously it tells me the “insert value list does not match column list” when I am at 128 columns but goes through when the number of columns is 127!
Any ideas why?
Cheers
arrufus 
(BOB member since 2006-07-19)
This may be a DI limitation. If you turn on detailed Tracing of the Loader, you should be able to see the INSERT SQL that DI is using. You can then see if DI is sending all 128 columns, or 127.
dnewton (BOB member since 2004-01-30)
I dont think it is generally the case though since I can insert as many rows as possible into other DB’s using DI. I may also not be using the right driver as I would expect DI to have it’s own driver for Netezza in place of the ODBC driver I am using.
Thanks for the reply anyway…
Cheers
arrufus (BOB member since 2006-07-19)