17.10 - Activity Type - Call-Level Interface Version 2

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

Product
Call-Level Interface Version 2
Release Number
17.10
Release Date
October 2021
Content Type
Programming Reference
Publication ID
B035-2418-061K
Language
English (United States)

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 137 Replace 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 Security Constraint
189 Alter Security Restraint 190 Drop Security Restraint 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 RESORCE PM/API 202 MONITOR WD - PM/API 203 REGISTER XML SCHEMA/XSLT STYLESHEET/XQUERY MODULE
204 CALENDAR CHANGED 205 MONITOR REQUEST - PM/API 206 Merge-Into-Delete
207 Begin QUERY CAPTURE 208 End QUERY CAPTURE 209 SHOW IN XML [DB_OBJECT/DML]
210 GTW HOSTGROUP PROPERTIES 211 ProxyConfig - From client when it supports Proxy 212 SecureAttribute Parcel
213 VH FSG Cache 214 Unity SQL Stmt 215 Aster Support
216 Create Zone 217 Alter Zone 218 Drop Zone
219 Create Fore Srv 220 Alter Fore Srv 221 Drop Foreign Srv
222 Begin Iso Load 223 Checkpt Iso Load 224 End Iso Load
225 Set Sess Load 226 Grant Zone 227 Revoke Zone
228 For Viewpoint 229 Set Sess JSON 230 CheckJI Act Type
231 Create Map 232 Set Session UPT 233 Drop Map
234 Grant Map 235 Revoke Map 236 Sess Dot No.
237 Create Schema 238 Drop Schema 239 Debug Function
240 Foreign Server 241 Set Transform Group 242 Create Alias
243 Replace Alias 244 Drop Alias 245 Incremental Restore
246 Execute Analytic Function 247 Set Session UDFSearchPath 248 Select with table
249 Insert with table 250 Execute Analytic Func

No ART table output