付録E 影響波及で解析できるSQL文の一覧
影響波及で解析できるSQL文の説明です。
影響波及の解析では,SQL文によって埋め込み変数の取り扱いが異なります。影響波及で解析できるSQL文を次に示します。
項番 |
SQL文 |
埋め込み変数の取り扱い |
|
---|---|---|---|
参照 |
更新 |
||
1 |
ALLOCATE |
○ |
× |
2 |
ALLOCATE CONNECTION HANDLE |
○ |
× |
3 |
ALLOCATE CURSOR |
○ |
× |
4 |
ALLOCATE DESCRIPTOR |
○ |
× |
5 |
ASSIGN LIST |
○ |
× |
6 |
CALL COMMAND |
○ |
× |
7 |
CALL |
○ |
× |
8 |
CLOSE |
○ |
× |
9 |
COMMIT |
○ |
× |
10 |
CONNECT |
○ |
× |
11 |
CONTEXT ALLOCATE |
○ |
× |
12 |
CONTEXT FREE |
○ |
× |
13 |
CONTEXT USE |
○ |
× |
14 |
DEALLOCATE DESCRIPTOR |
○ |
× |
15 |
DECLARE AUDIT INFO SET |
×※ |
× |
16 |
DECLARE CONNECTION HANDLE SET |
×※ |
× |
17 |
DECLARE CURSOR |
×※ |
× |
18 |
DECLARE STATEMENT |
×※ |
× |
19 |
DELETE |
○ |
× |
20 |
DESCRIBE CURSOR |
○ |
× |
21 |
DESCRIBE DESCRIPTOR |
○ |
× |
22 |
DESCRIBE TYPE |
○ |
× |
23 |
DESCRIBE |
○ |
× |
24 |
DROP LIST |
○ |
× |
25 |
EXECUTE DESCRIPTOR |
○ |
× |
26 |
EXECUTE IMMEDIATE |
○ |
○ |
27 |
EXECUTE |
○ |
○ |
28 |
FETCH DESCRIPTOR |
○ |
× |
29 |
FETCH |
○ |
○ |
30 |
FREE |
○ |
× |
31 |
FREE CONNECTION HANDLE |
○ |
× |
32 |
FREE LOCATOR |
○ |
× |
33 |
GET CONNECTION HANDLE |
○ |
× |
34 |
GET DESCRIPTOR |
○ |
× |
35 |
GET DIAGNOSTICS |
○ |
× |
36 |
INSERT |
○ |
× |
37 |
LOB APPEND |
○ |
× |
38 |
LOB ASSIGN |
○ |
× |
39 |
LOB CLOSE |
○ |
× |
40 |
LOB COPY |
○ |
× |
41 |
LOB CREATE TEMPORARY |
○ |
× |
42 |
LOB DESCRIBE |
○ |
× |
43 |
LOB DISABLE BUFFERING |
○ |
× |
44 |
LOB ENABLE BUFFERING |
○ |
× |
45 |
LOB ERASE |
○ |
× |
46 |
LOB FILE CLOSE ALL |
○ |
× |
47 |
LOB FILE SET |
○ |
× |
48 |
LOB FLUSH BUFFER |
○ |
× |
49 |
LOB FREE TEMPORARY |
○ |
× |
50 |
LOB LOAD |
○ |
× |
51 |
LOB OPEN |
○ |
× |
52 |
LOB READ |
○ |
× |
53 |
LOB TRIM |
○ |
× |
54 |
LOB WRITE |
○ |
× |
55 |
OPEN |
○ |
× |
56 |
PREPARE |
○ |
× |
57 |
ROLLBACK |
○ |
× |
58 |
SAVEPOINT |
○ |
× |
59 |
SELECT |
○ |
○ |
60 |
SET |
○ |
× |
61 |
SET DESCRIPTOR |
○ |
× |
62 |
SET SESSION AUTHORIZATION |
○ |
× |
63 |
UPDATE |
○ |
× |