RE: Query Optimiser

Steven

Have you considered using Query Management queries instead? I think the
locking,  if any, would be minimal, since it's really an SQL statement, not
anything that has to check things in the file very much. If you have Query
Manager, there's an interface very like the Query/400 one, until you get
used to native SQL Or you just enter an SQL statement into a source member
and run CRTQMQRY.

There's also RTVQMQRY, which can convert a QRYDFN to a QMQRY source member.
Not everything translates, but most does. And the layout is handled well by
QMFORMs.

Biggest problem is changing from RUNQRY to STRQMQRY

Just a thought, but may solve your lock problem.

Vern

At 12:36 PM 9/5/02 +0100, you wrote:

This is a multipart message in MIME format.
--
[ Picked text/plain from multipart/alternative ]
Just discovered the hard way that this solution hasn't fixed the problem
of our Invoice File being locked when I save a Query/400 definition.  This
is becoming a big problem as the 'powers that be' want more reports on how
sales are doing, but I can't save the Query definitions without stopping
everyone in our Despatch area for 5 minutes...

Steven Donnellan