home *** CD-ROM | disk | FTP | other *** search
- package SQL::Dialects::ANSI;
-
- =pod
-
- =head1 NAME
-
- SQL::Dialects::ANSI -- ANSI config file for SQL::Parse
-
- =head1 SYNOPSIS
-
- see SQL::Parse, SQL::Squish
-
- =head1 DESCRIPTION
-
- The makemaker police say i gotta have one of these
-
- =cut
-
- sub get_config {
- return <<EOC;
- [VALID COMMANDS]
- CREATE
- DROP
- SELECT
- DELETE
- INSERT
- UPDATE
-
- [VALID OPTIONS]
- SELECT_MULTIPLE_TABLES
- SELECT_AGGREGATE_FUNCTIONS
-
- [VALID COMPARISON OPERATORS]
- =
- <>
- <
- <=
- >
- >=
- LIKE
- NOT LIKE
- IS
- IS NOT
- IN
- NOT IN
- BETWEEN
- NOT BETWEEN
-
- [VALID DATA TYPES]
- CHARACTER
- CHAR
- CHARACTER VARYING
- CHAR VARYING
- VARCHAR
- CHARACTER SET
- NATIONAL CHARACTER
- NATIONAL CHAR
- NCHAR
- NATIONAL CHARACTER VARYING
- NATIONAL CHAR VARYING
- NCHAR VARYING
- BIT
- BIT VARYING
- NUMERIC
- DECIMAL
- DEC
- INTEGER
- INT
- SMALLINT
- FLOAT
- REAL
- DOUBLE PRECISION
- DATE
- TIME
- TIMESTAMP
- INTERVAL
-
- [RESERVED WORDS]
- ABSOLUTE
- ACTION
- ADD
- ALL
- ALLOCATE
- ALTER
- AND
- ANY
- ARE
- AS
- ASC
- ASSERTION
- AT
- AUTHORIZATION
- AVG
- BEGIN
- BETWEEN
- BIT
- BIT_LENGTH
- BOTH
- BY
- CASCADE
- CASCADED
- CASE
- CAST
- CATALOG
- CHAR
- CHARACTER
- CHAR_LENGTH
- CHARACTER_LENGTH
- CHECK
- CLOSE
- COALESCE
- COLLATE
- COLLATION
- COLUMN
- COMMIT
- CONNECT
- CONNECTION
- CONSTRAINT
- CONSTRAINTS
- CONTINUE
- CONVERT
- CORRESPONDING
- COUNT
- CREATE
- CROSS
- CURRENT
- CURRENT_DATE
- CURRENT_TIME
- CURRENT_TIMESTAMP
- CURRENT_USER
- CURSOR
- DATE
- DAY
- DEALLOCATE
- DEC
- DECIMAL
- DECLARE
- DEFAULT
- DEFERRABLE
- DEFERRED
- DELETE
- DESC
- DESCRIBE
- DESCRIPTOR
- DIAGNOSTICS
- DISCONNECT
- DISTINCT
- DOMAIN
- DOUBLE
- DROP
- ELSE
- END
- END-EXEC
- ESCAPE
- EXCEPT
- EXCEPTION
- EXEC
- EXECUTE
- EXISTS
- EXTERNAL
- EXTRACT
- FALSE
- FETCH
- FIRST
- FLOAT
- FOR
- FOREIGN
- FOUND
- FROM
- FULL
- GET
- GLOBAL
- GO
- GOTO
- GRANT
- GROUP
- HAVING
- HOUR
- IDENTITY
- IMMEDIATE
- IN
- INDICATOR
- INITIALLY
- INNER
- INPUT
- INSENSITIVE
- INSERT
- INT
- INTEGER
- INTERSECT
- INTERVAL
- INTO
- IS
- ISOLATION
- JOIN
- KEY
- LANGUAGE
- LAST
- LEADING
- LEFT
- LEVEL
- LIKE
- LOCAL
- LOWER
- MATCH
- MAX
- MIN
- MINUTE
- MODULE
- MONTH
- NAMES
- NATIONAL
- NATURAL
- NCHAR
- NEXT
- NO
- NOT
- NULL
- NULLIF
- NUMERIC
- OCTET_LENGTH
- OF
- ON
- ONLY
- OPEN
- OPTION
- OR
- ORDER
- OUTER
- OUTPUT
- OVERLAPS
- PAD
- PARTIAL
- POSITION
- PRECISION
- PREPARE
- PRESERVE
- PRIMARY
- PRIOR
- PRIVILEGES
- PROCEDURE
- PUBLIC
- READ
- REAL
- REFERENCES
- RELATIVE
- RESTRICT
- REVOKE
- RIGHT
- ROLLBACK
- ROWS
- SCHEMA
- SCROLL
- SECOND
- SECTION
- SELECT
- SESSION
- SESSION_USER
- SET
- SIZE
- SMALLINT
- SOME
- SPACE
- SQL
- SQLCODE
- SQLERROR
- SQLSTATE
- SUBSTRING
- SUM
- SYSTEM_USER
- TABLE
- TEMPORARY
- THEN
- TIME
- TIMESTAMP
- TIMEZONE_HOUR
- TIMEZONE_MINUTE
- TO
- TRAILING
- TRANSACTION
- TRANSLATE
- TRANSLATION
- TRIM
- TRUE
- UNION
- UNIQUE
- UNKNOWN
- UPDATE
- UPPER
- USAGE
- USER
- USING
- VALUE
- VALUES
- VARCHAR
- VARYING
- VIEW
- WHEN
- WHENEVER
- WHERE
- WITH
- WORK
- WRITE
- YEAR
- ZONE
- EOC
- }
- 1;
-