× 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.


  1.  Home
  2. MIDRANGE-L
  3. March 2002

ODBC Timeout value

A customer of mine is receiving an error when using ODBC driver from Access:

Ibm Client Access Express ODBC Driver 32 bit... SQL0666-Estimated query 
processing time 72 exceeds limit 60.

The system value is set at 600.

I copied QAQQINI from Qsys to Qusrsys (thanks archives), but his JOBLOG shows 
this:

Message . . . . :   Unable to retrieve query options file.
Cause . . . . . :   Unable to retrieve the query options from member QAQQINI
  in file QAQQINI in library QUSRSYS for reason code 5.  The reason codes and
  their meanings follow:
    5 - File QAQQINI and the internal query options structures are out of
  sync.

Is this some sort of version problem with CAE and V4R5?

Also, I tried editing QAQQINI with UPDDTA, said the fields were too big.  Tried 
EDTF, wouldn't let me do an externally described
file.  Do I have to create a flat file first and then edit it?

_________________
Art Tostaine, Jr.
CCA, Inc.
Jackson, NJ 08527

As an Amazon Associate we earn from qualifying purchases.

This thread ...
Follow-Ups:
Replies:
Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

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.