MCH3601 for IBM i SQL Stored Procedures

IBM i SQL Stored Procedures are a way for an SQL application to define and then invoke a procedure through SQL statements.
These can be SQL defined procedures where the procedure consists completely of SQL statements.

There does not have to be any code external to SQL nor external procedures where a pre-written, high-level language program is registered so that it can be called through SQL.

SQL stored procedures are not valid when called from a command line interface with the CALL command.
- This will almost always result in message MCH3601 f/stored procedure t/stored procedure.

You can also see this same MCH3601 message when calling through an SQL interface if the call is unqualified and the SQL path is not properly set to resolve to the procedure.
- This occurs because the system attempts to call the program from the library list as a system program and not as a stored procedure if the procedure is not found in the SQL path. This results in the same MCH3601 message.

Information on stored procedure and unqualified name resolution on the SQL CALL statement can be found in the DB2 UDB for iSeries SQL Programming Concepts publication.