Stored procedures can be written in SQL PL, but not in the PL/SQL dialect

The CREATE SOURCED PROCEDURE statement defines a procedure that is based on another procedure in a federated database

There are three types of stored procedures which can be deployed: SQL procedures, external procedures, and sourced procedures

Two identically-named procedures within a schema are permitted to have exactly the same number of parameters, but the parameters must have different data types assigned

They return scalar values and not array values

There are no DB2 monitor elements specific to OLAP functions

OLAP functions are not supported in a common table expression (CTE)

OLAP aggregation functions are not supported with column organized tables

Application 2 will read the amount of 90

Application 2 will read the amount of 100

Application 2 will receive a warning message

Application 2 will enter lock-wait state until application 1 commits or the locktimeout value expires