RE: Understanding a Query/400 Error Message

[Bud Roble <BRoble@xxxxxxxxxxxxxxxxxxxxxxxxxx>]

Something must have changed the structure of the DATECTRL file.    The error
you're receiving is similar to a level check you would get in an RPG program
when the structure of a file has been changed without a recompile of the
program.    All you need to do is bring the queries up in edit mode and
resave them so the level identifier on the file will match the query
definition.   Did you install some sort of upgrade of did someone add a new
field to the DATECTRL file for some reason?    As far as the error
messages....   I = Ignore, C = Cancel.    Note that you can get a more
detailed explanation of the error messages if you place the cursor on the
message and then press the F1 key.   If you page through the additional
information, you will see an explanation of the "I" and "C" and what they
will do.

Bud Roble
AS400 and PC Network Computer Consultant
(805)794-3027
broble@CharlesRobleConsulting.com


-----Original Message-----
From: Al Gershen [mailto:aldg1@charter.net]
Sent: Friday, November 15, 2002 12:38 PM
To: MAPICS Mailing List
Cc: Gershen, Al
Subject: Understanding a Query/400 Error Message

Environment: Older version of Query/400

Hi Mapics ML group:

We run two groups of jobs every Friday that consists of
groups of queries related to the updating of standard
costs for materials and direct labor (routing time).

One of the input DB files that is common to these queries
is called DATECTRL and it consists of one record that is
updated weekly that has current date information, such as
the dates of the beginning and ending of the current week,
the dates of the beginning and ending of the current
month, etc.

These jobs have been running well for years but this
morning they didn't run because of the following types of
error messages given off by the system:

Level for file DATECTRL in SLK [Library name} does not
match query (I C).
C

Level for file DATECTRL in SLK [Library name} does not
match query (I C).
I

It look like one error message was give off for each query
in the job that used the DATECTRL DB input file.

I looked at the DATECTRL DB file with its one record, that
was last updated on Sunday, Nov 23rd, and it looks fine.

Can someone advise me what the above error messsage means
and what I and C mean?

I look forward to hearing from you on this matter.

Regards,
Al Gershen
ECS Composites
Grants Pass, OR
aldg1@charter.net
_______________________________________________
This is the MAPICS ERP System Discussion (MAPICS-L) mailing list
To post a message email: MAPICS-L@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/mapics-l
or email: MAPICS-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/mapics-l.