Supported and Unsupported DML Statements in SQL Procedures | Teradata Vantage - 17.10 - Supported DML Statements in SQL Procedures - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Data Definition Language Detailed Topics

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1184-171K
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)