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 - 1703 days ago
Last viewed on: 22 Sep 2017 (3424 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)

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: 5 years 2 months 6 days 12 hours 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: 5 years 2 months 6 days 10 hours 15 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.