|
View previous topic :: View next topic
|
| Author |
Message |
Subha Padhy
New User
Joined: 15 Apr 2008
Posts: 2
Location: Bhubaneswar
|
|
|
|
| I am getting a comma separated file from some souce ... I have to upload this into the database ... this file has four floting fields ( pic s9(5)v9(2) comp3).While doing an unstring by comma it does not allow me to xfer the content for the floating points to working storage .so I have declared some numberic fields(Pic s9(7)).and then trying to redefine the same to s9(5)v9(2) comp3.but the data are getting lost.(i m getting SQL -310 error while trying to insert into the table) ... could you tell me how to overcome this? |
|
| Back to top |
|
 |
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix
|
|
|
|
Hello Subha Padhy and welcome to the forums,
| Quote: |
| this file has four floting fields ( pic s9(5)v9(2) comp3). |
That definition is for packed-decimal not floating-point data.
Please post (in hex) a bit of the data you are trying to unstring. You can do this by viewing the data in tso/ispf and issuing the HEX ON command. When you post the data, please use the "Code" tag at the top of the Reply panel. |
|
| Back to top |
|
|
Subha Padhy
New User
Joined: 15 Apr 2008
Posts: 2
Location: Bhubaneswar
|
|
|
|
| Code: |
| FFFFFFFFFF6D6FFFF6FF6FF6FFFF6FF6FF6FFFFFF6EECCD6CDE4DDDDCC6FFFFFFFFF6DCCFFFC6FFF6FFF6FF6FF6CCC6F4FFFF6DC6F4FFFF44 |
Sorry I agree this is packed decimal. |
|
| Back to top |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007
Posts: 10872
Location: italy
|
|
|
|
a mild suggestion...
when showing hex data I believe that most of us would prefer
HEX ON VERT, so to be able to see the displacements in the data |
|
| Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix
|
|
|
|
Hello,
Yes, please post using VERT, if it display like the sample below.
What i am looking for will be a "character" line, a hex-over line and a hex-under line. Like:
| Code: |
ABC 123
CCC4FFF
1230123 |
This is what i see when i specify HEX ON. |
|
| Back to top |
|
|
|
|
