home *** CD-ROM | disk | FTP | other *** search
/ PC Professionell 2004 December / PCpro_2004_12.ISO / files / webserver / tsw / TSW_3.4.0.exe / Apache2 / perl / ANSI.pm < prev    next >
Encoding:
Perl POD Document  |  2002-01-17  |  2.7 KB  |  309 lines

  1. package SQL::Dialects::ANSI;
  2.  
  3. =pod
  4.  
  5. =head1 NAME
  6.  
  7.  SQL::Dialects::ANSI -- ANSI config file for SQL::Parse
  8.  
  9. =head1 SYNOPSIS
  10.  
  11.   see SQL::Parse, SQL::Squish
  12.  
  13. =head1 DESCRIPTION
  14.  
  15.  The makemaker police say i gotta have one of these
  16.  
  17. =cut
  18.  
  19. sub get_config {
  20. return <<EOC;
  21. [VALID COMMANDS]
  22. CREATE
  23. DROP
  24. SELECT
  25. DELETE
  26. INSERT
  27. UPDATE
  28.  
  29. [VALID OPTIONS]
  30. SELECT_MULTIPLE_TABLES
  31. SELECT_AGGREGATE_FUNCTIONS
  32.  
  33. [VALID COMPARISON OPERATORS]
  34. =
  35. <>
  36. <
  37. <=
  38. >
  39. >=
  40. LIKE
  41. NOT LIKE
  42. IS
  43. IS NOT
  44. IN
  45. NOT IN
  46. BETWEEN
  47. NOT BETWEEN
  48.  
  49. [VALID DATA TYPES]
  50. CHARACTER
  51. CHAR
  52. CHARACTER VARYING
  53. CHAR VARYING
  54. VARCHAR
  55. CHARACTER SET
  56. NATIONAL CHARACTER
  57. NATIONAL CHAR
  58. NCHAR
  59. NATIONAL CHARACTER VARYING
  60. NATIONAL CHAR VARYING
  61. NCHAR VARYING
  62. BIT
  63. BIT VARYING
  64. NUMERIC
  65. DECIMAL
  66. DEC
  67. INTEGER
  68. INT
  69. SMALLINT
  70. FLOAT
  71. REAL
  72. DOUBLE PRECISION
  73. DATE
  74. TIME
  75. TIMESTAMP
  76. INTERVAL
  77.  
  78. [RESERVED WORDS]
  79. ABSOLUTE
  80. ACTION
  81. ADD
  82. ALL
  83. ALLOCATE
  84. ALTER
  85. AND
  86. ANY
  87. ARE
  88. AS
  89. ASC
  90. ASSERTION
  91. AT
  92. AUTHORIZATION
  93. AVG
  94. BEGIN
  95. BETWEEN
  96. BIT
  97. BIT_LENGTH
  98. BOTH
  99. BY
  100. CASCADE
  101. CASCADED
  102. CASE
  103. CAST
  104. CATALOG
  105. CHAR
  106. CHARACTER
  107. CHAR_LENGTH
  108. CHARACTER_LENGTH
  109. CHECK
  110. CLOSE
  111. COALESCE
  112. COLLATE
  113. COLLATION
  114. COLUMN
  115. COMMIT
  116. CONNECT
  117. CONNECTION
  118. CONSTRAINT
  119. CONSTRAINTS
  120. CONTINUE
  121. CONVERT
  122. CORRESPONDING
  123. COUNT
  124. CREATE
  125. CROSS
  126. CURRENT
  127. CURRENT_DATE
  128. CURRENT_TIME
  129. CURRENT_TIMESTAMP
  130. CURRENT_USER
  131. CURSOR
  132. DATE
  133. DAY
  134. DEALLOCATE
  135. DEC
  136. DECIMAL
  137. DECLARE
  138. DEFAULT
  139. DEFERRABLE
  140. DEFERRED
  141. DELETE
  142. DESC
  143. DESCRIBE
  144. DESCRIPTOR
  145. DIAGNOSTICS
  146. DISCONNECT
  147. DISTINCT
  148. DOMAIN
  149. DOUBLE
  150. DROP
  151. ELSE
  152. END
  153. END-EXEC
  154. ESCAPE
  155. EXCEPT
  156. EXCEPTION
  157. EXEC
  158. EXECUTE
  159. EXISTS
  160. EXTERNAL
  161. EXTRACT
  162. FALSE
  163. FETCH
  164. FIRST
  165. FLOAT
  166. FOR
  167. FOREIGN
  168. FOUND
  169. FROM
  170. FULL
  171. GET
  172. GLOBAL
  173. GO
  174. GOTO
  175. GRANT
  176. GROUP
  177. HAVING
  178. HOUR
  179. IDENTITY
  180. IMMEDIATE
  181. IN
  182. INDICATOR
  183. INITIALLY
  184. INNER
  185. INPUT
  186. INSENSITIVE
  187. INSERT
  188. INT
  189. INTEGER
  190. INTERSECT
  191. INTERVAL
  192. INTO
  193. IS
  194. ISOLATION
  195. JOIN
  196. KEY
  197. LANGUAGE
  198. LAST
  199. LEADING
  200. LEFT
  201. LEVEL
  202. LIKE
  203. LOCAL
  204. LOWER
  205. MATCH
  206. MAX
  207. MIN
  208. MINUTE
  209. MODULE
  210. MONTH
  211. NAMES
  212. NATIONAL
  213. NATURAL
  214. NCHAR
  215. NEXT
  216. NO
  217. NOT
  218. NULL
  219. NULLIF
  220. NUMERIC
  221. OCTET_LENGTH
  222. OF
  223. ON
  224. ONLY
  225. OPEN
  226. OPTION
  227. OR
  228. ORDER
  229. OUTER
  230. OUTPUT
  231. OVERLAPS
  232. PAD
  233. PARTIAL
  234. POSITION
  235. PRECISION
  236. PREPARE
  237. PRESERVE
  238. PRIMARY
  239. PRIOR
  240. PRIVILEGES
  241. PROCEDURE
  242. PUBLIC
  243. READ
  244. REAL
  245. REFERENCES
  246. RELATIVE
  247. RESTRICT
  248. REVOKE
  249. RIGHT
  250. ROLLBACK
  251. ROWS
  252. SCHEMA
  253. SCROLL
  254. SECOND
  255. SECTION
  256. SELECT
  257. SESSION
  258. SESSION_USER
  259. SET
  260. SIZE
  261. SMALLINT
  262. SOME
  263. SPACE
  264. SQL
  265. SQLCODE
  266. SQLERROR
  267. SQLSTATE
  268. SUBSTRING
  269. SUM
  270. SYSTEM_USER
  271. TABLE
  272. TEMPORARY
  273. THEN
  274. TIME
  275. TIMESTAMP
  276. TIMEZONE_HOUR
  277. TIMEZONE_MINUTE
  278. TO
  279. TRAILING
  280. TRANSACTION
  281. TRANSLATE
  282. TRANSLATION
  283. TRIM
  284. TRUE
  285. UNION
  286. UNIQUE
  287. UNKNOWN
  288. UPDATE
  289. UPPER
  290. USAGE
  291. USER
  292. USING
  293. VALUE
  294. VALUES
  295. VARCHAR
  296. VARYING
  297. VIEW
  298. WHEN
  299. WHENEVER
  300. WHERE
  301. WITH
  302. WORK
  303. WRITE
  304. YEAR
  305. ZONE
  306. EOC
  307. }
  308. 1;
  309.