15.00 - Supported DML Statements in SQL Procedures - Teradata Database

Teradata Database SQL Data Definition Language Detailed Topics

prodname
Teradata Database
vrm_release
15.00
category
Programming Reference
featnum
B035-1184-015K

Supported DML Statements in SQL Procedures

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)