Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2015

    Unanswered: Retrieve Double value from DB2 table

    Hi all,
    Click image for larger version. 

Name:	capture.jpg 
Views:	4 
Size:	79.0 KB 
ID:	16423
    I have a double precession column in my DB2 table and when i try to retrieve the field it is being displayed in Scientific/Exponential format.
    When i try to display it in normal form it rounds off the data after the 16th digit.
    I tried using char/cast/convert/decimal/decfloat but none worked.

    Can anyone help me in retrieving the complete value of the float.
    also i have seen the following in the DB2 documentation. [ link ]
    Is it true ??
    Refer the attachment too..

    Any info this is also helpful..

    Thanks in advance.

  2. #2
    Join Date
    Apr 2006
    Provided Answers: 11
    the link is to db2 Z/os
    your platform and level ?
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5-V11 Fundamentals- DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified

  3. #3
    Join Date
    Feb 2015

    Thanks for the reply..

    Yes the link is to db2 Z/os.
    and by level what is it that you want.

    Am a novice beginner in mainframes any info on this would be of great help.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts