Specifies whether the external procedure body accesses the database or contains SQL statements.
This clause is mandatory for all external procedures.
SQL DCL and DDL statements for administering row-level security are not allowed in a stored procedure.
Any of the listed option strings is valid for external routines written in the C, C++, or Java languages.
See SQL Data Definition Language - Detailed Topics, B035-1184 for more information about the SQL data access options.
- CONTAINS SQL
- The external procedure body contains SQL statements.
- MODIFIES SQL DATA
- The external procedure body accesses the database.
- NO SQL
- The default is NO SQL.
- READS SQL DATA
- The external procedure body accesses the database.