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.
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!
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?
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.