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?
Joined: 23 Nov 2006 Posts: 19270 Location: Inside the Matrix
Hello Subha Padhy and welcome to the forums,
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.