15.10 - Activity Type - Call-Level Interface Version 2

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

prodname
Call-Level Interface Version 2
vrm_release
15.10
category
Programming Reference
featnum
B035-2417-035K

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

 

Table 66: Activity Codes 

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 RESORCE PM/API

202

MONITOR WD - PM/API

203

REGISTER XML SCHEMA/XSLT STYLESHEET/XQUERY MODULE

204

CALENDAR CHANGED

205

MONITOR REQUEST - PM/API