skip to main content
SQL Escape Sequences for JDBC : Procedure Call Escape Sequences
  
Procedure Call Escape Sequences
A procedure is an executable object stored in the data store. Generally, it is one or more SQL statements that have been precompiled. The escape sequence for calling a procedure is:
{[?=]call procedure-name[(parameter[,parameter]...)]}
where:
procedure-name
specifies the name of a stored procedure.
parameter
specifies a stored procedure parameter.
Note: For DB2 for Linux/UNIX/Windows, a catalog name cannot be used when calling a stored procedure. Also, for DB2 V8.1 and V8.2 for Linux/UNIX/Windows, literal parameter values are supported for stored procedures. Other supported DB2 versions do not support literal parameter values for stored procedures.