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

privileges, db2ssh, LBAC credentials

privileges, authority levels, certificates

db2ssh, trusted contexts, authority levels

privileges, authority levels, LBAC credentials

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