Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1880
  • Last Modified:

Error: CLI0150E Driver not capable

Hi,

This is my database Connection Information

 Database server        = DB2/NT 7.2.0
 SQL authorization ID   = NMWBUSRD
 Local database alias   = FAMTEST

I am calling one DB2 stored procedure from CLP(command line processor). I used 3 cursors in my stored procedure. Most of the times, i got the following error while executing the stored procedure:-

db2 => call spn_create_sp(null, null, '4-004230', 9000002, 10600001,'2000-01-01', '2001-01-01', 'sarav', ?, ?)
CLI0150E  Driver not capable. SQLSTATE=HYC00

What can i do execute the stored procedure?

I tried to restart DB2 server & lot of things. Still i am facing the same problem. The stored procedure compiled successfully & ran successfully initially. But Later the above error came. What may the reason to get the above error? What will be best solution to solve this error & avoid this error in future?

Sometimes, i got the following error also:
D:\PROGRA~1\SQLLIB\BIN>db2 call nmworkb.test_sp('1',1,'1',1,1,null,null,null,?,?)
CLI0104E  Unable to connect to data source. SQLSTATE=08001

I dont know... where is the problem?

Initially i used ordinary cursor(with hold option). After i changed to FOR cursor. It worked initially well. But later the "drive not capable" error came...

Waiting for ur replies

Regards
Saravanan
0
mailsaravanan
Asked:
mailsaravanan
1 Solution
 
ghp7000Commented:
see my answer in
http://www.experts-exchange.com/Databases/IBM_UDB/Q_20874907.html
it may help you understand your problem
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now