RE: Problem with view that uses an SQL function created from a procedure within a service program -- MIDRANGE-L

× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.

Sorry I'm late to respond, but I thought this group would be interested in
another option. A new SYSTOOLS function was part of the May 2020 database
PTF groups for 7.3 and 7.4: VALIDATE_DATA. It will touch all the data in a
file and tell you which rows, by RRN and column name, have bad numeric
data.

https://www.ibm.com/support/pages/node/6174171
https://www.ibm.com/support/knowledgecenter/ssw_ibm_i_74/rzajq/rzajqudfvalidate.htm

THAT did it
By placing the results into a work file, I was able to capture the

relative record numbers as well as the data

SELECT rrn(a), a.*
FROM VIEW a
I could then look at the results ? see the highest rrn and using STRDBG

against the procedure in the service program, use the >following query

SELECT rrn(a), a.*
FROM VIEW a where rrn(a) > 180944

I was able to step through the procedure and look at the individual fields
It was one of the numeric fields that had spaces in it
I just manually changed the value and now everything is working fine

Sue Romano
Db2 for IBM i Development

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.