I'm using IBM Infosphere Optim 8.1 with fixpack (I think..)
I'm getting "ODBC SQL State: HY104 Invalid precision value" error when inserting an extract file to my destination db.
I noticed that the error occurs when one of my table has a column with one of the types of "VarChar(Max)" , "VarBinary" , "nVarchar(Max)" , "XML"...
I think it's data size problem.. Please help and fix this bug!!!!
Note: When I alter columns from varchar(max) to varchar(8000) or from nvarchar(max) to nvarchar(4000) problem doesn't appear. But I'm really tired of this dumb solution...
NOTICE: developerWorks Community will be offline May 29-30, 2015 while we upgrade to the latest version of IBM Connections. For more information, read our upgrade FAQ.
This topic has been locked.
7 replies Latest Post - 2013-03-13T15:28:18Z by SystemAdmin
Pinned topic "ODBC SQL State: HY104 Invalid precision value" INSERT ERROR
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2013-03-13T15:28:18Z at 2013-03-13T15:28:18Z by SystemAdmin
KaoriN 060000PKYE5 PostsACCEPTED ANSWER
Re: "ODBC SQL State: HY104 Invalid precision value" INSERT ERROR2012-12-11T01:49:37Z in response to SystemAdminHi,
You are using Microsoft SQL Server, correct?
To use varchar(max) on SQL Server, you need to use "SQL Narive Client" driver. It is a requirement of SQL Server. If you don't have, you can download it from Microsoft web site.
Re: "ODBC SQL State: HY104 Invalid precision value" INSERT ERROR2012-12-14T13:58:46Z in response to KaoriNYes it fixed max problem but I still have Date type problem. And probably XML error too... That's why I changed my connections into sql server from native client earlier.
Any suggestions about how to fix Date type column errors??
Re: "ODBC SQL State: HY104 Invalid precision value" INSERT ERROR2013-03-01T08:23:03Z in response to SystemAdminI'm getting "odbc sql state: 22007 invalid date format" when I try to INSERT a table withe a Date type column...
I'm using SQL Server Native Client 11.0 for ODBC...
I really need help to fix this problem.
Re: "ODBC SQL State: HY104 Invalid precision value" INSERT ERROR2013-03-05T19:50:31Z in response to SystemAdminHello,
Is there any way to get an extract file with a row of data that exhibits the problem, along with the release of SQL Server that you are using?