Re: CPF5035 on a QRY/400

[Vern Hamberg <vhamberg@xxxxxxxxxxxxxxx>]

Hi Darryl

Maybe try starting a database monitor before running the QRY - I can't 
guarantee this will work, but it might, since QRY for i does used 
database components.

When you convert a QRY to QM, there should be messages in the joblog 
that tell you more about any issues - not everything converts in every 
case - calculated columns and aggregates can be not what you expect.

In WRKQRY should should be able to print the definition, IIRC - see what 
is defining the column that seems to be in error.

HTH
Vern

On 11/27/2024 10:38 AM, a4g atl wrote:
> 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.