July 30, 2010, Friday, 210


SQL access level

From SQL PL Guide for DB2

Jump to: navigation, search

SQL access level clause

With the SQL access level clause you're determining what kind of SQL statements can be executed in the procedure. Possible are CONTAINS SQL, READS SQL DATA, or MODIFIES SQL DATA. In SQL PL stored procedures MODIFIES SQL DATA is the default.