Hello community,
here is the log from the commit of package perl-SQL-ReservedWords for openSUSE:Factory checked in at 2013-06-21 13:32:46
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Comparing /work/SRC/openSUSE:Factory/perl-SQL-ReservedWords (Old)
and /work/SRC/openSUSE:Factory/.perl-SQL-ReservedWords.new (New)
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Package is "perl-SQL-ReservedWords"
Changes:
--------
--- /work/SRC/openSUSE:Factory/perl-SQL-ReservedWords/perl-SQL-ReservedWords.changes 2011-11-14 13:26:01.000000000 +0100
+++ /work/SRC/openSUSE:Factory/.perl-SQL-ReservedWords.new/perl-SQL-ReservedWords.changes 2013-06-21 13:37:14.000000000 +0200
@@ -1,0 +2,7 @@
+Tue Jun 4 17:22:54 UTC 2013 - coolo@suse.com
+
+- updated to 0.8
+ - Added DB2 version 9 (Colin.Raybould@googlemail.com) RT#55070
+ - Fixed sqlrw command (olaf@wundersolutions.com) RT#28367
+
+-------------------------------------------------------------------
Old:
----
SQL-ReservedWords-0.7.tar.gz
New:
----
SQL-ReservedWords-0.8.tar.gz
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Other differences:
------------------
++++++ perl-SQL-ReservedWords.spec ++++++
--- /var/tmp/diff_new_pack.cd0YSn/_old 2013-06-21 13:37:15.000000000 +0200
+++ /var/tmp/diff_new_pack.cd0YSn/_new 2013-06-21 13:37:15.000000000 +0200
@@ -1,7 +1,7 @@
#
# spec file for package perl-SQL-ReservedWords
#
-# Copyright (c) 2011 SUSE LINUX Products GmbH, Nuernberg, Germany.
+# Copyright (c) 2013 SUSE LINUX Products GmbH, Nuernberg, Germany.
#
# All modifications and additions to the file contributed by third parties
# remain the property of their copyright owners, unless otherwise agreed
@@ -16,21 +16,20 @@
#
-
Name: perl-SQL-ReservedWords
-Version: 0.7
-Release: 1
-License: GPL-1.0+ or Artistic-1.0
+Version: 0.8
+Release: 0
%define cpan_name SQL-ReservedWords
Summary: Reserved SQL words by ANSI/ISO
-Url: http://search.cpan.org/dist/SQL-ReservedWords/
+License: Artistic-1.0 or GPL-1.0+
Group: Development/Libraries/Perl
+Url: http://search.cpan.org/dist/SQL-ReservedWords/
Source: http://www.cpan.org/authors/id/C/CH/CHANSEN/%{cpan_name}-%{version}.tar.gz
BuildArch: noarch
BuildRoot: %{_tmppath}/%{name}-%{version}-build
BuildRequires: perl
BuildRequires: perl-macros
-BuildRequires: perl(Module::Build)
+BuildRequires: perl(Module::Build) >= 0.4000
BuildRequires: perl(Sub::Exporter)
Requires: perl(Sub::Exporter)
%{perl_requires}
@@ -54,6 +53,6 @@
%files -f %{name}.files
%defattr(-,root,root,755)
-%doc Changes README
+%doc Changes README scripts
%changelog
++++++ SQL-ReservedWords-0.7.tar.gz -> SQL-ReservedWords-0.8.tar.gz ++++++
diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn' '--exclude=.svnignore' old/SQL-ReservedWords-0.7/Changes new/SQL-ReservedWords-0.8/Changes
--- old/SQL-ReservedWords-0.7/Changes 2006-03-24 20:49:06.000000000 +0100
+++ new/SQL-ReservedWords-0.8/Changes 2012-08-30 14:37:19.000000000 +0200
@@ -1,5 +1,9 @@
Revision history for Perl extension SQL::ReservedWords
+0.8 2012-08-30 00:00
+ - Added DB2 version 9 (Colin.Raybould@googlemail.com) RT#55070
+ - Fixed sqlrw command (olaf@wundersolutions.com) RT#28367
+
0.7 2006-03-24 00:00
- Added SQL::ReservedWords::Sybase
diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn' '--exclude=.svnignore' old/SQL-ReservedWords-0.7/MANIFEST new/SQL-ReservedWords-0.8/MANIFEST
--- old/SQL-ReservedWords-0.7/MANIFEST 2006-03-24 20:49:06.000000000 +0100
+++ new/SQL-ReservedWords-0.8/MANIFEST 2012-08-30 14:37:19.000000000 +0200
@@ -22,6 +22,7 @@
t/10-sqlite.t
t/11-sqlserver.t
t/12-sybase.t
-META.yml
Makefile.PL
README
+META.yml
+META.json
diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn' '--exclude=.svnignore' old/SQL-ReservedWords-0.7/META.json new/SQL-ReservedWords-0.8/META.json
--- old/SQL-ReservedWords-0.7/META.json 1970-01-01 01:00:00.000000000 +0100
+++ new/SQL-ReservedWords-0.8/META.json 2012-08-30 14:37:19.000000000 +0200
@@ -0,0 +1,78 @@
+{
+ "abstract" : "Reserved SQL words by ANSI/ISO",
+ "author" : [
+ "Christian Hansen C"
+ ],
+ "dynamic_config" : 1,
+ "generated_by" : "Module::Build version 0.4, CPAN::Meta::Converter version 2.113640",
+ "license" : [
+ "perl_5"
+ ],
+ "meta-spec" : {
+ "url" : "http://search.cpan.org/perldoc?CPAN::Meta::Spec",
+ "version" : "2"
+ },
+ "name" : "SQL-ReservedWords",
+ "prereqs" : {
+ "build" : {
+ "requires" : {
+ "Test::More" : 0
+ }
+ },
+ "configure" : {
+ "requires" : {
+ "Module::Build" : "0.4"
+ }
+ },
+ "runtime" : {
+ "requires" : {
+ "Sub::Exporter" : 0
+ }
+ }
+ },
+ "provides" : {
+ "SQL::ReservedWords" : {
+ "file" : "lib/SQL/ReservedWords.pm",
+ "version" : "0.8"
+ },
+ "SQL::ReservedWords::DB2" : {
+ "file" : "lib/SQL/ReservedWords/DB2.pm",
+ "version" : "0.8"
+ },
+ "SQL::ReservedWords::MySQL" : {
+ "file" : "lib/SQL/ReservedWords/MySQL.pm",
+ "version" : "0.8"
+ },
+ "SQL::ReservedWords::ODBC" : {
+ "file" : "lib/SQL/ReservedWords/ODBC.pm",
+ "version" : "0.8"
+ },
+ "SQL::ReservedWords::Oracle" : {
+ "file" : "lib/SQL/ReservedWords/Oracle.pm",
+ "version" : "0.8"
+ },
+ "SQL::ReservedWords::PostgreSQL" : {
+ "file" : "lib/SQL/ReservedWords/PostgreSQL.pm",
+ "version" : "0.8"
+ },
+ "SQL::ReservedWords::SQLServer" : {
+ "file" : "lib/SQL/ReservedWords/SQLServer.pm",
+ "version" : "0.8"
+ },
+ "SQL::ReservedWords::SQLite" : {
+ "file" : "lib/SQL/ReservedWords/SQLite.pm",
+ "version" : "0.8"
+ },
+ "SQL::ReservedWords::Sybase" : {
+ "file" : "lib/SQL/ReservedWords/Sybase.pm",
+ "version" : "0.8"
+ }
+ },
+ "release_status" : "stable",
+ "resources" : {
+ "license" : [
+ "http://dev.perl.org/licenses/"
+ ]
+ },
+ "version" : "0.8"
+}
diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn' '--exclude=.svnignore' old/SQL-ReservedWords-0.7/META.yml new/SQL-ReservedWords-0.8/META.yml
--- old/SQL-ReservedWords-0.7/META.yml 2006-03-24 20:49:06.000000000 +0100
+++ new/SQL-ReservedWords-0.8/META.yml 2012-08-30 14:37:19.000000000 +0200
@@ -1,40 +1,48 @@
---
-name: SQL-ReservedWords
-version: 0.7
+abstract: 'Reserved SQL words by ANSI/ISO'
author:
- 'Christian Hansen C'
-abstract: Reserved SQL words by ANSI/ISO
-license: perl
-requires:
- Sub::Exporter: 0
build_requires:
Test::More: 0
+configure_requires:
+ Module::Build: 0.4
+dynamic_config: 1
+generated_by: 'Module::Build version 0.4, CPAN::Meta::Converter version 2.113640'
+license: perl
+meta-spec:
+ url: http://module-build.sourceforge.net/META-spec-v1.4.html
+ version: 1.4
+name: SQL-ReservedWords
provides:
SQL::ReservedWords:
file: lib/SQL/ReservedWords.pm
- version: 0.7
+ version: 0.8
SQL::ReservedWords::DB2:
file: lib/SQL/ReservedWords/DB2.pm
- version: 0.7
+ version: 0.8
SQL::ReservedWords::MySQL:
file: lib/SQL/ReservedWords/MySQL.pm
- version: 0.7
+ version: 0.8
SQL::ReservedWords::ODBC:
file: lib/SQL/ReservedWords/ODBC.pm
- version: 0.7
+ version: 0.8
SQL::ReservedWords::Oracle:
file: lib/SQL/ReservedWords/Oracle.pm
- version: 0.7
+ version: 0.8
SQL::ReservedWords::PostgreSQL:
file: lib/SQL/ReservedWords/PostgreSQL.pm
- version: 0.7
+ version: 0.8
SQL::ReservedWords::SQLServer:
file: lib/SQL/ReservedWords/SQLServer.pm
- version: 0.7
+ version: 0.8
SQL::ReservedWords::SQLite:
file: lib/SQL/ReservedWords/SQLite.pm
- version: 0.7
+ version: 0.8
SQL::ReservedWords::Sybase:
file: lib/SQL/ReservedWords/Sybase.pm
- version: 0.7
-generated_by: Module::Build version 0.2611
+ version: 0.8
+requires:
+ Sub::Exporter: 0
+resources:
+ license: http://dev.perl.org/licenses/
+version: 0.8
diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn' '--exclude=.svnignore' old/SQL-ReservedWords-0.7/Makefile.PL new/SQL-ReservedWords-0.8/Makefile.PL
--- old/SQL-ReservedWords-0.7/Makefile.PL 2006-03-24 20:49:06.000000000 +0100
+++ new/SQL-ReservedWords-0.8/Makefile.PL 2012-08-30 14:37:19.000000000 +0200
@@ -1,17 +1,17 @@
-# Note: this file was auto-generated by Module::Build::Compat version 0.03
+# Note: this file was auto-generated by Module::Build::Compat version 0.40
use ExtUtils::MakeMaker;
WriteMakefile
(
- 'NAME' => 'SQL::ReservedWords',
- 'VERSION_FROM' => 'lib/SQL/ReservedWords.pm',
- 'PREREQ_PM' => {
- 'Sub::Exporter' => '0',
- 'Test::More' => '0'
- },
- 'INSTALLDIRS' => 'site',
- 'EXE_FILES' => [
- 'scripts/sqlrw'
- ],
- 'PL_FILES' => {}
- )
+ 'NAME' => 'SQL::ReservedWords',
+ 'VERSION_FROM' => 'lib/SQL/ReservedWords.pm',
+ 'PREREQ_PM' => {
+ 'Sub::Exporter' => 0,
+ 'Test::More' => 0
+ },
+ 'INSTALLDIRS' => 'site',
+ 'EXE_FILES' => [
+ 'scripts/sqlrw'
+ ],
+ 'PL_FILES' => {}
+)
;
diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn' '--exclude=.svnignore' old/SQL-ReservedWords-0.7/lib/SQL/ReservedWords/DB2.pm new/SQL-ReservedWords-0.8/lib/SQL/ReservedWords/DB2.pm
--- old/SQL-ReservedWords-0.7/lib/SQL/ReservedWords/DB2.pm 2006-03-24 20:49:06.000000000 +0100
+++ new/SQL-ReservedWords-0.8/lib/SQL/ReservedWords/DB2.pm 2012-08-30 14:37:19.000000000 +0200
@@ -4,12 +4,13 @@
use warnings;
use vars '$VERSION';
-$VERSION = 0.7;
+$VERSION = '0.8';
use constant DB2V5 => 0x01;
use constant DB2V6 => 0x02;
use constant DB2V7 => 0x04;
use constant DB2V8 => 0x08;
+use constant DB2V9 => 0x10;
{
require Sub::Exporter;
@@ -20,6 +21,7 @@
is_reserved_by_db2v6
is_reserved_by_db2v7
is_reserved_by_db2v8
+ is_reserved_by_db2v9
reserved_by
words
];
@@ -29,274 +31,407 @@
{
my %WORDS = (
- ADD => DB2V5 | DB2V6 | DB2V7 | DB2V8,
- AFTER => DB2V6 | DB2V7 | DB2V8,
- ALL => DB2V5 | DB2V6 | DB2V7 | DB2V8,
- ALLOCATE => DB2V5 | DB2V6 | DB2V7 | DB2V8,
- ALLOW => DB2V6 | DB2V7 | DB2V8,
- ALTER => DB2V5 | DB2V6 | DB2V7 | DB2V8,
- AND => DB2V5 | DB2V6 | DB2V7 | DB2V8,
- ANY => DB2V5 | DB2V6 | DB2V7 | DB2V8,
- AS => DB2V5 | DB2V6 | DB2V7 | DB2V8,
- ASENSITIVE => DB2V8,
- ASSOCIATE => DB2V5 | DB2V6 | DB2V7 | DB2V8,
- ASUTIME => DB2V6 | DB2V7 | DB2V8,
- AUDIT => DB2V5 | DB2V6 | DB2V7 | DB2V8,
- AUX => DB2V6 | DB2V7 | DB2V8,
- AUXILIARY => DB2V6 | DB2V7 | DB2V8,
- BEFORE => DB2V6 | DB2V7 | DB2V8,
- BEGIN => DB2V6 | DB2V7 | DB2V8,
- BETWEEN => DB2V5 | DB2V6 | DB2V7 | DB2V8,
- BUFFERPOOL => DB2V5 | DB2V6 | DB2V7 | DB2V8,
- BY => DB2V5 | DB2V6 | DB2V7 | DB2V8,
- CALL => DB2V5 | DB2V6 | DB2V7 | DB2V8,
- CAPTURE => DB2V5 | DB2V6 | DB2V7 | DB2V8,
- CASCADED => DB2V5 | DB2V6 | DB2V7 | DB2V8,
- CASE => DB2V5 | DB2V6 | DB2V7 | DB2V8,
- CAST => DB2V6 | DB2V7 | DB2V8,
- CCSID => DB2V5 | DB2V6 | DB2V7 | DB2V8,
- CHAR => DB2V5 | DB2V6 | DB2V7 | DB2V8,
- CHARACTER => DB2V5 | DB2V6 | DB2V7 | DB2V8,
- CHECK => DB2V5 | DB2V6 | DB2V7 | DB2V8,
- CLOSE => DB2V6 | DB2V7 | DB2V8,
- CLUSTER => DB2V5 | DB2V6 | DB2V7 | DB2V8,
- COLLECTION => DB2V5 | DB2V6 | DB2V7 | DB2V8,
- COLLID => DB2V6 | DB2V7 | DB2V8,
- COLUMN => DB2V5 | DB2V6 | DB2V7 | DB2V8,
- COMMENT => DB2V6 | DB2V7 | DB2V8,
- COMMIT => DB2V6 | DB2V7 | DB2V8,
- CONCAT => DB2V5 | DB2V6 | DB2V7 | DB2V8,
- CONDITION => DB2V5 | DB2V6 | DB2V7 | DB2V8,
- CONNECT => DB2V6 | DB2V7 | DB2V8,
- CONNECTION => DB2V6 | DB2V7 | DB2V8,
- CONSTRAINT => DB2V5 | DB2V6 | DB2V7 | DB2V8,
- CONTAINS => DB2V6 | DB2V7 | DB2V8,
- CONTINUE => DB2V5 | DB2V6 | DB2V7 | DB2V8,
- COUNT => DB2V5,
- CREATE => DB2V6 | DB2V7 | DB2V8,
- CURRENT => DB2V5 | DB2V6 | DB2V7 | DB2V8,
- CURRENT_DATE => DB2V5 | DB2V6 | DB2V7 | DB2V8,
- CURRENT_LC_CTYPE => DB2V6 | DB2V7 | DB2V8,
- CURRENT_PATH => DB2V6 | DB2V7 | DB2V8,
- CURRENT_TIME => DB2V5 | DB2V6 | DB2V7 | DB2V8,
- CURRENT_TIMESTAMP => DB2V5 | DB2V6 | DB2V7 | DB2V8,
- CURSOR => DB2V5 | DB2V6 | DB2V7 | DB2V8,
- DATA => DB2V6 | DB2V7 | DB2V8,
- DATABASE => DB2V5 | DB2V6 | DB2V7 | DB2V8,
- DAY => DB2V5 | DB2V6 | DB2V7 | DB2V8,
- DAYS => DB2V5 | DB2V6 | DB2V7 | DB2V8,
- DB2SQL => DB2V6 | DB2V7,
- DBINFO => DB2V6 | DB2V7 | DB2V8,
- DECLARE => DB2V6 | DB2V7 | DB2V8,
- DEFAULT => DB2V5 | DB2V6 | DB2V7 | DB2V8,
- DELETE => DB2V5 | DB2V6 | DB2V7 | DB2V8,
- DESCRIPTOR => DB2V5 | DB2V6 | DB2V7 | DB2V8,
- DETERMINISTIC => DB2V6 | DB2V7 | DB2V8,
- DISALLOW => DB2V6 | DB2V7 | DB2V8,
- DISTINCT => DB2V5 | DB2V6 | DB2V7 | DB2V8,
- DO => DB2V5 | DB2V6 | DB2V7 | DB2V8,
- DOUBLE => DB2V5 | DB2V6 | DB2V7 | DB2V8,
- DROP => DB2V5 | DB2V6 | DB2V7 | DB2V8,
+ ACTIVATE => DB2V9,
+ ADD => DB2V5 | DB2V6 | DB2V7 | DB2V8 | DB2V9,
+ AFTER => DB2V6 | DB2V7 | DB2V8 | DB2V9,
+ ALIAS => DB2V9,
+ ALL => DB2V5 | DB2V6 | DB2V7 | DB2V8 | DB2V9,
+ ALLOCATE => DB2V5 | DB2V6 | DB2V7 | DB2V8 | DB2V9,
+ ALLOW => DB2V6 | DB2V7 | DB2V8 | DB2V9,
+ ALTER => DB2V5 | DB2V6 | DB2V7 | DB2V8 | DB2V9,
+ AND => DB2V5 | DB2V6 | DB2V7 | DB2V8 | DB2V9,
+ ANY => DB2V5 | DB2V6 | DB2V7 | DB2V8 | DB2V9,
+ AS => DB2V5 | DB2V6 | DB2V7 | DB2V8 | DB2V9,
+ ASENSITIVE => DB2V8 | DB2V9,
+ ASSOCIATE => DB2V5 | DB2V6 | DB2V7 | DB2V8 | DB2V9,
+ ASUTIME => DB2V6 | DB2V7 | DB2V8 | DB2V9,
+ AT => DB2V9,
+ ATTRIBUTES => DB2V9,
+ AUDIT => DB2V5 | DB2V6 | DB2V7 | DB2V8 | DB2V9,
+ AUTHORIZATION => DB2V9,
+ AUX => DB2V6 | DB2V7 | DB2V8 | DB2V9,
+ AUXILIARY => DB2V6 | DB2V7 | DB2V8 | DB2V9,
+ BEFORE => DB2V6 | DB2V7 | DB2V8 | DB2V9,
+ BEGIN => DB2V6 | DB2V7 | DB2V8 | DB2V9,
+ BETWEEN => DB2V5 | DB2V6 | DB2V7 | DB2V8 | DB2V9,
+ BINARY => DB2V9,
+ BUFFERPOOL => DB2V5 | DB2V6 | DB2V7 | DB2V8 | DB2V9,
+ BY => DB2V5 | DB2V6 | DB2V7 | DB2V8 | DB2V9,
+ CACHE => DB2V9,
+ CALL => DB2V5 | DB2V6 | DB2V7 | DB2V8 | DB2V9,
+ CALLED => DB2V9,
+ CAPTURE => DB2V5 | DB2V6 | DB2V7 | DB2V8 | DB2V9,
+ CARDINALITY => DB2V9,
+ CASCADED => DB2V5 | DB2V6 | DB2V7 | DB2V8 | DB2V9,
+ CASE => DB2V5 | DB2V6 | DB2V7 | DB2V8 | DB2V9,
+ CAST => DB2V6 | DB2V7 | DB2V8 | DB2V9,
+ CCSID => DB2V5 | DB2V6 | DB2V7 | DB2V8 | DB2V9,
+ CHAR => DB2V5 | DB2V6 | DB2V7 | DB2V8 | DB2V9,
+ CHARACTER => DB2V5 | DB2V6 | DB2V7 | DB2V8 | DB2V9,
+ CHECK => DB2V5 | DB2V6 | DB2V7 | DB2V8 | DB2V9,
+ CLONE => DB2V9,
+ CLOSE => DB2V6 | DB2V7 | DB2V8 | DB2V9,
+ CLUSTER => DB2V5 | DB2V6 | DB2V7 | DB2V8 | DB2V9,
+ COLLECTION => DB2V5 | DB2V6 | DB2V7 | DB2V8 | DB2V9,
+ COLLID => DB2V6 | DB2V7 | DB2V8 | DB2V9,
+ COLUMN => DB2V5 | DB2V6 | DB2V7 | DB2V8 | DB2V9,
+ COMMENT => DB2V6 | DB2V7 | DB2V8 | DB2V9,
+ COMMIT => DB2V6 | DB2V7 | DB2V8 | DB2V9,
+ CONCAT => DB2V5 | DB2V6 | DB2V7 | DB2V8 | DB2V9,
+ CONDITION => DB2V5 | DB2V6 | DB2V7 | DB2V8 | DB2V9,
+ CONNECT => DB2V6 | DB2V7 | DB2V8 | DB2V9,
+ CONNECTION => DB2V6 | DB2V7 | DB2V8 | DB2V9,
+ CONSTRAINT => DB2V5 | DB2V6 | DB2V7 | DB2V8 | DB2V9,
+ CONTAINS => DB2V6 | DB2V7 | DB2V8 | DB2V9,
+ CONTINUE => DB2V5 | DB2V6 | DB2V7 | DB2V8 | DB2V9,
+ COUNT => DB2V5 | DB2V9,
+ COUNT_BIG => DB2V9,
+ CREATE => DB2V6 | DB2V7 | DB2V8 | DB2V9,
+ CROSS => DB2V9,
+ CURRENT => DB2V5 | DB2V6 | DB2V7 | DB2V8 | DB2V9,
+ CURRENT_DATE => DB2V5 | DB2V6 | DB2V7 | DB2V8 | DB2V9,
+ CURRENT_LC_CTYPE => DB2V6 | DB2V7 | DB2V8 | DB2V9,
+ CURRENT_PATH => DB2V6 | DB2V7 | DB2V8 | DB2V9,
+ CURRENT_SCHEMA => DB2V9,
+ CURRENT_SERVER => DB2V9,
+ CURRENT_TIME => DB2V5 | DB2V6 | DB2V7 | DB2V8 | DB2V9,
+ CURRENT_TIMESTAMP => DB2V5 | DB2V6 | DB2V7 | DB2V8 | DB2V9,
+ CURRENT_TIMEZONE => DB2V9,
+ CURRENT_USER => DB2V9,
+ CURSOR => DB2V5 | DB2V6 | DB2V7 | DB2V8 | DB2V9,
+ CYCLE => DB2V9,
+ DATA => DB2V6 | DB2V7 | DB2V8 | DB2V9,
+ DATABASE => DB2V5 | DB2V6 | DB2V7 | DB2V8 | DB2V9,
+ DATAPARTITIONNAME => DB2V9,
+ DATAPARTITIONNUM => DB2V9,
+ DATE => DB2V9,
+ DAY => DB2V5 | DB2V6 | DB2V7 | DB2V8 | DB2V9,
+ DAYS => DB2V5 | DB2V6 | DB2V7 | DB2V8 | DB2V9,
+ DB2GENERAL => DB2V9,
+ DB2GENRL => DB2V9,
+ DB2SQL => DB2V6 | DB2V7 | DB2V9,
+ DBINFO => DB2V6 | DB2V7 | DB2V8 | DB2V9,
+ DBPARTITIONNAME => DB2V9,
+ DBPARTITIONNUM => DB2V9,
+ DEALLOCATE => DB2V9,
+ DECLARE => DB2V6 | DB2V7 | DB2V8 | DB2V9,
+ DEFAULT => DB2V5 | DB2V6 | DB2V7 | DB2V8 | DB2V9,
+ DEFAULTS => DB2V9,
+ DEFINITION => DB2V9,
+ DELETE => DB2V5 | DB2V6 | DB2V7 | DB2V8 | DB2V9,
+ DENSE_RANK => DB2V9,
+ DENSERANK => DB2V9,
+ DESCRIBE => DB2V9,
+ DESCRIPTOR => DB2V5 | DB2V6 | DB2V7 | DB2V8 | DB2V9,
+ DETERMINISTIC => DB2V6 | DB2V7 | DB2V8 | DB2V9,
+ DIAGNOSTICS => DB2V9,
+ DISABLE => DB2V9,
+ DISALLOW => DB2V6 | DB2V7 | DB2V8 | DB2V9,
+ DISCONNECT => DB2V9,
+ DISTINCT => DB2V5 | DB2V6 | DB2V7 | DB2V8 | DB2V9,
+ DO => DB2V5 | DB2V6 | DB2V7 | DB2V8 | DB2V9,
+ DOCUMENT => DB2V9,
+ DOUBLE => DB2V5 | DB2V6 | DB2V7 | DB2V8 | DB2V9,
+ DROP => DB2V5 | DB2V6 | DB2V7 | DB2V8 | DB2V9,
DSNHATTR => DB2V7,
- DSSIZE => DB2V6 | DB2V7 | DB2V8,
- DYNAMIC => DB2V6 | DB2V7 | DB2V8,
- EDITPROC => DB2V5 | DB2V6 | DB2V7 | DB2V8,
- ELSE => DB2V5 | DB2V6 | DB2V7 | DB2V8,
- ELSEIF => DB2V5 | DB2V6 | DB2V7 | DB2V8,
- ENCODING => DB2V7 | DB2V8,
- ENCRYPTION => DB2V8,
- END => DB2V5 | DB2V6 | DB2V7 | DB2V8,
- ENDING => DB2V8,
- ERASE => DB2V5 | DB2V6 | DB2V7 | DB2V8,
- ESCAPE => DB2V5 | DB2V6 | DB2V7 | DB2V8,
- EXCEPT => DB2V5 | DB2V6 | DB2V7 | DB2V8,
- EXCEPTION => DB2V8,
- EXECUTE => DB2V5 | DB2V6 | DB2V7 | DB2V8,
- EXISTS => DB2V5 | DB2V6 | DB2V7 | DB2V8,
- EXIT => DB2V5 | DB2V6 | DB2V7 | DB2V8,
- EXPLAIN => DB2V8,
- EXTERNAL => DB2V6 | DB2V7 | DB2V8,
- FENCED => DB2V6 | DB2V7 | DB2V8,
- FETCH => DB2V6 | DB2V7 | DB2V8,
- FIELDPROC => DB2V5 | DB2V6 | DB2V7 | DB2V8,
- FINAL => DB2V6 | DB2V7 | DB2V8,
- FOR => DB2V5 | DB2V6 | DB2V7 | DB2V8,
- FREE => DB2V8,
- FROM => DB2V5 | DB2V6 | DB2V7 | DB2V8,
- FULL => DB2V5 | DB2V6 | DB2V7 | DB2V8,
- FUNCTION => DB2V6 | DB2V7 | DB2V8,
- GENERAL => DB2V6 | DB2V7,
- GENERATED => DB2V6 | DB2V7 | DB2V8,
- GET => DB2V6 | DB2V7 | DB2V8,
- GLOBAL => DB2V6 | DB2V7 | DB2V8,
- GO => DB2V5 | DB2V6 | DB2V7 | DB2V8,
- GOTO => DB2V5 | DB2V6 | DB2V7 | DB2V8,
- GRANT => DB2V5 | DB2V6 | DB2V7 | DB2V8,
- GROUP => DB2V5 | DB2V6 | DB2V7 | DB2V8,
- HANDLER => DB2V5 | DB2V6 | DB2V7 | DB2V8,
- HAVING => DB2V5 | DB2V6 | DB2V7 | DB2V8,
- HOLD => DB2V8,
- HOUR => DB2V5 | DB2V6 | DB2V7 | DB2V8,
- HOURS => DB2V5 | DB2V6 | DB2V7 | DB2V8,
- IF => DB2V5 | DB2V6 | DB2V7 | DB2V8,
- IMMEDIATE => DB2V5 | DB2V6 | DB2V7 | DB2V8,
- IN => DB2V5 | DB2V6 | DB2V7 | DB2V8,
- INCLUSIVE => DB2V8,
- INDEX => DB2V5 | DB2V6 | DB2V7 | DB2V8,
- INHERIT => DB2V7 | DB2V8,
- INNER => DB2V5 | DB2V6 | DB2V7 | DB2V8,
- INOUT => DB2V5 | DB2V6 | DB2V7 | DB2V8,
- INSENSITIVE => DB2V7 | DB2V8,
- INSERT => DB2V5 | DB2V6 | DB2V7 | DB2V8,
- INTO => DB2V5 | DB2V6 | DB2V7 | DB2V8,
- IS => DB2V5 | DB2V6 | DB2V7 | DB2V8,
- ISOBID => DB2V5 | DB2V6 | DB2V7 | DB2V8,
- ITERATE => DB2V8,
- JAR => DB2V7 | DB2V8,
- JAVA => DB2V6 | DB2V7,
- JOIN => DB2V5 | DB2V6 | DB2V7 | DB2V8,
- KEY => DB2V5 | DB2V6 | DB2V7 | DB2V8,
- LABEL => DB2V6 | DB2V7 | DB2V8,
- LANGUAGE => DB2V6 | DB2V7 | DB2V8,
- LC_CTYPE => DB2V6 | DB2V7 | DB2V8,
- LEAVE => DB2V5 | DB2V6 | DB2V7 | DB2V8,
- LEFT => DB2V5 | DB2V6 | DB2V7 | DB2V8,
- LIKE => DB2V5 | DB2V6 | DB2V7 | DB2V8,
- LOCAL => DB2V5 | DB2V6 | DB2V7 | DB2V8,
- LOCALE => DB2V6 | DB2V7 | DB2V8,
- LOCATOR => DB2V5 | DB2V6 | DB2V7 | DB2V8,
- LOCATORS => DB2V5 | DB2V6 | DB2V7 | DB2V8,
- LOCK => DB2V6 | DB2V7 | DB2V8,
- LOCKMAX => DB2V5 | DB2V6 | DB2V7 | DB2V8,
- LOCKSIZE => DB2V5 | DB2V6 | DB2V7 | DB2V8,
- LONG => DB2V6 | DB2V7 | DB2V8,
- LOOP => DB2V5 | DB2V6 | DB2V7 | DB2V8,
- MAINTAINED => DB2V8,
- MATERIALIZED => DB2V8,
- MICROSECOND => DB2V5 | DB2V6 | DB2V7 | DB2V8,
- MICROSECONDS => DB2V5 | DB2V6 | DB2V7 | DB2V8,
- MINUTE => DB2V5 | DB2V6 | DB2V7 | DB2V8,
- MINUTES => DB2V5 | DB2V6 | DB2V7 | DB2V8,
- MODIFIES => DB2V6 | DB2V7 | DB2V8,
- MONTH => DB2V5 | DB2V6 | DB2V7 | DB2V8,
- MONTHS => DB2V5 | DB2V6 | DB2V7 | DB2V8,
- NEXTVAL => DB2V8,
- NO => DB2V5 | DB2V6 | DB2V7 | DB2V8,
- NONE => DB2V8,
- NOT => DB2V5 | DB2V6 | DB2V7 | DB2V8,
- NULL => DB2V5 | DB2V6 | DB2V7 | DB2V8,
- NULLS => DB2V6 | DB2V7 | DB2V8,
- NUMPARTS => DB2V5 | DB2V6 | DB2V7 | DB2V8,
- OBID => DB2V5 | DB2V6 | DB2V7 | DB2V8,
- OF => DB2V5 | DB2V6 | DB2V7 | DB2V8,
- ON => DB2V5 | DB2V6 | DB2V7 | DB2V8,
- OPEN => DB2V6 | DB2V7 | DB2V8,
- OPTIMIZATION => DB2V6 | DB2V7 | DB2V8,
- OPTIMIZE => DB2V5 | DB2V6 | DB2V7 | DB2V8,
- OR => DB2V5 | DB2V6 | DB2V7 | DB2V8,
- ORDER => DB2V5 | DB2V6 | DB2V7 | DB2V8,
- OUT => DB2V5 | DB2V6 | DB2V7 | DB2V8,
- OUTER => DB2V5 | DB2V6 | DB2V7 | DB2V8,
- PACKAGE => DB2V5 | DB2V6 | DB2V7 | DB2V8,
- PADDED => DB2V8,
- PARAMETER => DB2V6 | DB2V7 | DB2V8,
- PART => DB2V5 | DB2V6 | DB2V7 | DB2V8,
- PARTITION => DB2V8,
- PARTITIONED => DB2V8,
- PARTITIONING => DB2V8,
- PATH => DB2V6 | DB2V7 | DB2V8,
- PIECESIZE => DB2V5 | DB2V6 | DB2V7 | DB2V8,
- PLAN => DB2V5 | DB2V6 | DB2V7 | DB2V8,
- PRECISION => DB2V5 | DB2V6 | DB2V7 | DB2V8,
- PREPARE => DB2V6 | DB2V7 | DB2V8,
- PREVVAL => DB2V8,
- PRIQTY => DB2V5 | DB2V6 | DB2V7 | DB2V8,
- PRIVILEGES => DB2V5 | DB2V6 | DB2V7 | DB2V8,
- PROCEDURE => DB2V5 | DB2V6 | DB2V7 | DB2V8,
- PROGRAM => DB2V5 | DB2V6 | DB2V7 | DB2V8,
- PSID => DB2V5 | DB2V6 | DB2V7 | DB2V8,
- QUERY => DB2V8,
- QUERYNO => DB2V6 | DB2V7 | DB2V8,
- READS => DB2V6 | DB2V7 | DB2V8,
- REFERENCES => DB2V5 | DB2V6 | DB2V7 | DB2V8,
- REFRESH => DB2V8,
- RELEASE => DB2V6 | DB2V7 | DB2V8,
- RENAME => DB2V5 | DB2V6 | DB2V7 | DB2V8,
- REPEAT => DB2V5 | DB2V6 | DB2V7 | DB2V8,
- RESIGNAL => DB2V8,
- RESTRICT => DB2V6 | DB2V7 | DB2V8,
- RESULT => DB2V6 | DB2V7 | DB2V8,
- RESULT_SET_LOCATOR => DB2V6 | DB2V7 | DB2V8,
- RETURN => DB2V6 | DB2V7 | DB2V8,
- RETURNS => DB2V6 | DB2V7 | DB2V8,
- REVOKE => DB2V6 | DB2V7 | DB2V8,
- RIGHT => DB2V5 | DB2V6 | DB2V7 | DB2V8,
- ROLLBACK => DB2V6 | DB2V7 | DB2V8,
- ROWSET => DB2V8,
- RUN => DB2V6 | DB2V7 | DB2V8,
- SAVEPOINT => DB2V6 | DB2V7 | DB2V8,
- SCHEMA => DB2V6 | DB2V7 | DB2V8,
- SCRATCHPAD => DB2V6 | DB2V7 | DB2V8,
- SECOND => DB2V5 | DB2V6 | DB2V7 | DB2V8,
- SECONDS => DB2V5 | DB2V6 | DB2V7 | DB2V8,
- SECQTY => DB2V5 | DB2V6 | DB2V7 | DB2V8,
- SECURITY => DB2V6 | DB2V7 | DB2V8,
- SELECT => DB2V5 | DB2V6 | DB2V7 | DB2V8,
- SENSITIVE => DB2V7 | DB2V8,
- SEQUENCE => DB2V8,
- SET => DB2V5 | DB2V6 | DB2V7 | DB2V8,
- SIGNAL => DB2V8,
- SIMPLE => DB2V6 | DB2V7 | DB2V8,
- SOME => DB2V5 | DB2V6 | DB2V7 | DB2V8,
- SOURCE => DB2V6 | DB2V7 | DB2V8,
- SPECIFIC => DB2V6 | DB2V7 | DB2V8,
- STANDARD => DB2V6 | DB2V7 | DB2V8,
- STATIC => DB2V7 | DB2V8,
- STAY => DB2V6 | DB2V7 | DB2V8,
- STOGROUP => DB2V5 | DB2V6 | DB2V7 | DB2V8,
- STORES => DB2V6 | DB2V7 | DB2V8,
- STYLE => DB2V6 | DB2V7 | DB2V8,
+ DSSIZE => DB2V6 | DB2V7 | DB2V8 | DB2V9,
+ DYNAMIC => DB2V6 | DB2V7 | DB2V8 | DB2V9,
+ EACH => DB2V9,
+ EDITPROC => DB2V5 | DB2V6 | DB2V7 | DB2V8 | DB2V9,
+ ELSE => DB2V5 | DB2V6 | DB2V7 | DB2V8 | DB2V9,
+ ELSEIF => DB2V5 | DB2V6 | DB2V7 | DB2V8 | DB2V9,
+ ENABLE => DB2V9,
+ ENCODING => DB2V7 | DB2V8 | DB2V9,
+ ENCRYPTION => DB2V8 | DB2V9,
+ END => DB2V5 | DB2V6 | DB2V7 | DB2V8 | DB2V9,
+ ENDING => DB2V8 | DB2V9,
+ ERASE => DB2V5 | DB2V6 | DB2V7 | DB2V8 | DB2V9,
+ ESCAPE => DB2V5 | DB2V6 | DB2V7 | DB2V8 | DB2V9,
+ EVERY => DB2V9,
+ EXCEPT => DB2V5 | DB2V6 | DB2V7 | DB2V8 | DB2V9,
+ EXCEPTION => DB2V8 | DB2V9,
+ EXCLUDING => DB2V9,
+ EXCLUSIVE => DB2V9,
+ EXECUTE => DB2V5 | DB2V6 | DB2V7 | DB2V8 | DB2V9,
+ EXISTS => DB2V5 | DB2V6 | DB2V7 | DB2V8 | DB2V9,
+ EXIT => DB2V5 | DB2V6 | DB2V7 | DB2V8 | DB2V9,
+ EXPLAIN => DB2V8 | DB2V9,
+ EXTERNAL => DB2V6 | DB2V7 | DB2V8 | DB2V9,
+ EXTRACT => DB2V9,
+ FENCED => DB2V6 | DB2V7 | DB2V8 | DB2V9,
+ FETCH => DB2V6 | DB2V7 | DB2V8 | DB2V9,
+ FIELDPROC => DB2V5 | DB2V6 | DB2V7 | DB2V8 | DB2V9,
+ FILE => DB2V9,
+ FINAL => DB2V6 | DB2V7 | DB2V8 | DB2V9,
+ FOR => DB2V5 | DB2V6 | DB2V7 | DB2V8 | DB2V9,
+ FOREIGN => DB2V9,
+ FREE => DB2V8 | DB2V9,
+ FROM => DB2V5 | DB2V6 | DB2V7 | DB2V8 | DB2V9,
+ FULL => DB2V5 | DB2V6 | DB2V7 | DB2V8 | DB2V9,
+ FUNCTION => DB2V6 | DB2V7 | DB2V8 | DB2V9,
+ GENERAL => DB2V6 | DB2V7 | DB2V9,
+ GENERATED => DB2V6 | DB2V7 | DB2V8 | DB2V9,
+ GET => DB2V6 | DB2V7 | DB2V8 | DB2V9,
+ GLOBAL => DB2V6 | DB2V7 | DB2V8 | DB2V9,
+ GO => DB2V5 | DB2V6 | DB2V7 | DB2V8 | DB2V9,
+ GOTO => DB2V5 | DB2V6 | DB2V7 | DB2V8 | DB2V9,
+ GRANT => DB2V5 | DB2V6 | DB2V7 | DB2V8 | DB2V9,
+ GRAPHIC => DB2V9,
+ GROUP => DB2V5 | DB2V6 | DB2V7 | DB2V8 | DB2V9,
+ HANDLER => DB2V5 | DB2V6 | DB2V7 | DB2V8 | DB2V9,
+ HASH => DB2V9,
+ HASHED_VALUE => DB2V9,
+ HAVING => DB2V5 | DB2V6 | DB2V7 | DB2V8 | DB2V9,
+ HINT => DB2V9,
+ HOLD => DB2V8 | DB2V9,
+ HOUR => DB2V5 | DB2V6 | DB2V7 | DB2V8 | DB2V9,
+ HOURS => DB2V5 | DB2V6 | DB2V7 | DB2V8 | DB2V9,
+ IDENTITY => DB2V9,
+ IF => DB2V5 | DB2V6 | DB2V7 | DB2V8 | DB2V9,
+ IMMEDIATE => DB2V5 | DB2V6 | DB2V7 | DB2V8 | DB2V9,
+ IN => DB2V5 | DB2V6 | DB2V7 | DB2V8 | DB2V9,
+ INCLUDING => DB2V9,
+ INCLUSIVE => DB2V8 | DB2V9,
+ INCREMENT => DB2V9,
+ INDEX => DB2V5 | DB2V6 | DB2V7 | DB2V8 | DB2V9,
+ INDICATOR => DB2V9,
+ INF => DB2V9,
+ INFINITY => DB2V9,
+ INHERIT => DB2V7 | DB2V8 | DB2V9,
+ INNER => DB2V5 | DB2V6 | DB2V7 | DB2V8 | DB2V9,
+ INOUT => DB2V5 | DB2V6 | DB2V7 | DB2V8 | DB2V9,
+ INSENSITIVE => DB2V7 | DB2V8 | DB2V9,
+ INSERT => DB2V5 | DB2V6 | DB2V7 | DB2V8 | DB2V9,
+ INTEGRITY => DB2V9,
+ INTERSECT => DB2V9,
+ INTO => DB2V5 | DB2V6 | DB2V7 | DB2V8 | DB2V9,
+ IS => DB2V5 | DB2V6 | DB2V7 | DB2V8 | DB2V9,
+ ISOBID => DB2V5 | DB2V6 | DB2V7 | DB2V8 | DB2V9,
+ ISOLATION => DB2V9,
+ ITERATE => DB2V8 | DB2V9,
+ JAR => DB2V7 | DB2V8 | DB2V9,
+ JAVA => DB2V6 | DB2V7 | DB2V9,
+ JOIN => DB2V5 | DB2V6 | DB2V7 | DB2V8 | DB2V9,
+ KEEP => DB2V9,
+ KEY => DB2V5 | DB2V6 | DB2V7 | DB2V8 | DB2V9,
+ LABEL => DB2V6 | DB2V7 | DB2V8 | DB2V9,
+ LANGUAGE => DB2V6 | DB2V7 | DB2V8 | DB2V9,
+ LATERAL => DB2V9,
+ LC_CTYPE => DB2V6 | DB2V7 | DB2V8 | DB2V9,
+ LEAVE => DB2V5 | DB2V6 | DB2V7 | DB2V8 | DB2V9,
+ LEFT => DB2V5 | DB2V6 | DB2V7 | DB2V8 | DB2V9,
+ LIKE => DB2V5 | DB2V6 | DB2V7 | DB2V8 | DB2V9,
+ LINKTYPE => DB2V9,
+ LOCAL => DB2V5 | DB2V6 | DB2V7 | DB2V8 | DB2V9,
+ LOCALDATE => DB2V9,
+ LOCALE => DB2V6 | DB2V7 | DB2V8 | DB2V9,
+ LOCALTIME => DB2V9,
+ LOCALTIMESTAMP => DB2V9,
+ LOCATOR => DB2V5 | DB2V6 | DB2V7 | DB2V8 | DB2V9,
+ LOCATORS => DB2V5 | DB2V6 | DB2V7 | DB2V8 | DB2V9,
+ LOCK => DB2V6 | DB2V7 | DB2V8 | DB2V9,
+ LOCKMAX => DB2V5 | DB2V6 | DB2V7 | DB2V8 | DB2V9,
+ LOCKSIZE => DB2V5 | DB2V6 | DB2V7 | DB2V8 | DB2V9,
+ LONG => DB2V6 | DB2V7 | DB2V8 | DB2V9,
+ LOOP => DB2V5 | DB2V6 | DB2V7 | DB2V8 | DB2V9,
+ MAINTAINED => DB2V8 | DB2V9,
+ MATERIALIZED => DB2V8 | DB2V9,
+ MAXVALUE => DB2V9,
+ MICROSECOND => DB2V5 | DB2V6 | DB2V7 | DB2V8 | DB2V9,
+ MICROSECONDS => DB2V5 | DB2V6 | DB2V7 | DB2V8 | DB2V9,
+ MINUTE => DB2V5 | DB2V6 | DB2V7 | DB2V8 | DB2V9,
+ MINUTES => DB2V5 | DB2V6 | DB2V7 | DB2V8 | DB2V9,
+ MINVALUE => DB2V9,
+ MODE => DB2V9,
+ MODIFIES => DB2V6 | DB2V7 | DB2V8 | DB2V9,
+ MONTH => DB2V5 | DB2V6 | DB2V7 | DB2V8 | DB2V9,
+ MONTHS => DB2V5 | DB2V6 | DB2V7 | DB2V8 | DB2V9,
+ NAN => DB2V9,
+ NEW => DB2V9,
+ NEW_TABLE => DB2V9,
+ NEXTVAL => DB2V8 | DB2V9,
+ NO => DB2V5 | DB2V6 | DB2V7 | DB2V8 | DB2V9,
+ NOCACHE => DB2V9,
+ NOCYCLE => DB2V9,
+ NODENAME => DB2V9,
+ NODENUMBER => DB2V9,
+ NOMAXVALUE => DB2V9,
+ NOMINVALUE => DB2V9,
+ NONE => DB2V8 | DB2V9,
+ NOORDER => DB2V9,
+ NORMALIZED => DB2V9,
+ NOT => DB2V5 | DB2V6 | DB2V7 | DB2V8 | DB2V9,
+ NULL => DB2V5 | DB2V6 | DB2V7 | DB2V8 | DB2V9,
+ NULLS => DB2V6 | DB2V7 | DB2V8 | DB2V9,
+ NUMPARTS => DB2V5 | DB2V6 | DB2V7 | DB2V8 | DB2V9,
+ OBID => DB2V5 | DB2V6 | DB2V7 | DB2V8 | DB2V9,
+ OF => DB2V5 | DB2V6 | DB2V7 | DB2V8 | DB2V9,
+ OLD => DB2V9,
+ OLD_TABLE => DB2V9,
+ ON => DB2V5 | DB2V6 | DB2V7 | DB2V8 | DB2V9,
+ OPEN => DB2V6 | DB2V7 | DB2V8 | DB2V9,
+ OPTIMIZATION => DB2V6 | DB2V7 | DB2V8 | DB2V9,
+ OPTIMIZE => DB2V5 | DB2V6 | DB2V7 | DB2V8 | DB2V9,
+ OPTION => DB2V9,
+ OR => DB2V5 | DB2V6 | DB2V7 | DB2V8 | DB2V9,
+ ORDER => DB2V5 | DB2V6 | DB2V7 | DB2V8 | DB2V9,
+ OUT => DB2V5 | DB2V6 | DB2V7 | DB2V8 | DB2V9,
+ OUTER => DB2V5 | DB2V6 | DB2V7 | DB2V8 | DB2V9,
+ OVER => DB2V9,
+ OVERRIDING => DB2V9,
+ PACKAGE => DB2V5 | DB2V6 | DB2V7 | DB2V8 | DB2V9,
+ PADDED => DB2V8 | DB2V9,
+ PAGESIZE => DB2V9,
+ PARAMETER => DB2V6 | DB2V7 | DB2V8 | DB2V9,
+ PART => DB2V5 | DB2V6 | DB2V7 | DB2V8 | DB2V9,
+ PARTITION => DB2V8 | DB2V9,
+ PARTITIONED => DB2V8 | DB2V9,
+ PARTITIONING => DB2V8 | DB2V9,
+ PARTITIONS => DB2V9,
+ PASSWORD => DB2V9,
+ PATH => DB2V6 | DB2V7 | DB2V8 | DB2V9,
+ PIECESIZE => DB2V5 | DB2V6 | DB2V7 | DB2V8 | DB2V9,
+ PLAN => DB2V5 | DB2V6 | DB2V7 | DB2V8 | DB2V9,
+ POSITION => DB2V9,
+ PRECISION => DB2V5 | DB2V6 | DB2V7 | DB2V8 | DB2V9,
+ PREPARE => DB2V6 | DB2V7 | DB2V8 | DB2V9,
+ PREVVAL => DB2V8 | DB2V9,
+ PRIMARY => DB2V9,
+ PRIQTY => DB2V5 | DB2V6 | DB2V7 | DB2V8 | DB2V9,
+ PRIVILEGES => DB2V5 | DB2V6 | DB2V7 | DB2V8 | DB2V9,
+ PROCEDURE => DB2V5 | DB2V6 | DB2V7 | DB2V8 | DB2V9,
+ PROGRAM => DB2V5 | DB2V6 | DB2V7 | DB2V8 | DB2V9,
+ PSID => DB2V5 | DB2V6 | DB2V7 | DB2V8 | DB2V9,
+ PUBLIC => DB2V9,
+ QUERY => DB2V8 | DB2V9,
+ QUERYNO => DB2V6 | DB2V7 | DB2V8 | DB2V9,
+ RANGE => DB2V9,
+ RANK => DB2V9,
+ READ => DB2V9,
+ READS => DB2V6 | DB2V7 | DB2V8 | DB2V9,
+ RECOVERY => DB2V9,
+ REFERENCES => DB2V5 | DB2V6 | DB2V7 | DB2V8 | DB2V9,
+ REFERENCING => DB2V9,
+ REFRESH => DB2V8 | DB2V9,
+ RELEASE => DB2V6 | DB2V7 | DB2V8 | DB2V9,
+ RENAME => DB2V5 | DB2V6 | DB2V7 | DB2V8 | DB2V9,
+ REPEAT => DB2V5 | DB2V6 | DB2V7 | DB2V8 | DB2V9,
+ RESET => DB2V9,
+ RESIGNAL => DB2V8 | DB2V9,
+ RESTART => DB2V9,
+ RESTRICT => DB2V6 | DB2V7 | DB2V8 | DB2V9,
+ RESULT => DB2V6 | DB2V7 | DB2V8 | DB2V9,
+ RESULT_SET_LOCATOR => DB2V6 | DB2V7 | DB2V8 | DB2V9,
+ RETURN => DB2V6 | DB2V7 | DB2V8 | DB2V9,
+ RETURNS => DB2V6 | DB2V7 | DB2V8 | DB2V9,
+ REVOKE => DB2V6 | DB2V7 | DB2V8 | DB2V9,
+ RIGHT => DB2V5 | DB2V6 | DB2V7 | DB2V8 | DB2V9,
+ ROLE => DB2V9,
+ ROLLBACK => DB2V6 | DB2V7 | DB2V8 | DB2V9,
+ ROUND_CEILING => DB2V9,
+ ROUND_DOWN => DB2V9,
+ ROUND_FLOOR => DB2V9,
+ ROUND_HALF_DOWN => DB2V9,
+ ROUND_HALF_EVEN => DB2V9,
+ ROUND_HALF_UP => DB2V9,
+ ROUND_UP => DB2V9,
+ ROUTINE => DB2V9,
+ ROW => DB2V9,
+ ROW_NUMBER => DB2V9,
+ ROWNUMBER => DB2V9,
+ ROWS => DB2V9,
+ ROWSET => DB2V8 | DB2V9,
+ RRN => DB2V9,
+ RUN => DB2V6 | DB2V7 | DB2V8 | DB2V9,
+ SAVEPOINT => DB2V6 | DB2V7 | DB2V8 | DB2V9,
+ SCHEMA => DB2V6 | DB2V7 | DB2V8 | DB2V9,
+ SCRATCHPAD => DB2V6 | DB2V7 | DB2V8 | DB2V9,
+ SCROLL => DB2V9,
+ SEARCH => DB2V9,
+ SECOND => DB2V5 | DB2V6 | DB2V7 | DB2V8 | DB2V9,
+ SECONDS => DB2V5 | DB2V6 | DB2V7 | DB2V8 | DB2V9,
+ SECQTY => DB2V5 | DB2V6 | DB2V7 | DB2V8 | DB2V9,
+ SECURITY => DB2V6 | DB2V7 | DB2V8 | DB2V9,
+ SELECT => DB2V5 | DB2V6 | DB2V7 | DB2V8 | DB2V9,
+ SENSITIVE => DB2V7 | DB2V8 | DB2V9,
+ SEQUENCE => DB2V8 | DB2V9,
+ SESSION => DB2V9,
+ SESSION_USER => DB2V9,
+ SET => DB2V5 | DB2V6 | DB2V7 | DB2V8 | DB2V9,
+ SIGNAL => DB2V8 | DB2V9,
+ SIMPLE => DB2V6 | DB2V7 | DB2V8 | DB2V9,
+ SNAN => DB2V9,
+ SOME => DB2V5 | DB2V6 | DB2V7 | DB2V8 | DB2V9,
+ SOURCE => DB2V6 | DB2V7 | DB2V8 | DB2V9,
+ SPECIFIC => DB2V6 | DB2V7 | DB2V8 | DB2V9,
+ SQL => DB2V9,
+ SQLID => DB2V9,
+ STACKED => DB2V9,
+ STANDARD => DB2V6 | DB2V7 | DB2V8 | DB2V9,
+ START => DB2V9,
+ STARTING => DB2V9,
+ STATEMENT => DB2V9,
+ STATIC => DB2V7 | DB2V8 | DB2V9,
+ STATMENT => DB2V9,
+ STAY => DB2V6 | DB2V7 | DB2V8 | DB2V9,
+ STOGROUP => DB2V5 | DB2V6 | DB2V7 | DB2V8 | DB2V9,
+ STORES => DB2V6 | DB2V7 | DB2V8 | DB2V9,
+ STYLE => DB2V6 | DB2V7 | DB2V8 | DB2V9,
SUBPAGES => DB2V5 | DB2V6 | DB2V7,
- SUMMARY => DB2V8,
- SYNONYM => DB2V5 | DB2V6 | DB2V7 | DB2V8,
- SYSFUN => DB2V6 | DB2V7 | DB2V8,
- SYSIBM => DB2V6 | DB2V7 | DB2V8,
- SYSPROC => DB2V6 | DB2V7 | DB2V8,
- SYSTEM => DB2V6 | DB2V7 | DB2V8,
- TABLE => DB2V5 | DB2V6 | DB2V7 | DB2V8,
- TABLESPACE => DB2V5 | DB2V6 | DB2V7 | DB2V8,
- THEN => DB2V5 | DB2V6 | DB2V7 | DB2V8,
- TO => DB2V5 | DB2V6 | DB2V7 | DB2V8,
- TRIGGER => DB2V6 | DB2V7 | DB2V8,
- UNDO => DB2V5 | DB2V6 | DB2V7 | DB2V8,
- UNION => DB2V5 | DB2V6 | DB2V7 | DB2V8,
- UNIQUE => DB2V5 | DB2V6 | DB2V7 | DB2V8,
- UNTIL => DB2V5 | DB2V6 | DB2V7 | DB2V8,
- UPDATE => DB2V5 | DB2V6 | DB2V7 | DB2V8,
- USER => DB2V5 | DB2V6 | DB2V7 | DB2V8,
- USING => DB2V5 | DB2V6 | DB2V7 | DB2V8,
- VALIDPROC => DB2V5 | DB2V6 | DB2V7 | DB2V8,
- VALUE => DB2V8,
- VALUES => DB2V5 | DB2V6 | DB2V7 | DB2V8,
- VARIABLE => DB2V8,
- VARIANT => DB2V6 | DB2V7 | DB2V8,
- VCAT => DB2V5 | DB2V6 | DB2V7 | DB2V8,
- VIEW => DB2V5 | DB2V6 | DB2V7 | DB2V8,
- VOLATILE => DB2V8,
- VOLUMES => DB2V5 | DB2V6 | DB2V7 | DB2V8,
- WHEN => DB2V5 | DB2V6 | DB2V7 | DB2V8,
- WHENEVER => DB2V8,
- WHERE => DB2V5 | DB2V6 | DB2V7 | DB2V8,
- WHILE => DB2V5 | DB2V6 | DB2V7 | DB2V8,
- WITH => DB2V5 | DB2V6 | DB2V7 | DB2V8,
- WLM => DB2V6 | DB2V7 | DB2V8,
- XMLELEMENT => DB2V8,
- YEAR => DB2V5 | DB2V6 | DB2V7 | DB2V8,
- YEARS => DB2V5 | DB2V6 | DB2V7 | DB2V8,
+ SUBSTRING => DB2V9,
+ SUMMARY => DB2V8 | DB2V9,
+ SYNONYM => DB2V5 | DB2V6 | DB2V7 | DB2V8 | DB2V9,
+ SYSFUN => DB2V6 | DB2V7 | DB2V8 | DB2V9,
+ SYSIBM => DB2V6 | DB2V7 | DB2V8 | DB2V9,
+ SYSPROC => DB2V6 | DB2V7 | DB2V8 | DB2V9,
+ SYSTEM => DB2V6 | DB2V7 | DB2V8 | DB2V9,
+ SYSTEM_USER => DB2V9,
+ TABLE => DB2V5 | DB2V6 | DB2V7 | DB2V8 | DB2V9,
+ TABLESPACE => DB2V5 | DB2V6 | DB2V7 | DB2V8 | DB2V9,
+ THEN => DB2V5 | DB2V6 | DB2V7 | DB2V8 | DB2V9,
+ TIME => DB2V9,
+ TIMESTAMP => DB2V9,
+ TO => DB2V5 | DB2V6 | DB2V7 | DB2V8 | DB2V9,
+ TRANSACTION => DB2V9,
+ TRIGGER => DB2V6 | DB2V7 | DB2V8 | DB2V9,
+ TRIM => DB2V9,
+ TRUNCATE => DB2V9,
+ TYPE => DB2V9,
+ UNDO => DB2V5 | DB2V6 | DB2V7 | DB2V8 | DB2V9,
+ UNION => DB2V5 | DB2V6 | DB2V7 | DB2V8 | DB2V9,
+ UNIQUE => DB2V5 | DB2V6 | DB2V7 | DB2V8 | DB2V9,
+ UNTIL => DB2V5 | DB2V6 | DB2V7 | DB2V8 | DB2V9,
+ UPDATE => DB2V5 | DB2V6 | DB2V7 | DB2V8 | DB2V9,
+ USAGE => DB2V9,
+ USER => DB2V5 | DB2V6 | DB2V7 | DB2V8 | DB2V9,
+ USING => DB2V5 | DB2V6 | DB2V7 | DB2V8 | DB2V9,
+ VALIDPROC => DB2V5 | DB2V6 | DB2V7 | DB2V8 | DB2V9,
+ VALUE => DB2V8 | DB2V9,
+ VALUES => DB2V5 | DB2V6 | DB2V7 | DB2V8 | DB2V9,
+ VARIABLE => DB2V8 | DB2V9,
+ VARIANT => DB2V6 | DB2V7 | DB2V8 | DB2V9,
+ VCAT => DB2V5 | DB2V6 | DB2V7 | DB2V8 | DB2V9,
+ VERSION => DB2V9,
+ VIEW => DB2V5 | DB2V6 | DB2V7 | DB2V8 | DB2V9,
+ VOLATILE => DB2V8 | DB2V9,
+ VOLUMES => DB2V5 | DB2V6 | DB2V7 | DB2V8 | DB2V9,
+ WHEN => DB2V5 | DB2V6 | DB2V7 | DB2V8 | DB2V9,
+ WHENEVER => DB2V8 | DB2V9,
+ WHERE => DB2V5 | DB2V6 | DB2V7 | DB2V8 | DB2V9,
+ WHILE => DB2V5 | DB2V6 | DB2V7 | DB2V8 | DB2V9,
+ WITH => DB2V5 | DB2V6 | DB2V7 | DB2V8 | DB2V9,
+ WITHOUT => DB2V9,
+ WLM => DB2V6 | DB2V7 | DB2V8 | DB2V9,
+ WRITE => DB2V9,
+ XMLELEMENT => DB2V8 | DB2V9,
+ XMLEXISTS => DB2V9,
+ XMLNAMESPACES => DB2V9,
+ YEAR => DB2V5 | DB2V6 | DB2V7 | DB2V8 | DB2V9,
+ YEARS => DB2V5 | DB2V6 | DB2V7 | DB2V8 | DB2V9
);
sub is_reserved {
- return $WORDS{ uc pop } || 0;
+ return $WORDS{ uc(pop || '') } || 0;
}
sub is_reserved_by_db2v5 {
@@ -315,6 +450,10 @@
return &is_reserved & DB2V8;
}
+ sub is_reserved_by_db2v9 {
+ return &is_reserved & DB2V9;
+ }
+
sub reserved_by {
my $flags = &is_reserved;
my @reserved_by = ();
@@ -323,6 +462,7 @@
push @reserved_by, 'DB2 6' if $flags & DB2V6;
push @reserved_by, 'DB2 7' if $flags & DB2V7;
push @reserved_by, 'DB2 8' if $flags & DB2V8;
+ push @reserved_by, 'DB2 9' if $flags & DB2V9;
return @reserved_by;
}
@@ -375,6 +515,10 @@
Returns a boolean indicating if C<$word> is reserved by DB2 8.
+=item is_reserved_by_db2v9( $word )
+
+Returns a boolean indicating if C<$word> is reserved by DB2 9.
+
=item reserved_by( $word )
Returns a list with DB2 versions that reserves C<$word>.
@@ -401,6 +545,8 @@
=item is_reserved_by_db2v8
+=item is_reserved_by_db2v9
+
=item reserved_by
=item words
diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn' '--exclude=.svnignore' old/SQL-ReservedWords-0.7/lib/SQL/ReservedWords/MySQL.pm new/SQL-ReservedWords-0.8/lib/SQL/ReservedWords/MySQL.pm
--- old/SQL-ReservedWords-0.7/lib/SQL/ReservedWords/MySQL.pm 2006-03-24 20:49:06.000000000 +0100
+++ new/SQL-ReservedWords-0.8/lib/SQL/ReservedWords/MySQL.pm 2012-08-30 14:37:19.000000000 +0200
@@ -4,7 +4,7 @@
use warnings;
use vars '$VERSION';
-$VERSION = 0.7;
+$VERSION = '0.8';
use constant MYSQL32 => 0x01;
use constant MYSQL40 => 0x02;
@@ -266,7 +266,7 @@
);
sub is_reserved {
- return $WORDS{ uc pop } || 0;
+ return $WORDS{ uc(pop || '') } || 0;
}
sub is_reserved_by_mysql3 {
diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn' '--exclude=.svnignore' old/SQL-ReservedWords-0.7/lib/SQL/ReservedWords/ODBC.pm new/SQL-ReservedWords-0.8/lib/SQL/ReservedWords/ODBC.pm
--- old/SQL-ReservedWords-0.7/lib/SQL/ReservedWords/ODBC.pm 2006-03-24 20:49:06.000000000 +0100
+++ new/SQL-ReservedWords-0.8/lib/SQL/ReservedWords/ODBC.pm 2012-08-30 14:37:19.000000000 +0200
@@ -4,7 +4,7 @@
use warnings;
use vars '$VERSION';
-$VERSION = 0.7;
+$VERSION = '0.8';
use constant ODBC30 => 0x01;
@@ -261,7 +261,7 @@
);
sub is_reserved {
- return $WORDS{ uc pop } || 0;
+ return $WORDS{ uc(pop || '') } || 0;
}
sub is_reserved_by_odbc3 {
diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn' '--exclude=.svnignore' old/SQL-ReservedWords-0.7/lib/SQL/ReservedWords/Oracle.pm new/SQL-ReservedWords-0.8/lib/SQL/ReservedWords/Oracle.pm
--- old/SQL-ReservedWords-0.7/lib/SQL/ReservedWords/Oracle.pm 2006-03-24 20:49:06.000000000 +0100
+++ new/SQL-ReservedWords-0.8/lib/SQL/ReservedWords/Oracle.pm 2012-08-30 14:37:19.000000000 +0200
@@ -4,7 +4,7 @@
use warnings;
use vars '$VERSION';
-$VERSION = 0.7;
+$VERSION = '0.8';
use constant ORACLE7 => 0x01;
use constant ORACLE8 => 0x02;
@@ -142,7 +142,7 @@
);
sub is_reserved {
- return $WORDS{ uc pop } || 0;
+ return $WORDS{ uc(pop || '') } || 0;
}
sub is_reserved_by_oracle7 {
diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn' '--exclude=.svnignore' old/SQL-ReservedWords-0.7/lib/SQL/ReservedWords/PostgreSQL.pm new/SQL-ReservedWords-0.8/lib/SQL/ReservedWords/PostgreSQL.pm
--- old/SQL-ReservedWords-0.7/lib/SQL/ReservedWords/PostgreSQL.pm 2006-03-24 20:49:06.000000000 +0100
+++ new/SQL-ReservedWords-0.8/lib/SQL/ReservedWords/PostgreSQL.pm 2012-08-30 14:37:19.000000000 +0200
@@ -4,7 +4,7 @@
use warnings;
use vars '$VERSION';
-$VERSION = 0.7;
+$VERSION = '0.8';
use constant POSTGRESQL73 => 0x01;
use constant POSTGRESQL74 => 0x02;
@@ -123,7 +123,7 @@
);
sub is_reserved {
- return $WORDS{ uc pop } || 0;
+ return $WORDS{ uc(pop || '') } || 0;
}
sub is_reserved_by_postgresql7 {
diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn' '--exclude=.svnignore' old/SQL-ReservedWords-0.7/lib/SQL/ReservedWords/SQLServer.pm new/SQL-ReservedWords-0.8/lib/SQL/ReservedWords/SQLServer.pm
--- old/SQL-ReservedWords-0.7/lib/SQL/ReservedWords/SQLServer.pm 2006-03-24 20:49:06.000000000 +0100
+++ new/SQL-ReservedWords-0.8/lib/SQL/ReservedWords/SQLServer.pm 2012-08-30 14:37:19.000000000 +0200
@@ -4,7 +4,7 @@
use warnings;
use vars '$VERSION';
-$VERSION = 0.7;
+$VERSION = '0.8';
use constant SQLSERVER7 => 0x01;
use constant SQLSERVER2000 => 0x02;
@@ -232,7 +232,7 @@
);
sub is_reserved {
- return $WORDS{ uc pop } || 0;
+ return $WORDS{ uc(pop || '') } || 0;
}
sub is_reserved_by_sqlserver7 {
diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn' '--exclude=.svnignore' old/SQL-ReservedWords-0.7/lib/SQL/ReservedWords/SQLite.pm new/SQL-ReservedWords-0.8/lib/SQL/ReservedWords/SQLite.pm
--- old/SQL-ReservedWords-0.7/lib/SQL/ReservedWords/SQLite.pm 2006-03-24 20:49:06.000000000 +0100
+++ new/SQL-ReservedWords-0.8/lib/SQL/ReservedWords/SQLite.pm 2012-08-30 14:37:19.000000000 +0200
@@ -4,7 +4,7 @@
use warnings;
use vars '$VERSION';
-$VERSION = 0.7;
+$VERSION = '0.8';
use constant SQLITE2 => 0x01; # 2.8.17
use constant SQLITE3 => 0x02; # 3.3.4
@@ -93,7 +93,7 @@
);
sub is_reserved {
- return $WORDS{ uc pop } || 0;
+ return $WORDS{ uc(pop || '') } || 0;
}
sub is_reserved_by_sqlite2 {
diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn' '--exclude=.svnignore' old/SQL-ReservedWords-0.7/lib/SQL/ReservedWords/Sybase.pm new/SQL-ReservedWords-0.8/lib/SQL/ReservedWords/Sybase.pm
--- old/SQL-ReservedWords-0.7/lib/SQL/ReservedWords/Sybase.pm 2006-03-24 20:49:06.000000000 +0100
+++ new/SQL-ReservedWords-0.8/lib/SQL/ReservedWords/Sybase.pm 2012-08-30 14:37:19.000000000 +0200
@@ -4,7 +4,7 @@
use warnings;
use vars '$VERSION';
-$VERSION = 0.7;
+$VERSION = '0.8';
use constant SYBASEASE12 => 0x01;
use constant SYBASEASE15 => 0x02;
@@ -248,7 +248,7 @@
);
sub is_reserved {
- return $WORDS{ uc pop } || 0;
+ return $WORDS{ uc(pop || '') } || 0;
}
sub is_reserved_by_ase12 {
diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn' '--exclude=.svnignore' old/SQL-ReservedWords-0.7/lib/SQL/ReservedWords.pm new/SQL-ReservedWords-0.8/lib/SQL/ReservedWords.pm
--- old/SQL-ReservedWords-0.7/lib/SQL/ReservedWords.pm 2006-03-24 20:49:06.000000000 +0100
+++ new/SQL-ReservedWords-0.8/lib/SQL/ReservedWords.pm 2012-08-30 14:37:19.000000000 +0200
@@ -4,7 +4,7 @@
use warnings;
use vars '$VERSION';
-$VERSION = 0.7;
+$VERSION = '0.8';
use constant SQL1992 => 0x01;
use constant SQL1999 => 0x02;
@@ -367,7 +367,7 @@
);
sub is_reserved {
- return $WORDS{ uc pop } || 0;
+ return $WORDS{ uc(pop || '') } || 0;
}
sub is_reserved_by_sql1992 {
diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn' '--exclude=.svnignore' old/SQL-ReservedWords-0.7/scripts/sqlrw new/SQL-ReservedWords-0.8/scripts/sqlrw
--- old/SQL-ReservedWords-0.7/scripts/sqlrw 2006-03-24 20:49:06.000000000 +0100
+++ new/SQL-ReservedWords-0.8/scripts/sqlrw 2012-08-30 14:37:19.000000000 +0200
@@ -4,7 +4,7 @@
use warnings;
use vars '$VERSION';
-$VERSION = 0.7;
+$VERSION = '0.8';
use Getopt::Long qw[];
@@ -56,7 +56,7 @@
REPORT
sub usage {
- require POD::Usage;
+ require Pod::Usage;
Pod::Usage::pod2usage( @_ );
}
diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn' '--exclude=.svnignore' old/SQL-ReservedWords-0.7/t/05-db2.t new/SQL-ReservedWords-0.8/t/05-db2.t
--- old/SQL-ReservedWords-0.7/t/05-db2.t 2006-03-24 20:49:06.000000000 +0100
+++ new/SQL-ReservedWords-0.8/t/05-db2.t 2012-08-30 14:37:19.000000000 +0200
@@ -5,7 +5,7 @@
use Test::More;
-plan tests => 51;
+plan tests => 58;
use_ok( 'SQL::ReservedWords::DB2' );
@@ -15,6 +15,7 @@
is_reserved_by_db2v6
is_reserved_by_db2v7
is_reserved_by_db2v8
+ is_reserved_by_db2v9
reserved_by
words
];
@@ -26,43 +27,47 @@
}
ok my @words = SQL::ReservedWords::DB2->words, 'Got words';
-cmp_ok @words, '==', 264, 'Got 264 words';
+cmp_ok @words, '==', 397, 'Got 397 words';
ok SQL::ReservedWords::DB2->is_reserved('user'), 'USER is reserved';
ok SQL::ReservedWords::DB2->is_reserved_by_db2v5('user'), 'USER is reserved by DB2 5';
ok SQL::ReservedWords::DB2->is_reserved_by_db2v6('user'), 'USER is reserved by DB2 6';
ok SQL::ReservedWords::DB2->is_reserved_by_db2v7('user'), 'USER is reserved by DB2 7';
ok SQL::ReservedWords::DB2->is_reserved_by_db2v8('user'), 'USER is reserved by DB2 8';
+ok SQL::ReservedWords::DB2->is_reserved_by_db2v9('user'), 'USER is reserved by DB2 9';
ok SQL::ReservedWords::DB2->is_reserved('jar'), 'JAR is reserved';
ok ! SQL::ReservedWords::DB2->is_reserved_by_db2v5('jar'), 'JAR is not reserved DB2 5';
ok ! SQL::ReservedWords::DB2->is_reserved_by_db2v6('jar'), 'JAR is not reserved DB2 6';
ok SQL::ReservedWords::DB2->is_reserved_by_db2v7('jar'), 'JAR is reserved by DB2 7';
ok SQL::ReservedWords::DB2->is_reserved_by_db2v8('jar'), 'JAR is reserved by DB2 8';
+ok SQL::ReservedWords::DB2->is_reserved_by_db2v9('jar'), 'JAR is reserved by DB2 9';
ok SQL::ReservedWords::DB2->is_reserved('count'), 'COUNT is reserved';
ok SQL::ReservedWords::DB2->is_reserved_by_db2v5('count'), 'COUNT is reserved by DB2 5';
ok ! SQL::ReservedWords::DB2->is_reserved_by_db2v6('count'), 'COUNT is not reserved by DB2 6';
ok ! SQL::ReservedWords::DB2->is_reserved_by_db2v7('count'), 'COUNT is not reserved by DB2 7';
ok ! SQL::ReservedWords::DB2->is_reserved_by_db2v8('count'), 'COUNT is not reserved by DB2 8';
+ok SQL::ReservedWords::DB2->is_reserved_by_db2v9('count'), 'COUNT is reserved by DB2 9';
ok ! SQL::ReservedWords::DB2->is_reserved('bogus'), 'BOGUS is not reserved';
ok ! SQL::ReservedWords::DB2->is_reserved_by_db2v5('bogus'), 'BOGUS is not reserved by DB2 5';
ok ! SQL::ReservedWords::DB2->is_reserved_by_db2v6('bogus'), 'BOGUS is not reserved by DB2 6';
ok ! SQL::ReservedWords::DB2->is_reserved_by_db2v7('bogus'), 'BOGUS is not reserved by DB2 7';
ok ! SQL::ReservedWords::DB2->is_reserved_by_db2v8('bogus'), 'BOGUS is not reserved by DB2 8';
+ok ! SQL::ReservedWords::DB2->is_reserved_by_db2v9('bogus'), 'BOGUS is not reserved by DB2 9';
ok ! SQL::ReservedWords::DB2->is_reserved(undef), 'undef is not reserved';
is_deeply [ SQL::ReservedWords::DB2->reserved_by('user') ],
- [ 'DB2 5', 'DB2 6', 'DB2 7', 'DB2 8' ],
+ [ 'DB2 5', 'DB2 6', 'DB2 7', 'DB2 8', 'DB2 9' ],
'Got right reserved by for USER';
is_deeply [ SQL::ReservedWords::DB2->reserved_by('jar') ],
- [ 'DB2 7', 'DB2 8' ],
+ [ 'DB2 7', 'DB2 8', 'DB2 9' ],
'Got right reserved by for ACCESSIBLE';
is_deeply [ SQL::ReservedWords::DB2->reserved_by('count') ],
- [ 'DB2 5' ],
+ [ 'DB2 5', 'DB2 9' ],
'Got right reserved by for COUNT';
is_deeply [ SQL::ReservedWords::DB2->reserved_by('java') ],
- [ 'DB2 6', 'DB2 7' ],
+ [ 'DB2 6', 'DB2 7', 'DB2 9' ],
'Got right reserved by for JAVA';
is_deeply [ SQL::ReservedWords::DB2->reserved_by('bogus') ],
@@ -81,3 +86,4 @@
ok is_reserved_by_db2v6('user'), 'USER is reserved by DB2 6';
ok is_reserved_by_db2v7('user'), 'USER is reserved by DB2 7';
ok is_reserved_by_db2v8('user'), 'USER is reserved by DB2 8';
+ok is_reserved_by_db2v9('user'), 'USER is reserved by DB2 9';
--
To unsubscribe, e-mail: opensuse-commit+unsubscribe@opensuse.org
For additional commands, e-mail: opensuse-commit+help@opensuse.org