0 Replies Latest reply on Jan 25, 2013 7:36 AM by rameshchandra

    Data retrieval in non-scientific notation from Netezza database


      I have a requirement where my BPEL service fetches data from Netezza database. In the database, there is a field which is of type numeric(16,8) and holds values say '0.00000000'. The select query on the table rerieves data in its scientific notation as '0E-8'.
      Please let me know how to retrieve its value in the form of non-scientific notation.
      Thanks in advance.