using System;
using System.Data;
using System.Data.Odbc;

namespace ConsoleApplication21{
	class Program{
		static void Main(string[] args)Х
			IDbConnection conn = new OdbcConnection("driver={IBM DB2 ODBC DRIVER};Database=Preview;hostname=xhost;port=50000;protocol=TCPIP;UID=user;pwd=password");
			conn.Open();

			IDbCommand cmd = conn.CreateCommand();

			Decimal decval = new Decimal();
			cmd.CommandText = "values(dec(123.00012,15,5))";
			using (IDataReader reader = cmd.ExecuteReader()){
				while (reader.Read()){	
					decval = reader.GetDecimal( 0 );
					System.Console.WriteLine(decval);
				}
			}
		}
	}
}