Hi, I'm new to using pydb2 and am trying to insert a
blob but get an error when I run the following:
curs.execute('INSERT INTO PHOTO_TEMP (IMAGE)
VALUES (?)',(DB2.BLOB('C:/tmp/im.jpg'),))
Here is the error:
SQLSTATE : 428A1, NATIVE ERROR CODE : -452
[IBM][CLI Driver][DB2/6000] SQL0452N Unable to
access the file referenced by host variable "1". Reason
code: "1". SQLSTATE=428A1
Any idea what I'm doing wrong?
Thanks in advance.
John
Logged In: NO
John,
I got the same error. I've tried moving up to pyDB2 1.1.0. This
issue is resolved, but I'm getting my last row duplicated in queries
using this release, and that's the worse of two evils.
Phil