次の表に、診断域からサポートされる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 |