float data type from SQL server using ODBC

sainath · Post by **sainath** » 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

sainath · Post by **sainath** » Sun Jul 24, 2011 3:43 pm

Hi

can any one help to fix above issue..I already searched for this in datastage and could not find any thing

thks

chulett · Post by **chulett** » Sun Jul 24, 2011 3:51 pm

How about posting the actual unedited error rather than typing it in by hand. And I would assume you meant "cast" rather than "convert", yes? Regardless, I'd be curious exactly what "not allowing me to do so" meant.

ray.wurlod · Post by **ray.wurlod** » Sun Jul 24, 2011 7:24 pm

Are you using an ODBC Connector stage? If so you can cause the schema mismatch to throw a warning rather than a fatal error, to determine whether it actually affects the data in the job. Ideally, of course, you need to resolve the metadata mismatch.

sainath · Post by **sainath** » Mon Jul 25, 2011 11:23 am

Hi

Thanks for your comments..

I am using ODBC Connector stage..

I mean when i was using convert function in SQL to convert from float to decimal (10,2) , I got some error as invalid operator(Yellow mark) ,

But i can view data and my connection is also working fine..

And my job also running fine..I just ignore this warning...

thks