IBM Mainframe Forum Index
 
Register
 
IBM Mainframe Forum Index Mainframe: Search Log in to check your private messages Log in
 

decimal floating point conversion error


 
IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
View previous topic :: :: View next topic  
Author Message
Joris van der Steen

New User


Joined: 16 Feb 2007
Posts: 2
Location: the Netherlands

PostPosted: Thu Jan 08, 2015 9:26 pm
Reply with quote

Hi everyone,

I have a problem with loading some data. I have received unloads from a colleague together with the ddl he used to load the data in DB2 for LUW.

I am now tryimg to load it on z/os (db2 v10).

The column I am having problems with is defined as DECFLOAT(16) and it's the same in the load statement.

This is an example of the value in the unload:
Code:
8.609905020352781546811397557666214382E


And this is the error I get:
Code:
DSNU310I  #DB1O 008 13:17:53.61 DSNURCON - RECORD (1) WILL BE DISCARDED DUE TO '<column name>'
                      CONVERSION ERROR FOR <table name>         
                      ERROR CODE '29 - DECIMAL FLOATING POINT CONV ERROR'                 


I already tried DECFLOAT(34) but it results in the same error.
A colleague suggested I make it a VARCHAR and use CAST but I was hoping there may be another solution.

Code'd
Back to top
View user's profile Send private message
Bill Woodger

Moderator Emeritus


Joined: 09 Mar 2011
Posts: 7312
Location: Inside the Matrix

PostPosted: Thu Jan 08, 2015 9:47 pm
Reply with quote

Please use the Code tags to preserve spacing. Also take care to include the message codes, I think you have lost the second one.

Your source data does not look correct. After the E there should be the value of the exponent, with + or - to "scale" the number correctly..
Back to top
View user's profile Send private message
Joris van der Steen

New User


Joined: 16 Feb 2007
Posts: 2
Location: the Netherlands

PostPosted: Thu Jan 08, 2015 10:12 pm
Reply with quote

Bill Woodger wrote:
Please use the Code tags to preserve spacing. Also take care to include the message codes, I think you have lost the second one.

Your source data does not look correct. After the E there should be the value of the exponent, with + or - to "scale" the number correctly..


Ok, thank you for your response. And I will use the code tags from now on. Kind of new to this.

I will ask if the (correct) data can be delivered again. Thanks again
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic All times are GMT + 6 Hours
Forum Index -> DB2
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Forum Replies
No new posts Date format conversion DFSORT/ICETOOL 4
No new posts can someone please help me in finding... IBM Tools 9
No new posts SYNCSORT Error - CONTROL FIELD BEYOND... SYNCSORT 10
No new posts Easytrieve EZABX007 with error code 0... CA Products 7
No new posts EBCDIC to ASCII conversion help All Other Mainframe Topics 1

Back to Top