Guys,

DB2 V7.1 on Win2000.  FP2a.

Running queries from the Command Centre.

Sometimes get SQLCODE = -952 (user interrupt error) even although we don't
interrupt anything.

SQL does need to be complex - for example it happens when we run a "SELECT
COUNT(*)" with a simple WHERE clause on a 4.5 million row table.

Ran a trace and noticed that the SQLPrepareW, SQLExecute, SQLRowCount and
SQLColAttributesW calls all return successfully.  It is the SQLFetch which
is getting the error.

Anybody experienced something similar ?

Any clues.

TIA

Phil Nelson
DB2 IT Consulting Ltd.



=====
To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED]
For other info (and scripts), see http://people.mn.mediaone.net/scottrmcleod

Reply via email to