KickJava   Java API By Example, From Geeks To Geeks.

Java > Open Source Codes > com > triactive > jdo > store > SQL92Constants


1 /*
2  * Copyright 2002 (C) TJDO.
3  * All rights reserved.
4  *
5  * This software is distributed under the terms of the TJDO License version 1.0.
6  * See the terms of the TJDO License in the documentation provided with this software.
7  *
8  * $Id: SQL92Constants.java,v 1.1 2002/12/07 05:32:25 jackknifebarber Exp $
9  */

10
11 package com.triactive.jdo.store;
12
13
14 /**
15  * Contains various constants from the SQL/92 standard.
16  *
17  * <h4>SQL/92 Key Words</h4>
18  * A <dfn>key word</dfn> is a word that has one or more meanings in the SQL
19  * language itself.
20  * Some key words are <dfn>reserved words</dfn>, meaning they cannot be used as
21  * a regular identifier.
22  * The remaining key words are <dfn>non-reserved</dfn>.
23  *
24  * @author <a HREF="mailto:mmartin5@austin.rr.com">Mike Martin</a>
25  * @version $Revision: 1.1 $
26  *
27  * @see DatabaseAdapter
28  */

29
30 public interface SQL92Constants
31 {
32     /**
33      * The maximum length of a SQL/92 identifier in characters.
34      */

35     public static final int MAX_IDENTIFIER_LENGTH = 128;
36
37
38     /**
39      * A string containing the list of SQL/92 <dfn>reserved words</dfn>,
40      * separated by commas.
41      */

42
43     public static final String JavaDoc RESERVED_WORDS =
44         "ABSOLUTE,ACTION,ADD,ALL,ALLOCATE,ALTER,AND," +
45         "ANY,ARE,AS,ASC," +
46         "ASSERTION,AT,AUTHORIZATION,AVG," +
47         "BEGIN,BETWEEN,BIT,BIT_LENGTH,BOTH,BY," +
48         "CASCADE,CASCADED,CASE,CAST,CATALOG,CHAR,CHARACTER,CHAR_LENGTH," +
49         "CHARACTER_LENGTH,CHECK,CLOSE,COALESCE,COLLATE,COLLATION," +
50         "COLUMN,COMMIT,CONNECT,CONNECTION,CONSTRAINT," +
51         "CONSTRAINTS,CONTINUE," +
52         "CONVERT,CORRESPONDING,COUNT,CREATE,CROSS,CURRENT," +
53         "CURRENT_DATE,CURRENT_TIME,CURRENT_TIMESTAMP,CURRENT_USER,CURSOR," +
54         "DATE,DAY,DEALLOCATE,DEC,DECIMAL,DECLARE,DEFAULT,DEFERRABLE," +
55         "DEFERRED,DELETE,DESC,DESCRIBE,DESCRIPTOR,DIAGNOSTICS," +
56         "DISCONNECT,DISTINCT,DOMAIN,DOUBLE,DROP," +
57         "ELSE,END,END-EXEC,ESCAPE,EXCEPT,EXCEPTION," +
58         "EXEC,EXECUTE,EXISTS," +
59         "EXTERNAL,EXTRACT," +
60         "FALSE,FETCH,FIRST,FLOAT,FOR,FOREIGN,FOUND,FROM,FULL," +
61         "GET,GLOBAL,GO,GOTO,GRANT,GROUP," +
62         "HAVING,HOUR," +
63         "IDENTITY,IMMEDIATE,IN,INDICATOR,INITIALLY,INNER,INPUT," +
64         "INSENSITIVE,INSERT,INT,INTEGER,INTERSECT,INTERVAL,INTO,IS," +
65         "ISOLATION," +
66         "JOIN," +
67         "KEY," +
68         "LANGUAGE,LAST,LEADING,LEFT,LEVEL,LIKE,LOCAL,LOWER," +
69         "MATCH,MAX,MIN,MINUTE,MODULE,MONTH," +
70         "NAMES,NATIONAL,NATURAL,NCHAR,NEXT,NO,NOT,NULL," +
71         "NULLIF,NUMERIC," +
72         "OCTET_LENGTH,OF,ON,ONLY,OPEN,OPTION,OR," +
73         "ORDER,OUTER," +
74         "OUTPUT,OVERLAPS," +
75         "PAD,PARTIAL,POSITION,PRECISION,PREPARE,PRESERVE,PRIMARY," +
76         "PRIOR,PRIVILEGES,PROCEDURE,PUBLIC," +
77         "READ,REAL,REFERENCES,RELATIVE,RESTRICT,REVOKE,RIGHT," +
78         "ROLLBACK,ROWS," +
79         "SCHEMA,SCROLL,SECOND,SECTION,SELECT,SESSION,SESSION_USER,SET," +
80         "SIZE,SMALLINT,SOME,SPACE,SQL,SQLCODE,SQLERROR,SQLSTATE," +
81         "SUBSTRING,SUM,SYSTEM_USER," +
82         "TABLE,TEMPORARY,THEN,TIME,TIMESTAMP,TIMEZONE_HOUR,TIMEZONE_MINUTE," +
83         "TO,TRAILING,TRANSACTION,TRANSLATE,TRANSLATION,TRIM,TRUE," +
84         "UNION,UNIQUE,UNKNOWN,UPDATE,UPPER,USAGE,USER,USING," +
85         "VALUE,VALUES,VARCHAR,VARYING,VIEW," +
86         "WHEN,WHENEVER,WHERE,WITH,WORK,WRITE," +
87         "YEAR," +
88         "ZONE";
89
90     /**
91      * A string containing the list of SQL/92 <dfn>non-reserved words</dfn>,
92      * separated by commas.
93      */

94
95     public static final String JavaDoc NONRESERVED_WORDS =
96         "ADA," +
97         "C,CATALOG_NAME,CHARACTER_SET_CATALOG,CHARACTER_SET_NAME," +
98         "CHARACTER_SET_SCHEMA,CLASS_ORIGIN,COBOL,COLLATION_CATALOG," +
99         "COLLATION_NAME,COLLATION_SCHEMA,COLUMN_NAME,COMMAND_FUNCTION,COMMITTED," +
100         "CONDITION_NUMBER,CONNECTION_NAME,CONSTRAINT_CATALOG,CONSTRAINT_NAME," +
101         "CONSTRAINT_SCHEMA,CURSOR_NAME," +
102         "DATA,DATETIME_INTERVAL_CODE,DATETIME_INTERVAL_PRECISION,DYNAMIC_FUNCTION," +
103         "FORTRAN," +
104         "LENGTH," +
105         "MESSAGE_LENGTH,MESSAGE_OCTET_LENGTH,MESSAGE_TEXT,MORE,MUMPS," +
106         "NAME,NULLABLE,NUMBER," +
107         "PASCAL,PLI," +
108         "REPEATABLE,RETURNED_LENGTH,RETURNED_OCTET_LENGTH,RETURNED_SQLSTATE," +
109         "ROW_COUNT," +
110         "SCALE,SCHEMA_NAME,SERIALIZABLE,SERVER_NAME,SUBCLASS_ORIGIN," +
111         "TABLE_NAME,TYPE," +
112         "UNCOMMITTED,UNNAMED";
113 }
114
Popular Tags