Improve company productivity with a Business Account.Sign Up


Error: CLI0150E  Driver not capable

Posted on 2004-02-06
Medium Priority
Last Modified: 2012-08-14

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

Question by:mailsaravanan
1 Comment
LVL 13

Accepted Solution

ghp7000 earned 400 total points
ID: 10300907
see my answer in
it may help you understand your problem

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

November 2009 Recently, a question came up in the DB2 forum regarding the date format in DB2 UDB for AS/400.  Apparently in UDB LUW (Linux/Unix/Windows), the date format is a system-wide setting, and is not controlled at the session level.  I'm n…
Recursive SQL in UDB/LUW (it really isn't that hard to do) Recursive SQL is most often used to convert columns to rows or rows to columns.  A previous article described the process of converting rows to columns.  This article will build off of th…
Watch the video to learn how one can deal with PST file corruption issue with an outstanding Kernel for Outlook PST Repair Tool easily. Using this tool, non-technical users can swiftly perform the repair process to restore their essential data witho…
To export Lotus Notes to Outlook PST or Exchange and Domino Server files to Exchange Server or PST files with ease, go for Kernel for Lotus Notes to Outlook conversion tool. Through the video, you can watch the conversion process. A common user with…

606 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question