Chad Jury 14.Jun.07 12:48 PM a Web browser Connector for DB2 LEI - 6.5 All Platforms
We just installed DB2 Connect Personal Edition and we are trying our first Virtual Agent. Our VA is trying to run a Stored Procedure on our iSeries.
We get this message, in the Virtual Agents log, when we try to run the agent/stored procedure.
Error: [IBM][CLI Driver][AS] SQL0440N No authorized routine named "TNASYS.CHADTEST" of type "" having compatible arguments was found. SQLSTATE=42884, Connector 'db2', Method -Call- (-440)
Here is the code created by our VA:
Set sess = New NotesSession
Set db = sess.CurrentDatabase
Set notesDoc = db.CreateDocument
Call notesDoc.Save(True,False) ----> This is were the error occurs.
Here is the Stored Procedure on our iSeries:
0003.00 SNDPGMMSG MSG('Hello. Test with no parameters.') +
CREATE PROCEDURE tnasys/CHADTEST
EXTERNAL NAME tnasys/CHADTEST