Procedure call escape sequences
- Last Updated: June 4, 2024
- 1 minute read
- DataDirect Connectors
- JDBC
- Aha! 6.0
- Amazon Redshift 6.0
- Apache Cassandra 6.0
- Apache Hive 6.0
- Apache Spark SQL 6.0
- Atlassian Jira 6.0
- Autonomous REST Connector 6.0
- Cloudera Impala 5.1
- + 24
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.