×
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.
Thanks Sue
Even though I found it, I will still play with that on Monday
Sent via the Samsung GALAXY S® 5, an AT&T 4G LTE smartphone
-------- Original message --------
From: Sue Romano <slromano@xxxxxxxxxx>
Date: 10/31/20 08:46 (GMT-05:00)
To: midrange-l@xxxxxxxxxxxxxxxxxx
Subject: [EXTERNAL] RE: Problem with view that uses an SQL function created from a procedure within a service program
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 is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit:
https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at
https://archive.midrange.com/midrange-l.
Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related questions.
Help support midrange.com by shopping at amazon.com with our affiliate link:
https://amazon.midrange.com
midrange.com
