All SQL stored procedures are executed in the primary server unless they are specified as read-only procedures in the following section of the procedure declaration:
SQL_data_access_indication::= NO SQL | READS SQL DATA | CONTAINS SQL | MODIFIES SQL DATA
For full details of the syntax of the CREATE PROCEDURE statement, see CREATE PROCEDURE.
To avoid unnecessary handovers of read-only procedures and functions to the primary server, use one of the following values:
▪ NO SQL
▪ READS SQL DATA
▪ CONTAINS SQL
The keyword MODIFIES SQL DATA (default behavior) forces all procedures to be executed in the primary server.