16.20 - Supported DML Statements in SQL Procedures - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantage™ SQL Data Definition Language Detailed Topics

Product
Teradata Database
Teradata Vantage NewSQL Engine
Release Number
16.20
Release Date
March 2019
Content Type
Programming Reference
Publication ID
B035-1184-162K
Language
English (United States)

You can specify the following SQL DML statements in an SQL procedure.

  • ABORT
  • BEGIN TRANSACTION
  • CALL
  • COLLECT STATISTICS (QCD Form)
  • COMMENT
  • COMMIT [WORK]
  • DECLARE CURSOR (selection form)
  • DELETE (all forms)
  • DROP STATISTICS (QCD Form)
  • END TRANSACTION
  • INSERT
  • MERGE
  • ROLLBACK
  • SELECT (only in cursors)

    You cannot specify row-returning SELECT requests in dynamic SQL that is written using the DBC.SysExecSQL procedure.

  • SELECT AND CONSUME TOP 1 
(only in non-updatable cursors)
  • SELECT INTO

    You cannot specify row-returning SELECT INTO requests in dynamic SQL that is written using the DBC.SysExecSQL procedure.

  • SELECT AND CONSUME TOP 1 INTO
  • UPDATE (all forms)