IBM PureData System for Analytics, Version 7.1

Call another procedure

All procedures defined in an IBM® Netezza® database return a value; the default value is NULL. Thus, the normal way to call a procedure is to run a SELECT query or to do an assignment (resulting in an NZPLSQL internal SELECT).

However, there are cases where you might not be concerned with the result of the procedure. In these cases, use the CALL statement to call the procedure, as follows:

CALL query

The CALL statement runs a SELECT query and discards the result. Identifiers such as local variables are still substituted into input parameters.

There is a maximum stored procedure call recursion limit of 1024. If the call recursion exceeds this value, the following error message is returned:

ERROR:  stored procedure recursion limit exceeded