Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Getting -310 while trying to upload to DB2

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> COBOL Programming
View previous topic :: :: View next topic  
Author Message
Subha Padhy

New User


Joined: 15 Apr 2008
Posts: 2
Location: Bhubaneswar

PostPosted: Tue Apr 15, 2008 11:46 am    Post subject: Getting -310 while trying to upload to DB2
Reply with quote

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
View user's profile Send private message

dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Tue Apr 15, 2008 12:12 pm    Post subject:
Reply with quote

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
View user's profile Send private message
Subha Padhy

New User


Joined: 15 Apr 2008
Posts: 2
Location: Bhubaneswar

PostPosted: Tue Apr 15, 2008 12:19 pm    Post subject:
Reply with quote

Code:
FFFFFFFFFF6D6FFFF6FF6FF6FFFF6FF6FF6FFFFFF6EECCD6CDE4DDDDCC6FFFFFFFFF6DCCFFFC6FFF6FFF6FF6FF6CCC6F4FFFF6DC6F4FFFF44


Sorry I agree this is packed decimal.
Back to top
View user's profile Send private message
enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10278
Location: italy

PostPosted: Tue Apr 15, 2008 12:21 pm    Post subject: Reply to: Getting -310 while trying to upload to DB2
Reply with quote

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
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Tue Apr 15, 2008 12:29 pm    Post subject:
Reply with quote

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
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> COBOL Programming All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Bulk extract and upload feature in Ca... Kasturi19 CA Products 0 Tue Jun 10, 2014 8:23 pm
No new posts Sharepoint upload dick scherrer All Other Mainframe Topics 5 Wed Nov 30, 2011 4:57 pm
No new posts Upload DB2 error 104 soumen2255 DB2 22 Wed Jun 09, 2010 7:11 pm
No new posts Download AND Upload functions of IBM ... henry888 All Other Mainframe Topics 7 Mon Mar 22, 2010 10:01 pm
No new posts upload db2 table using input as file ... santosh100678 DB2 2 Wed Nov 04, 2009 12:25 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us