I have a problem when running a query on smallint columns in sybase ase 11.9.2.
When I divide by ten a smallint column, result is rounding a smallint value automatically. But I need a 2 precision after comma.
Select maxsck/10 from bkl02 ; result=13
Select maxsck from bkl02 ; result=134
this problem may solve by programming but I need a more structural solving. I remember that, In Informix, there is a system variable DBFLOATMASK and if you define this variable for example 2 in config or profile file, query results always get 2 precision. I need similar thing in sybase.
Is there any way?