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