Specifies whether the procedure body accesses the database or contains SQL statements.
This clause is mandatory for all SQL procedures. See CREATE PROCEDURE (SQL Form) in Teradata Vantage™ - SQL Data Definition Language Detailed Topics, B035-1184 for descriptions of the SQL data access options.
- CONTAINS SQL
- The procedure can execute SQL control statements.
- MODIFIES SQL DATA
- The procedure can execute all SQL statements that can validly be called from an SQL procedure.
- READS SQL DATA
- The procedure cannot execute SQL statements that modify SQL data, but can execute statements that read SQL data.