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: 7254

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 OO COBOL compile error Virendra Shambharkar COBOL Programming 3 Tue Jan 10, 2017 6:05 pm
No new posts S922 Error yuvan ABENDS & Debugging 3 Fri Dec 02, 2016 6:58 pm
No new posts Invoke Webservice Fails with DFHPI100... divated CICS 2 Thu Nov 24, 2016 5:57 pm
No new posts File Aid to File Manager conversion murali3955 IBM Tools 4 Thu Nov 24, 2016 3:41 pm
No new posts Conversion of a VB file to FB. isssal DFSORT/ICETOOL 1 Mon Oct 31, 2016 10:23 pm


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