Unconfigured Ad Widget



No announcement yet.

Executing Stored Procedures via Interactive SQL?

  • Filter
  • Time
  • Show
Clear All
new posts

  • Executing Stored Procedures via Interactive SQL?

    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?