We are trying to load the data from the SQL Server into Netezza using nzload option.
The table are created into Netezza through Datastage. When I try to read the data from SQL server for data type like "xml" and Nvarchar(max), odbc connector is giving below error message :-
Code: Select all
ODBC_Connector_0,0: The array size must be set to 1 when reading LOBs (CC_OdbcDBRecordDataSetProducer::dbsAllocateBindBuffers, file CC_OdbcDBRecordDataSetProducer.cpp, line 570)
Also I have added "DescribeVarcharAsLVC=0" to odbc.ini file.
Could you please help us on this? I have changed the array size still it is giving us the same error?
Thanks in Advance!!
Appreciate all your help!!