Chad Jury 14.Jun.07 12:48 PM a Web browser Connector for DB2LEI - 6.5All 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.AppendItemValue("EIVirtualAgentParmDoc",3278273)
Call notesDoc.AppendItemValue("EIVirtualAgentName",sess.CurrentAgent.Name)
Call notesDoc.Save(True,False) ----> This is were the error occurs.
Call notesDoc.Remove(True)
Here is the Stored Procedure on our iSeries:
0001.00 PGM
0002.00
0003.00 SNDPGMMSG MSG('Hello. Test with no parameters.') +
0004.00 TOUSR(HOLLYW)
0005.00
0006.00 ENDPGM
CREATE PROCEDURE tnasys/CHADTEST
EXTERNAL NAME tnasys/CHADTEST
LANGUAGE CL
Return to top
Print this page
