Name of a database procedure (dbproc name) 

The name of a database procedure ( dbproc name ) designates a database procedure.

Syntax

<dbproc name> ::= [<owner>.]<procedure name>

<procedure name> ::= <identifier>

owner, identifier

Explanation

You cannot specify TEMP as the owner in a database procedure.

SQL statements for creating, calling, and dropping a database procedure

CREATE DBPROC statement

CALL statement

DROP DBPROC statement