Re: Query Error

["Michael Ryan" <michaelrtr@xxxxxxxxx>]

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.