Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist 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: 7314

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 Conversion of UTF-8 to EBCDIC muralikrishnan_new COBOL Programming 1 Tue Nov 21, 2017 5:33 pm
No new posts Mainframe Blocks to Tracks conversion upendrasri JCL & VSAM 1 Sat Nov 18, 2017 10:52 am
No new posts -502 Error - Cursor already open anand jeyapaul DB2 7 Sun Oct 29, 2017 4:22 am
No new posts IEW2456E error when link-editing a C ... Senthilraj JCL & VSAM 0 Fri Oct 13, 2017 3:12 pm
No new posts Extend the decimal values in DIVISION Balaryan DFSORT/ICETOOL 3 Thu Oct 05, 2017 4:05 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us