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
 
Issue in calling DB2 SP from GUI, loss of precision error

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
rexx77

New User


Joined: 14 Apr 2008
Posts: 78
Location: Mysore

PostPosted: Thu Nov 14, 2013 6:32 pm    Post subject: Issue in calling DB2 SP from GUI, loss of precision error
Reply with quote

HI Team,

Greetings!


I have a column declared as Decimal (12,0). GUI passses the data to MF stored procedures.

Till last week, we were able to pass the data to MF SP's with out any issues. Over the week end, DB2 V10 upgrade happened.

Thereafter even if try to pass 11 decimal values to MF SP it is getting resulted in below error. But i could able to see the value which are greater than the value which i am passing today is already available in Table , with the date in last week.

"Invalid data conversion: Requested conversion would result in a loss of precision of XXXXXXXXXX, Error code: -461, Sqlstate = -42815"

There was no changes happened to Source components over the week end nor any significant data change from Business side.

At the same time, i am not sure whether this error is because of version upgrade, cannot point that with out knowing the actual reason.


Please let me know if any one of is aware of such issues and the solutions you have tried.

Many thanks.
Back to top
View user's profile Send private message

gylbharat

Active Member


Joined: 31 Jul 2009
Posts: 565
Location: Bangalore

PostPosted: Fri Nov 15, 2013 4:24 pm    Post subject:
Reply with quote

Are you doing any implicit or explicit type casting in your stored procedure?

Can you show us the code? I think v10 is more strict in terms of data type casting.
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 Calling IKJEFT01 program from Rexx upendrasri CLIST & REXX 4 Wed Nov 15, 2017 4:27 pm
No new posts -502 Error - Cursor already open anand jeyapaul DB2 7 Sun Oct 29, 2017 4:22 am
No new posts SIGNAL ON HALT issue packerm CLIST & REXX 1 Fri Oct 20, 2017 6:56 pm
No new posts IEW2456E error when link-editing a C ... Senthilraj JCL & VSAM 0 Fri Oct 13, 2017 3:12 pm
No new posts FTP Skip or ignore error and process ... AJAYREDDY All Other Mainframe Topics 3 Wed Sep 27, 2017 8:12 pm

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