search

wmjie / ibm-db

Automatically exported from code.google.com/p/ibm-db
0 stars 0 forks source link

WLM_SET_CLIENT_INFO stored procedure fails with CLI0150E #143

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago 
Setting client information with WLM_SET_CLIENT_INFO fails with error

>>> cursor.callproc("WLM_SET_CLIENT_INFO",parameters=['luis', 'luis_client', 
'luis_app', 'fruta'])
Traceback (most recent call last):
  File "<stdin>", line 1, in <module>
  File "/usr/local/lib64/python2.6/site-packages/ibm_db-2.0.2-py2.6-linux-x86_64.egg/ibm_db_dbi.py", line 1160, in callproc
    result = self._callproc_helper(procname, parameters)
  File "/usr/local/lib64/python2.6/site-packages/ibm_db-2.0.2-py2.6-linux-x86_64.egg/ibm_db_dbi.py", line 1136, in _callproc_helper
    raise self.messages[len(self.messages) - 1]
ibm_db_dbi.DatabaseError: ibm_db_dbi::DatabaseError: Describe Param Failed: 
[IBM][CLI Driver] CLI0150E  Driver not capable. SQLSTATE=HYC00 SQLCODE=-99999

Original issue reported on code.google.com by south.mi...@gmail.com on 9 Dec 2013 at 3:23

GoogleCodeExporter commented 9 years ago 
WLM_SET_CLIENT_INFO procedure have 5 arguments but you are passing only 4, 
Please pass 5th argument also either None or some value.

The above error is not due to this, and I doesn't get any error when I run it 
on my environment.

Could you please provide us more detail info about DB2 server and Client

Original comment by rahul03...@gmail.com on 12 Dec 2013 at 6:44

GoogleCodeExporter commented 9 years ago 
My mistake, the SP is correctly called after adding the missing parameter.

Original comment by south.mi...@gmail.com on 12 Dec 2013 at 2:39

GoogleCodeExporter commented 9 years ago

Original comment by rahul.pr...@in.ibm.com on 13 Dec 2013 at 11:38