Re: Value in field does not match database???? -- RPG400-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.

On 9/5/2019 4:14 PM, Greg Wilburn wrote:

Verified them all before bothering to post. See below.

-----Original Message-----
From: RPG400-L [mailto:rpg400-l-bounces@xxxxxxxxxxxxxxxxxx] On Behalf Of Joe Pluta
Sent: Thursday, September 05, 2019 5:11 PM
To: rpg400-l@xxxxxxxxxxxxxxxxxx
Subject: Re: Value in field does not match database????

Okay, first, if you add RRN(OEORDLRR) on your SQL select statement, does
the RR# match the value you saw in WRKJOB? (And just to be REALLY OCD
about it, you're certain that record format OEORD2 exists in file
specification OEORDLRR, right?)

got the RRN from the WRKJOB to begin with

I was just being really thorough (others would use another word) - you showed us an SQL select but there was no RRN on it. I just wondered if you added the RRN() to the SQL select statement if it would match the RRN you saw in the WRKJOB.

I know it almost certainly will, but it's those kinds of things that sometimes make a light bulb go on. Short of that, I'm inclined to agree with Jon about memory corruption.

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.