Command Function Code Values | Teradata Vantage - Command Function Code Values - Advanced SQL Engine - Teradata Database

SQL Stored Procedures and Embedded SQL

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
17.00
Published
June 2020
Language
English (United States)
Last Update
2021-01-23
dita:mapPath
xqq1557098602407.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1148
lifecycle
previous
Product Category
Teradata Vantage™
The following table lists the supported SQL stored procedure COMMAND_FUNCTION names and their COMMAND_FUNCTION_CODE values from the Diagnostics Area.
  • Positive values indicate command functions defined by the ANSI/ISO SQL:2011 Standard
  • Negative values indicate command functions that are Teradata extensions to the ANSI/ISO SQL:2011 Standard
COMMAND_FUNCTION COMMAND_FUNCTION_CODE
ABORT -34
ALTER TABLE 4
ALTER TRIGGER -28
ASSIGNMENT 5
BEGIN LOGGING -22
BEGIN TRANSACTION -4
CALL 7
CASE 86
CLOSE CURSOR 9
COLLECT DEMOGRAPHICS -36
COLLECT STATISTICS (QCD Form) -24
COLLECT STATISTICS (Optimizer Form) -24
COMMENT (Comment-Placing Form) -3
COMMENT (Comment-Retrieving Form) -3
COMMIT WORK 11
CREATE CAST 52
CREATE DATABASE -12
CREATE HASH INDEX -38
CREATE INDEX -11
CREATE JOIN INDEX -39
CREATE MACRO -6
CREATE ORDERING 114
CREATE PROFILE -31
CREATE ROLE 61
CREATE TABLE 77
CREATE TRANSFORM 117
CREATE TRIGGER 80
CREATE USER -13
CREATE VIEW 84
DEALLOCATE PREPARE 16
DECLARE VARIABLE 96
DELETE CURSOR 18
DELETE DATABASE -19
DELETE USER -42
DELETE WHERE 19
DROP CAST 78
DROP DATABASE -15
DROP HASH INDEX -40
DROP INDEX -37
DROP JOIN INDEX -41
DROP MACRO -7
DROP ORDERING 115
DROP PROCEDURE -29
DROP PROFILE -33
DROP ROLE 29
DROP STATISTICS (QCD Form) -25
DROP STATISTICS (Optimizer Form) -25
DROP TABLE 32
DROP TRANSFORM 116
DROP TRIGGER 34
DROP USER -43
DROP VIEW 36
DYNAMIC CLOSE 37
DYNAMIC DELETE CURSOR 38
DYNAMIC FETCH 39
DYNAMIC OPEN 40
DYNAMIC SQL -1
DYNAMIC UPDATE CURSOR 42
END LOGGING -23
END TRANSACTION -5
FETCH 45
FOR 46
GET DIAGNOSTICS -51
GIVE 14
GRANT 48
GRANT LOGON -20
GRANT ROLE 49
IF 88
INSERT 50
MERGE 128
MODIFY DATABASE -16
MODIFY PROFILE -32
MODIFY USER -35
MULTI STATEMENT -49
OPEN 53
PREPARE 56
QUERY_BAND -52
RENAME FUNCTION -50
RENAME MACRO -10
RENAME PROCEDURE -30
RENAME TABLE -8
RENAME TRIGGER -26
RENAME VIEW -9
REPEAT 95
REPLACE CAST -48
REPLACE MACRO -18
REPLACE ORDERING -45
REPLACE TRANSFORM -44
REPLACE TRIGGER -27
REPLACE VIEW -17
RESIGNAL 91
REVOKE 59
REVOKE LOGON -21
REVOKE ROLE 129
ROLLBACK WORK 62
SELECT 65
SIGNAL 92
UPDATE CURSOR 81
UPDATE WHERE 82
WHILE 97