16.20 - Activity Type - Teradata Tools and Utilities

Teradata® Call-Level Interface Version 2 Reference for Mainframe-Attached Systems

prodname
Teradata Tools and Utilities
vrm_release
16.20
created_date
September 2019
category
Programming Reference
featnum
B035-2417-108K

The Activity Type field indicates the type of processing performed for the request.

Value Statement Value Statement Value Statement
0 Not available 1 SQL SELECT 2 SQL INSERT
3 SQL UPDATE 4 UPDATE...RETRIEVING 5 SQL DELETE
6 SQL CREATE TABLE 7 SQL ALTER TABLE 8 SQL CREATE VIEW
9 SQL CREATE MACRO 10 SQL DROP TABLE 11 SQL DROP VIEW
12 SQL DROP MACRO 13 SQL DROP INDEX 14 SQL RENAME TABLE
15 SQL RENAME VIEW 16 SQL RENAME MACRO 17 SQL CREATE INDEX
18 SQL CREATE DATABASE 19 SQL CREATE USER 20 SQL GRANT
21 SQL REVOKE 22 Give 23 SQL DROP DATABASE
24 SQL MODIFY DATABASE 25 SQL DATABASE 26 SQL BEGIN TRANSACTION
27 SQL END TRANSACTION 28 SQL ABORT 29 Null
30 SQL EXECUTE 31 SQL COMMENT SET 32 SQL COMMENT
33 SQL ECHO 34 Replace View 35 Replace Macro
36 SQL CHECKPOINT 37 Delete Journal 38 SQL ROLLBACK
39 Release Lock 40 HUT Config 41 VerifyCheckpoint
42 Dump Journal 43 Dump 44 Restore
45 RollForward 46 SQL Delete Database 47 Internal use only (for crash dumps)
48 Internal use only (for crash dumps) 49 SQL Show 50 SQL Help
51 Begin Loading 52 Check Point Load 53 End Loading
54 Insert 55 Grant Logon 56 Revoke Logon
57 Begin Access Log 58 End Access Log 59 Collect Statistics
60 Drop Statistics 61 Session Set 62 Begin Multiload
63 Multiload 64 Execute Multiload 65 End Multiload
66 Release Multiload 67 Multiload Delete 68 Multiload Insert
69 Multiload Update 70 Begin Delete Multiload 71 Data Status
72 Reserved for B1 security 73 Reserved for B1 security 74 Begin Export
75 End Export 76 2PC Vote Request 77 2PC Vote and Terminate Request
78 2PC Commit 79 2PC Abort 80 2PC Yes/Done Response to Vote Request
81 Obsolete 82 Obsolete 83 Set Session Rate
84 Monitor Session 85 Identify 86 Abort Session
87 Set Resource Rate 88 Obsolete 89 Revalidate RI references
90 ANSI SQL COMMIT WORK 91 Monitor Virtual Config 92 Monitor Physical Config
93 Monitor Virtual Summary 94 Monitor Physical Summary 95 Monitor Virtual Resource
96 Monitor Physical Resource 97 SQL CREATE TRIGGER 98 SQL DROP TRIGGER
99 SQL RENAME TRIGGER 100 Replace Trigger 101 SQL ALTER TRIGGER
102 Replication 103 Drop Procedure 104 Create Procedure
105 Call 106 SQL RENAME PROCEDURE 107 Replace Procedure
108 Set Session Account 109 Locking logger 110 Monitor Session
111 Monitor Version 112 Begin Database Query Log 113 End Database Query Log
114 SQL Create Role 115 SQL DROP ROLE 116 Grant Role
117 Revoke Role 118 SQL Create Profile 119 SQL Modify Profile
120 SQL Drop Profile 121 SQL SET ROLE 122 Create UDF
123 Replace UDF 124 Drop UDF 125 Alter UDF
126 Rename UDF 127 SQL MERGE INTO, updates and inserts 128 SQL MERGE INTO, updates, no inserts
129 SQL MERGE INTO, all inserts, no updates 130 SQL ALTER PROCEDURE 131 PM/API request TDWM ENABLE
132 PM/API request TDWM STATISTICS 133 TDWM Perf Groups 134 Create UDT
135 Drop UDT 136 Alter UDT 138 SQL CREATE METHOD
139 Alter Method 140 Replace Method 141 Create Cast
142 Replace Cast 143 Drop Cast 144 SQL CREATE ORDERING
145 Replace Ordering 146 Drop Ordering 147 SQL CREATE TRANSFORM
148 Replace Transform 149 SQL DROP TRANSFORM 150 Create Authorization
151 Drop Authorization 152 Create Replication Group 153 Alter Replication Group
154 Drop Replication Group 155 TDWM Delete Request Change stmt 156 TDWM Summary stmt
157 TDWM Dyn Rule stmt 158 TDWM Dyn Obj stmt 159 TDWM Wd Assignment stmt
160 TDWM Dyn Build 161 TDWM List Wd stmt 162 Set Session Isolation Level
163 Initiate Index Analysis 164 Replace Auth stmt 165 Set QUERY_BAND stmt
166 LOGGING ONLINE ARCHIVE ON 167 LOGGING ONLINE ARCHIVE OFF 168 MONITOR QUERYBAND
169 Create Column Correlation 170 Replace Column Correlation 171 Drop Column Correlation
172 Alter Column Correlation 173 USER EVENT CONTROL 174 EVENT STATUS
175 MONITOR AWT RESOURCE 176 SP Dynamic Result Set 177 Create Replication Rule Set
178 Replace Replication Rule Set 179 Drop Replication Rule Set 180 CREATE OPERATOR
181 REPLACE OPERATOR 182 RENAME OPERATOR 183 DROP OPERATOR
184 GRANT CONNECT THROUGH 185 REVOKE CONNECT THROUGH 186 CREATE GLOP SET
187 DROP GLOP SET 188 CREATE CONSTRAINT 189 ALTER CONSTRAINT
190 DROP CONSTRAINT 191 CREATE INDEX TYPE 192 DROP INDEX TYPE
193 REPLACE INDEX TYPE 194 ALTER INDEX 195 CHECK WORKLOAD FOR
196 FastExport No Spooling 197 CHECK WORKLOAD END 198 FLUSH DBQL CACHE
199 TDWMEXCEPTION PM/API 200 TDWMTEST PM/API 201 MONITOR TDWM RESOURCE PM/API
202 MONITOR WD - PM/API 203 REGISTER XML SCHEMA/XSLT STYLESHEET/XQUERY MODULE 204 CALENDAR CHANGED
205 MONITOR REQUEST - PM/API