float data type from SQL server using ODBC
Posted: Fri Jul 22, 2011 10:19 am
Hi
I am using ODBC to acess SQL server data ..when i read float data type
datastage is giving fatal error..
schema reoncillation detected a size mismatch for column ,,whe reading database column DFloat to SFloat column, trancation or loss of pressiion ..
I tried to use convert function in SQL to convert from float to decimal..
but it is not allowing me to do so..
I think the problem is accessing data from SQL server..
Please help me to fix this issue
I am using ODBC to acess SQL server data ..when i read float data type
datastage is giving fatal error..
schema reoncillation detected a size mismatch for column ,,whe reading database column DFloat to SFloat column, trancation or loss of pressiion ..
I tried to use convert function in SQL to convert from float to decimal..
but it is not allowing me to do so..
I think the problem is accessing data from SQL server..
Please help me to fix this issue