Command Function Code Values
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 DATABASE | -12 |
| CREATE INDEX | -11 |
| CREATE JOIN INDEX | -39 |
| CREATE MACRO | -6 |
| CREATE PROFILE | -31 |
| CREATE ROLE | 61 |
| CREATE TABLE | 77 |
| 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 DATABASE | -15 |
| DROP INDEX | -37 |
| DROP JOIN INDEX | -41 |
| DROP MACRO | -7 |
| DROP PROFILE | -33 |
| DROP ROLE | 29 |
| DROP STATISTICS (QCD Form) | -25 |
| DROP STATISTICS (Optimizer Form) | -25 |
| DROP TABLE | 32 |
| 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 TABLE | -8 |
| RENAME TRIGGER | -26 |
| RENAME VIEW | -9 |
| REPEAT | 95 |
| REPLACE MACRO | -18 |
| 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 |