#1 Stored Procedures

[Anonymous]

I'm using DB2 v7.2 fixpack 6 and I'm trying to call stored
procedures using your module. Here is the code:

conn = DB2.connect(dsn='AIXDCINF', uid='farokh',
pwd='****')
curs = conn.cursor()
sql = 'call PPSDOMAIN.INSERTAPET(?,?,?,?,?,?)'
apetName = 'testApetPython'
fileUnitID = 2
premBearingInd = 'Y'
premInd = 'N'
ratable = 'Y'
premiumFlag = 'N'
curs.execute(sql, (apetName, fileUnitID, premBearingInd,
premInd, ratable, premiumFlag))

Once I run the code, I get the following error:

SQLSTATE : HY000, NATIVE ERROR CODE : -10013

[IBM][CLI Driver][DB2/6000] SQL10013N The specified
library "/home4/db2/db2dev0
9/sqllib/function/PPSDOMAIN.INSERTAPET" could not be
loaded.

However, I've been able to successfully run the stored
procedure from DB2 command line.
Do you have any suggestions / answers for this problem.
Any help would be greatly appreciated.

Regards
Farokh Herfat
farokh_herfat@cinfin.com