Приложение 11. Идентификаторы выполняющихся в канале процессов

Идентификатор процесса		Описание процесса
0		Канал не активен, запрос еще не обрабатывается
1		SELECT
2		INSERT
3		UPDATE
4		DELETE
5		CREATE TABLE
6		CREATE VIEW
7		DROP TABLE
8		CREATE INDEX
9		DROP INDEX
10		GRANT: 1 form
11		GRANT: 2 form
12		REVOKE: 1 form
13		REVOKE: 2 form
14		ADD COLUMNS
15		ADD DATA FILE
16		ADD INDEX FILE
17		ADD BLOB FILE
18		MODIFY DATA FILE
19		MODIFY INDEX FILE
20		MODIFY BLOB FILE
21		DROP DATA FILE
22		DROP INDEX FILE
23		DROP BLOB FILE
24		PRESS TABLE
25		REBUILD TABLE
26		GETF (получить первую запись текущей выборки)
27		GETL (получить последнюю запись текущей выборки)
28		GETP (получить предыдущую запись текущей выборки)
29		GETN (получить следующую запись текущей выборки)
30		GETS (получить указанную запись текущей выборки)
31		UPDATE CURRENT CURSOR
32		DELETE CURRENT CURSOR
33		UPDATE CURRENT
34		DELETE CURRENT
35		CREATE NODE
36		DROP NODE
37		CREATE EVENT
38		DROP EVENT
39		GET EVENT
40		WAIT EVENT
41		SET EVENT
42		CLEAR EVENT
43		CREATE ROLE
44		DROP ROLE
45		GRANT ROLE
46		REVOKE ROLE
47		GRANT USER
48		REVOKE USER
49		LOCK TABLE
50		UNLOCK TABLE
51		GET MANY ROWS
52		EXECUTE PROCEDURE
53		START AUDIT
54		STOP AUDIT
55		COMMIT
56		ROLLBACK
57		ALTER TABLE SET READ LEVEL | WRITE LEVEL
58		CREATE PROCEDURE
59		DROP PROCEDURE
60		ALTER PROCEDURE
61		CREATE GROUP
62		CREATE LEVEL
63		ALTER GROUP
64		ALTER LEVEL
65		GRANT ACCESS ON GROUP
66		REVOKE ACCESS ON GROUP
67		SOME AUDIT COMMAND
68		CREATE STATION
69		DROP STATION
70		ALTER STATION
71		CREATE DEVICE
72		DROP DEVICE
73		ALTER DEVICE
74		GRANT ACCESS ON STATION
75		REVOKE ACCESS ON STATION
76		GRANT ACCESS ON DEVICE
77		REVOKE ACCESS ON DEVICE
78		DEBUG PROCEDURE
79		START APPEND
80		END APPEND
81		ALTER TABLE ADD PRIMARY KEY
82		ALTER TABLE ADD FOREIGN KEY
83		ALTER TABLE ADD UNIQUE
84		ALTER TABLE DROP PRIMARY KEY
85		ALTER TABLE DROP FOREIGN KEY
86		ALTER TABLE DROP UNIQUE
87		ALTER TABLE SET COLUMN READ LEVEL | WRITE LEVEL
88		CREATE REPLICATION RULE
89		DROP REPLICATION RULE
90		ALTER REPLICATION RULE
91		CREATE TRIGGER
92		DROP TRIGGER
93		ALTER TRIGGER
94		SET TRANSACTION READ ONLY
95		SET TRANSACTION ISOLATION LEVEL
96		SET SAVEPOINT
97		PUT SEVERAL ROWS
98		ALTER TABLE ALTER COLUMN SET DEFAULT
99		ALTER TABLE ALTER COLUMN DROP DEFAULT
100		ALTER TABLE RENAME COLUMN
101		ALTER TABLE ALTER COLUMN SIZE
102		ALTER TABLE RENAME
103		ALTER TABLE ADD CHECK
104		ALTER TABLE DROP CHECK
105		ALTER TABLE ALTER COLUMN ADD CHECK
106		ALTER TABLE ALTER COLUMN DROP CHECK
107		Создание составного индекса
108		Удаление составного индекса
109		ALTER TABLE ALTER COLUMN ENABLE NULL
110		ALTER TABLE ALTER COLUMN DISABLE NULL
111		SET PRIORITY
112		TEST TABLE
113		CREATE PHRASE INDEX
114		DROP PHRASE INDEX
115		REBUILD PHRASE INDEX
116		BACKUP
117		CREATE FILTER
118		DROP FILTER
119		ALTER FILTER SET MODULE
120		SET DEFAULT FILTER FOR EXTENSION
121		CANCEL DEFAULT FILTER FOR EXTENSION
122		ALTER TABLE ALTER COLUMN SET DEFAULT FILTER
123		ALTER TABLE ALTER COLUMN CANCEL DEFAULT FILTER
124		SYNCHRONIZE RULE
125		ALTER TABLE ALTER COLUMN ADD RANGE
126		GET COMPLEX EVENT
127		WAIT COMPLEX EVENT
128		ALTER PHRASE INDEX
129		SET LOG
130		SET L_TTRUE COMMIT
131		SET ROW QUANT
132		SET INDEX QUANT
133		SET WORKSPACE LIMIT
134		CREATE TEMPORARY INDEX (INTERNAL)
135		CREATE SEQUENCE
136		DROP SEQUENCE
137		GRANT PROCEDURE
138		REVOKE PROCEDURE
139		CREATE CHARACTER SET
140		DROP CHARACTER SET
141		CREATE TRANSLATION
142		DROP TRANSLATION
143		SET NAMES
144		SET DATABASE NAMES
145		Один из процессов модификация параметров функционирования БД: SET RECORD SIZE LIMIT SET CHANNEL MEMORY LIMIT SET PHRASE INDEX FIRST CACHE SIZE SET PHRASE INDEX SECOND CACHE SIZE
146		BACKUP
147		SET CHANNEL AUTOCOMMIT
148		SET CHANNEL WAIT|NOWAIT
149		PURGE TABLE
150		ADD BLOB
151		CLEAR BLOB
152		GET LINTER DUMP
153		CREATE ALIAS
154		DROP ALIAS
155		ALTER CHARACTER SET SET DESCRIPTION
156		ALTER CHARACTER SET DROP DESCRIPTION
157		SET DATABASE DEFAULT CHARACTER SET
158		SET OPTIMIZATION ENABLE/DISABLE
159		TRUNCATE TABLE
160		SET CONSTRAINTS ALL DEFERRED/IMMEDIATE
161		SET TRANSACTION READ WRITE
162		SET SORTPOOL LIMIT/UNLIMITED
163		TEST INTERNAL DATA
164		SET SESSION BLOB LOG {OFF|ON}
165		SAVE TABLE
166		RESTORE TABLE
167		ALTER TABLE [NOT] IN-MEMORY
168		SET SESSION PROCEDURE EXECUTE BY DEFAULT AS {DEFINER|CURRENT_USER}
169		SET DATABASE GEODATA VALIDITY CHECKING ON/OFF
170		SET CONNECTION GEODATA VALIDITY CHECKING ON/OFF
171		SET SESSION DEFAULT SECURITY
172		ALTER SEQUENCE
173		SET SESSION QUANT TIMEOUT {LIMIT|UNLIMITED}
174		SET QUANT TIMEOUT {LIMIT|UNLIMITED} FOR USER
175		ALTER TABLE RENAME INDEX
176		SET DATABASE QUANTUM
177		SET SESSION QUANTUM
178		CORRECT INDEX|CONVERTER|BITMAP
179		Канал ожидает отсылки данных утилите lhb
180		ALTER PROCEDURE DROP SOURCE TEXT
181		ALTER TRIGGER DROP SOURCE TEXT
182		ALTER TABLE ENABLE/DISABLE KEY
183		ALTER EVENT
222		ALTER TABLE {SET|CANCEL} RECORDS LIMIT
223		EXECUTE BLOCK
225		DROP COLUMNS
226		PREPARE
227		MERGE
229		SET SCHEMA
230		CREATE COMMENT
231		CREATE VARIABLE
232		DROP VARIABLE