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

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 Assembler Macro Copybook converted to... Ziquilix PL/I & Assembler 4 Tue Sep 26, 2017 3:07 am
No new posts FUSE - IBM MQ - CICS integration error Kevin Vaz CICS 1 Mon Sep 18, 2017 4:31 pm
No new posts Reply MQ open error Vignesh Sid COBOL Programming 6 Thu Sep 07, 2017 6:02 pm
No new posts Error in SQL-PLIST3 'Above value tru... rikdeb DB2 4 Wed Sep 06, 2017 1:34 pm
No new posts WER268A OUTREC STATEMENT : SYNTAX E... frozenblood87 SYNCSORT 12 Sat Aug 26, 2017 9:45 pm

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