CPF5035 - Means ... invalid numeric values.
You may run the complete Query, then search the Joblog with the IBM
Service/Table_Function JOBLOG_INFO.
From the second level Message Text, you can retrieve the faulty column name,
relative record no, record format, member, file, library.
With the IBM Services VALIDATE_DATA, VALIDATE_DATA_FILE,
VALIDATE_DATA_LIBRARY you can detect the invalid numeric values.
https://www.ibm.com/docs/en/ssw_ibm_i_75/rzajq/rzajqudfvalidate.htm
Alternatively, you may try to convert the numeric columns with TRY_CAST into
the in the same (numeric) data type, length and decimal positions.
Contrary to CAST, TRY_CAST will return NULL values, for invalid numeric
values ... and NULL Values can be trapped.
Mit freundlichen Grüßen / Best regards
Birgitta Hauser
Modernization ? Education ? Consulting on IBM i
Database and Software Architect
IBM Champion since 2020
"Shoot for the moon, even if you miss, you'll land among the stars." (Les
Brown)
"If you think education is expensive, try ignorance." (Derek Bok)
"What is worse than training your staff and losing them? Not training them
and keeping them!"
"Train people well enough so they can leave, treat them well enough so they
don't want to. " (Richard Branson)
"Learning is experience ? everything else is only information!" (Albert
Einstein)
-----Original Message-----
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of a4g
atl
Sent: Wednesday, 27 November 2024 17:39
To: midrange-l@xxxxxxxxxxxxxxxxxx
Subject: CPF5035 on a QRY/400
I have inherited a QRY that was created before 2020. It has been running
daily ever since until this weekend.
The QRY is a complex QRY with 18 files.
Does anyone know of a way to get a dump of the values in the fields of the
QRYDFN when it fails? DMPJOB does not work.
I tried converting to a QMQRY to get the SQL. The SQL produces no errors but
returns an empty list of records. I see some records when working in WRKQRY
and use F5 to display the report and it does give me records. The column in
error has ++++.
I need to see the contents of the fields at the time to locate the problem.
TIA, Darryl Freinkel.
--
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.
midrange.com
