[PyDB2-discuss] trouble with the where condition

[David K. <ka...@us...>]

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