I have installed IBM DB2 Universal Database Version 7 with fixpack 7 and Store Procedure Builder.
I have also installed Microsoft Visual C++ .NET
In Store Procedure Builder I created this procedure:
CREATE PROCEDURE DB2ADMIN.Prova ( )
RESULT SETS 1
-- Declare cursor
DECLARE cursor1 CURSOR WITH RETURN FOR
SELECT * FROM DB2ADMIN.PERSON;
when i build it, the following error message appears:
DB2ADMIN.PROVA: [IBM][CLI Driver][DB2/NT] SQL0901N The SQL statement failed because of a non-severe system error. Subsequent SQL statements can be processed. (Reason "call to sqloopen failed".) SQLSTATE=58004
DB2ADMIN.PROVA - Changes rolled back.
DB2ADMIN.PROVA - Build failed.
Can someone help me and tell me why this error appears?
Thanks in advance.