View previous topic :: View next topic
|
Author |
Message |
Joris van der Steen
New User
Joined: 16 Feb 2007 Posts: 2 Location: the Netherlands
|
|
|
|
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 |
|
|
Bill Woodger
Moderator Emeritus
Joined: 09 Mar 2011 Posts: 7309 Location: Inside the Matrix
|
|
|
|
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 |
|
|
Joris van der Steen
New User
Joined: 16 Feb 2007 Posts: 2 Location: the Netherlands
|
|
|
|
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 |
|
|
|