Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

decimal floating point conversion error

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
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    Post subject: decimal floating point conversion error
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

DFSORT Moderator


Joined: 09 Mar 2011
Posts: 7309

PostPosted: Thu Jan 08, 2015 9:47 pm    Post subject: Reply to: decimal floating point conversion error
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    Post subject: Re: Reply to: decimal floating point conversion error
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    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts IDC2902I Error tzeche ABENDS & Debugging 2 Tue Mar 28, 2017 11:39 am
No new posts Need help with below DB2 error ashek15 DB2 3 Sat Mar 18, 2017 5:56 am
No new posts FINDREP Syntax Error seahawk789 DFSORT/ICETOOL 4 Thu Mar 09, 2017 10:11 pm
No new posts INVOKE WEBSERVICE error danik56 CICS 11 Thu Mar 09, 2017 11:52 am
No new posts Row not found Sql error GaganGarg DB2 7 Tue Mar 07, 2017 6:29 am


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us