次の表に、診断域からサポートされるSQLストアド プロシージャCOMMAND_FUNCTIONの名前と、そのCOMMAND_FUNCTION_CODEの値をリストします。
- 正の値は、ANSI/ISO SQL:2011規格で定義されているコマンド関数を表わします。
- 負の値は、ANSI/ISO SQL:2011規格のTeradata拡張機能のコマンド関数を表わします。
| 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形式) | -24 |
| COLLECT STATISTICS (最適化ルーチン形式) | -24 |
| COMMENT (注釈入力形式) | -3 |
| COMMENT (コメント取得形式) | -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形式) | -25 |
| DROP STATISTICS (最適化ルーチン形式) | -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 |