Hi, I am a new iSeries user and I have a newbie question. I've searched these forums and also performed a web search, but I can't seem to find the answer. What is the syntax for executing an external stored procedure from within Interactive SQL (strsql)? Right now, I am trying a simple stored procedure that has one IN and one OUT parameter. I can execute it from the SQL window in iSeries Navigator by entering: call spname('inputstring','') This returns the expected result and works fine. However, this syntax won't work from Interactive SQL. I get: IN, OUT, or INOUT not valid for parameter 1 in procedure SPNAME in * Any ideas?
Unconfigured Ad Widget
Collapse
Announcement
Collapse
No announcement yet.
Executing Stored Procedures via Interactive SQL?
Collapse