| line |
stmt |
bran |
cond |
sub |
pod |
time |
code |
|
1
|
|
|
|
|
|
|
|
|
2
|
|
|
|
|
|
|
package SQL::Admin::Driver::DB2::Keywords; |
|
3
|
2
|
|
|
2
|
|
2176
|
use base qw( Exporter ); |
|
|
2
|
|
|
|
|
4
|
|
|
|
2
|
|
|
|
|
188
|
|
|
4
|
|
|
|
|
|
|
|
|
5
|
2
|
|
|
2
|
|
12
|
use strict; |
|
|
2
|
|
|
|
|
5
|
|
|
|
2
|
|
|
|
|
69
|
|
|
6
|
2
|
|
|
2
|
|
13
|
use warnings; |
|
|
2
|
|
|
|
|
3
|
|
|
|
2
|
|
|
|
|
1166
|
|
|
7
|
|
|
|
|
|
|
|
|
8
|
|
|
|
|
|
|
our $VERSION = v0.5.0; |
|
9
|
|
|
|
|
|
|
|
|
10
|
|
|
|
|
|
|
###################################################################### |
|
11
|
|
|
|
|
|
|
|
|
12
|
|
|
|
|
|
|
our @EXPORT_OK = ( |
|
13
|
|
|
|
|
|
|
'%RESERVED_KEYWORDS', |
|
14
|
|
|
|
|
|
|
'%NONRESERVED_KEYWORDS', |
|
15
|
|
|
|
|
|
|
'%SQL_KEYWORDS', |
|
16
|
|
|
|
|
|
|
); |
|
17
|
|
|
|
|
|
|
|
|
18
|
|
|
|
|
|
|
|
|
19
|
|
|
|
|
|
|
our %EXPORT_TAGS = ( all => \@EXPORT_OK ); |
|
20
|
|
|
|
|
|
|
|
|
21
|
|
|
|
|
|
|
###################################################################### |
|
22
|
|
|
|
|
|
|
|
|
23
|
|
|
|
|
|
|
our %RESERVED_KEYWORDS = map +( lc $_ => 1 ), ( |
|
24
|
|
|
|
|
|
|
qw( ADD DETERMINISTIC LEAVE RESTART ), |
|
25
|
|
|
|
|
|
|
qw( AFTER DISALLOW LEFT RESTRICT ), |
|
26
|
|
|
|
|
|
|
qw( ALIAS DISCONNECT LIKE RESULT ), |
|
27
|
|
|
|
|
|
|
qw( ALL DISTINCT LINKTYPE RESULT_SET_LOCATOR ), |
|
28
|
|
|
|
|
|
|
qw( ALLOCATE DO LOCAL RETURN ), |
|
29
|
|
|
|
|
|
|
qw( ALLOW DOUBLE LOCALE RETURNS ), |
|
30
|
|
|
|
|
|
|
qw( ALTER DROP LOCATOR REVOKE ), |
|
31
|
|
|
|
|
|
|
qw( AND DSNHATTR LOCATORS RIGHT ), |
|
32
|
|
|
|
|
|
|
qw( ANY DSSIZE LOCK ROLLBACK ), |
|
33
|
|
|
|
|
|
|
qw( APPLICATION DYNAMIC LOCKMAX ROUTINE ), |
|
34
|
|
|
|
|
|
|
qw( AS EACH LOCKSIZE ROW ), |
|
35
|
|
|
|
|
|
|
qw( ASSOCIATE EDITPROC LONG ROWS ), |
|
36
|
|
|
|
|
|
|
qw( ASUTIME ELSE LOOP RRN ), |
|
37
|
|
|
|
|
|
|
qw( AUDIT ELSEIF MAXVALUE RUN ), |
|
38
|
|
|
|
|
|
|
qw( AUTHORIZATION ENCODING MICROSECOND SAVEPOINT ), |
|
39
|
|
|
|
|
|
|
qw( AUX END MICROSECONDS SCHEMA ), |
|
40
|
|
|
|
|
|
|
qw( AUXILIARY END-EXEC MINUTE SCRATCHPAD ), |
|
41
|
|
|
|
|
|
|
qw( BEFORE END-EXEC1 MINUTES SECOND ), |
|
42
|
|
|
|
|
|
|
qw( BEGIN ERASE MINVALUE SECONDS ), |
|
43
|
|
|
|
|
|
|
qw( BETWEEN ESCAPE MODE SECQTY ), |
|
44
|
|
|
|
|
|
|
qw( BINARY EXCEPT MODIFIES SECURITY ), |
|
45
|
|
|
|
|
|
|
qw( BUFFERPOOL EXCEPTION MONTH SELECT ), |
|
46
|
|
|
|
|
|
|
qw( BY EXCLUDING MONTHS SENSITIVE ), |
|
47
|
|
|
|
|
|
|
qw( CACHE EXECUTE NEW SET ), |
|
48
|
|
|
|
|
|
|
qw( CALL EXISTS NEW_TABLE SIGNAL ), |
|
49
|
|
|
|
|
|
|
qw( CALLED EXIT NO SIMPLE ), |
|
50
|
|
|
|
|
|
|
qw( CAPTURE EXTERNAL NOCACHE SOME ), |
|
51
|
|
|
|
|
|
|
qw( CARDINALITY FENCED NOCYCLE SOURCE ), |
|
52
|
|
|
|
|
|
|
qw( CASCADED FETCH NODENAME SPECIFIC ), |
|
53
|
|
|
|
|
|
|
qw( CASE FIELDPROC NODENUMBER SQL ), |
|
54
|
|
|
|
|
|
|
qw( CAST FILE NOMAXVALUE SQLID ), |
|
55
|
|
|
|
|
|
|
qw( CCSID FINAL NOMINVALUE STANDARD ), |
|
56
|
|
|
|
|
|
|
qw( CHAR FOR NOORDER START ), |
|
57
|
|
|
|
|
|
|
qw( CHARACTER FOREIGN NOT STATIC ), |
|
58
|
|
|
|
|
|
|
qw( CHECK FREE NULL STAY ), |
|
59
|
|
|
|
|
|
|
qw( CLOSE FROM NULLS STOGROUP ), |
|
60
|
|
|
|
|
|
|
qw( CLUSTER FULL NUMPARTS STORES ), |
|
61
|
|
|
|
|
|
|
qw( COLLECTION FUNCTION OBID STYLE ), |
|
62
|
|
|
|
|
|
|
qw( COLLID GENERAL OF SUBPAGES ), |
|
63
|
|
|
|
|
|
|
qw( COLUMN GENERATED OLD SUBSTRING ), |
|
64
|
|
|
|
|
|
|
qw( COMMENT GET OLD_TABLE SYNONYM ), |
|
65
|
|
|
|
|
|
|
qw( COMMIT GLOBAL ON SYSFUN ), |
|
66
|
|
|
|
|
|
|
qw( CONCAT GO OPEN SYSIBM ), |
|
67
|
|
|
|
|
|
|
qw( CONDITION GOTO OPTIMIZATION SYSPROC ), |
|
68
|
|
|
|
|
|
|
qw( CONNECT GRANT OPTIMIZE SYSTEM ), |
|
69
|
|
|
|
|
|
|
qw( CONNECTION GRAPHIC OPTION TABLE ), |
|
70
|
|
|
|
|
|
|
qw( CONSTRAINT GROUP OR TABLESPACE ), |
|
71
|
|
|
|
|
|
|
qw( CONTAINS HANDLER ORDER THEN ), |
|
72
|
|
|
|
|
|
|
qw( CONTINUE HAVING OUT TO ), |
|
73
|
|
|
|
|
|
|
qw( COUNT HOLD OUTER TRANSACTION ), |
|
74
|
|
|
|
|
|
|
qw( COUNT_BIG HOUR OVERRIDING TRIGGER ), |
|
75
|
|
|
|
|
|
|
qw( CREATE HOURS PACKAGE TRIM ), |
|
76
|
|
|
|
|
|
|
qw( CROSS IDENTITY PARAMETER TYPE ), |
|
77
|
|
|
|
|
|
|
qw( CURRENT IF PART UNDO ), |
|
78
|
|
|
|
|
|
|
qw( CURRENT_DATE IMMEDIATE PARTITION UNION ), |
|
79
|
|
|
|
|
|
|
qw( CURRENT_LC_CTYPE IN PATH UNIQUE ), |
|
80
|
|
|
|
|
|
|
qw( CURRENT_PATH INCLUDING PIECESIZE UNTIL ), |
|
81
|
|
|
|
|
|
|
qw( CURRENT_SERVER INCREMENT PLAN UPDATE ), |
|
82
|
|
|
|
|
|
|
qw( CURRENT_TIME INDEX POSITION USAGE ), |
|
83
|
|
|
|
|
|
|
qw( CURRENT_TIMESTAMP INDICATOR PRECISION USER ), |
|
84
|
|
|
|
|
|
|
qw( CURRENT_TIMEZONE INHERIT PREPARE USING ), |
|
85
|
|
|
|
|
|
|
qw( CURRENT_USER INNER PRIMARY VALIDPROC ), |
|
86
|
|
|
|
|
|
|
qw( CURSOR INOUT PRIQTY VALUES ), |
|
87
|
|
|
|
|
|
|
qw( CYCLE INSENSITIVE PRIVILEGES VARIABLE ), |
|
88
|
|
|
|
|
|
|
qw( DATA INSERT PROCEDURE VARIANT ), |
|
89
|
|
|
|
|
|
|
qw( DATABASE INTEGRITY PROGRAM VCAT ), |
|
90
|
|
|
|
|
|
|
qw( DAY INTO PSID VIEW ), |
|
91
|
|
|
|
|
|
|
qw( DAYS IS QUERYNO VOLUMES ), |
|
92
|
|
|
|
|
|
|
qw( DB2GENERAL ISOBID READ WHEN ), |
|
93
|
|
|
|
|
|
|
qw( DB2GENRL ISOLATION READS WHERE ), |
|
94
|
|
|
|
|
|
|
qw( DB2SQL ITERATE RECOVERY WHILE ), |
|
95
|
|
|
|
|
|
|
qw( DBINFO JAR REFERENCES WITH ), |
|
96
|
|
|
|
|
|
|
qw( DECLARE JAVA REFERENCING WLM ), |
|
97
|
|
|
|
|
|
|
qw( DEFAULT JOIN RELEASE WRITE ), |
|
98
|
|
|
|
|
|
|
qw( DEFAULTS KEY RENAME YEAR ), |
|
99
|
|
|
|
|
|
|
qw( DEFINITION LABEL REPEAT YEARS ), |
|
100
|
|
|
|
|
|
|
qw( DELETE LANGUAGE RESET ), |
|
101
|
|
|
|
|
|
|
qw( DESCRIPTOR LC_CTYPE RESIGNAL ), |
|
102
|
|
|
|
|
|
|
); |
|
103
|
|
|
|
|
|
|
|
|
104
|
|
|
|
|
|
|
our %NONRESERVED_KEYWORDS = map +( $_ => 1 ), ( |
|
105
|
|
|
|
|
|
|
); |
|
106
|
|
|
|
|
|
|
|
|
107
|
|
|
|
|
|
|
our %SQL_KEYWORDS = map +( $_ => 1 ), ( |
|
108
|
|
|
|
|
|
|
); |
|
109
|
|
|
|
|
|
|
|
|
110
|
|
|
|
|
|
|
|
|
111
|
|
|
|
|
|
|
###################################################################### |
|
112
|
|
|
|
|
|
|
|
|
113
|
|
|
|
|
|
|
package SQL::Admin::Driver::DB2::Keywords; |
|
114
|
|
|
|
|
|
|
|
|
115
|
|
|
|
|
|
|
1; |
|
116
|
|
|
|
|
|
|
|