Midrange News for the IBM i Community


Posted by: Chris Proctor
Programmer Analyst
Columbia Sports Company
Portland, OR
SQL Code 802 on stored procedure after v6r1 upgrade?
has no ratings.
Published: 18 Jul 2012
Revised: 23 Jan 2013 - 1553 days ago
Last viewed on: 24 Apr 2017 (3099 views) 

Using IBM i? Need to create Excel, CSV, HTML, JSON, PDF, SPOOL reports? Learn more about the fastest and least expensive tool for the job: SQL iQuery.

SQL Code 802 on stored procedure after v6r1 upgrade? Published by: Chris Proctor on 18 Jul 2012 view comments(2)

Hi. Last weekend we finally upgraded our system to v6r1. Anyway, we have a stored procedure that has been running fine, but after the upgrade we are now getting an sqlcode 802 error. Has anyone else encountered that problem? Any help would be greatly appreciated. I tried recompiling the stored procedure and that did not change anything.

THanks!

Return to midrangenews.com home page.
Sort Ascend | Descend

COMMENTS

(Sign in to Post a Comment)
Posted by: DaleB
Premium member *
Reading, PA
Comment on: SQL Code 802 on stored procedure after v6r1 upgrade?
Posted: 4 years 9 months 6 days 20 hours 10 minutes ago

802 is data conversion or data mapping error, isn't it? Most often bad decimal data, which is probably not the result of upgrade to V6R1. Sorry to ask, but have you run in debug?

Posted by: chrisp
Premium member *
Portland, OR
Comment on: SQL Code 802 on stored procedure after v6r1 upgrade?
Posted: 4 years 9 months 6 days 18 hours 25 minutes ago

Hi Dale. Yes, it is data mapping or data conversion error. I'm actually going to run it in debug this morning in iNav. Is there a better way of debugging it? We're testing with only one header and one detail record and as far as I can see, the data looks fine, so I'm not sure where the problem could be.