From: David K. <ka...@us...> - 2006-06-30 00:38:20
|
I'm having trouble with the where condition when I execute a cursor. I get results without it. I've tried different field conditions also: >>> import DB2 >>> con = DB2.connect('BYDB2TST','maskaix','*******'') >>> cursor = con.cursor() >>> cursor.execute("select * from mopsdb2.jeolparms where ordrnum = '3191J'") <---Is fine without the where condition >>> cursor.fetch() Traceback (most recent call last): File "<interactive input>", line 1, in ? OperationalError: ('40003', -30020, '[IBM][CLI Driver][DB2] SQL30020N Execution failed because of a Distributed Protocol Error that will affect the successful execution of subsequent commands and SQL statements: Reason Code "0x1245". SQLSTATE=58009\r\n') >>> -Dave Katcoff 802-769-4162 |