Re: Query Error

A DSPMSGD shows the following. Got some weird data or something. Refer
to preceding messages in the job log for details.

What are the preceding messages?

Display Formatted Message Text
System: AVFDEV
Message ID . . . . . . . . . : QRY5053
Message file . . . . . . . . : QQRYMSG
Library . . . . . . . . . : QSYS

Message . . . . : Query run failed. &28 records added to member &16.
Cause . . . . . : At least one field in a selected record contains incorrect
data, data which could not be converted, or a null value which could not be
inserted into the output file. The data added to the file may be
incomplete.
Recovery . . . : Refer to preceding messages in the job log for details.
If the problem is due to an incompatibility with an existing file, change
your request to create a new file or change your record selections to omit
records with values that cannot be inserted into fields in the existing
file, then run the changed query. If bad decimal data or unwanted
substitution characters are involved, correct the data in the input field
records or change the query definition processing options so that Query
repairs decimal data errors or ignores use of substitution characters.



On Fri, Sep 5, 2008 at 12:07 PM, <Paul.Wilber@xxxxxxxxxxxxxxxxxxx> wrote:

Hi,

I started to receive error QRY5053 on a query that is run in a nightly
batch process.
Does anyone know what causes this error? I tried google and yahoo to no
avail.

Thanks,

Paul Wilber
Senior Systems Analyst
Precision Valve Corporation
Phone: 914.966.4408
Fax: 914.966.4630
paul.wilber@xxxxxxxxxxxxxxxxxxx

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.