ODBC Timeout value -- MIDRANGE-L

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

Subject: ODBC Timeout value
From: "Art Tostaine, Jr." <art@xxxxxxxxxxx>
Date: Tue, 26 Mar 2002 12:16:35 -0500
Importance: Normal
List-archive: <http://archive.midrange.com/midrange-l/>
List-help: <mailto:midrange-l-request@midrange.com?subject=help>
List-id: Midrange Systems Technical Discussion <midrange-l.midrange.com>
List-post: <mailto:midrange-l@midrange.com>
List-subscribe: <http://lists.midrange.com/cgi-bin/listinfo/midrange-l>,<mailto:midrange-l-request@midrange.com?subject=subscribe>
List-unsubscribe: <http://lists.midrange.com/cgi-bin/listinfo/midrange-l>,<mailto:midrange-l-request@midrange.com?subject=unsubscribe>

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.

Follow-Ups:

Re: ODBC Timeout value , Rolf Mittag

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.