diff -Nru libsql-reservedwords-perl-0.7/Changes libsql-reservedwords-perl-0.8/Changes --- libsql-reservedwords-perl-0.7/Changes 2006-03-24 19:49:06.000000000 +0000 +++ libsql-reservedwords-perl-0.8/Changes 2012-08-30 12:37:19.000000000 +0000 @@ -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 -Nru libsql-reservedwords-perl-0.7/MANIFEST libsql-reservedwords-perl-0.8/MANIFEST --- libsql-reservedwords-perl-0.7/MANIFEST 2006-03-24 19:49:06.000000000 +0000 +++ libsql-reservedwords-perl-0.8/MANIFEST 2012-08-30 12:37:19.000000000 +0000 @@ -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 -Nru libsql-reservedwords-perl-0.7/META.json libsql-reservedwords-perl-0.8/META.json --- libsql-reservedwords-perl-0.7/META.json 1970-01-01 00:00:00.000000000 +0000 +++ libsql-reservedwords-perl-0.8/META.json 2012-08-30 12:37:19.000000000 +0000 @@ -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 -Nru libsql-reservedwords-perl-0.7/META.yml libsql-reservedwords-perl-0.8/META.yml --- libsql-reservedwords-perl-0.7/META.yml 2006-03-24 19:49:06.000000000 +0000 +++ libsql-reservedwords-perl-0.8/META.yml 2012-08-30 12:37:19.000000000 +0000 @@ -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 -Nru libsql-reservedwords-perl-0.7/Makefile.PL libsql-reservedwords-perl-0.8/Makefile.PL --- libsql-reservedwords-perl-0.7/Makefile.PL 2006-03-24 19:49:06.000000000 +0000 +++ libsql-reservedwords-perl-0.8/Makefile.PL 2012-08-30 12:37:19.000000000 +0000 @@ -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 -Nru libsql-reservedwords-perl-0.7/debian/changelog libsql-reservedwords-perl-0.8/debian/changelog --- libsql-reservedwords-perl-0.7/debian/changelog 2012-12-23 23:48:22.000000000 +0000 +++ libsql-reservedwords-perl-0.8/debian/changelog 2012-12-23 16:03:37.000000000 +0000 @@ -1,3 +1,23 @@ +libsql-reservedwords-perl (0.8-1) unstable; urgency=low + + [ Ansgar Burchardt ] + * debian/control: Convert Vcs-* fields to Git. + + [ gregor herrmann ] + * debian/control: update {versioned,alternative} (build) dependencies. + + [ Xavier Guimard ] + * Imported Upstream version 0.8 + * Bump Standards-Version to 3.9.4 + * Bump debhelper compatibility to 8 + * Add "libmodule-build-perl (>= 0.400000) | perl (>= 5.17.1)" dependency + * Update source format to 3.0 (quilt) + * Update d/copyright (years and format) and add Berne convention comment + * Update debian/rules to use "dh $@" + * Change short and long description + + -- Xavier Guimard Sun, 23 Dec 2012 17:01:06 +0100 + libsql-reservedwords-perl (0.7-1) unstable; urgency=low * Initial Release (closes: #473095) diff -Nru libsql-reservedwords-perl-0.7/debian/compat libsql-reservedwords-perl-0.8/debian/compat --- libsql-reservedwords-perl-0.7/debian/compat 2012-12-23 23:48:22.000000000 +0000 +++ libsql-reservedwords-perl-0.8/debian/compat 2012-12-23 16:03:37.000000000 +0000 @@ -1 +1 @@ -6 +8 diff -Nru libsql-reservedwords-perl-0.7/debian/control libsql-reservedwords-perl-0.8/debian/control --- libsql-reservedwords-perl-0.7/debian/control 2012-12-23 23:48:22.000000000 +0000 +++ libsql-reservedwords-perl-0.8/debian/control 2012-12-23 16:03:37.000000000 +0000 @@ -1,17 +1,25 @@ Source: libsql-reservedwords-perl +Maintainer: Debian Perl Group +Uploaders: Krzysztof Krzyżaniak (eloy) , + Xavier Guimard Section: perl Priority: optional -Build-Depends: debhelper (>= 6.0.10), libmodule-build-perl -Build-Depends-Indep: perl (>= 5.8.8-7), libsub-exporter-perl -Uploaders: Krzysztof Krzyżaniak (eloy) -Standards-Version: 3.7.3 -Maintainer: Debian Perl Group +Build-Depends: debhelper (>= 8), + libmodule-build-perl (>= 0.400000) | perl (>= 5.17.1), + perl +Build-Depends-Indep: libsub-exporter-perl +Standards-Version: 3.9.4 +Vcs-Browser: http://anonscm.debian.org/gitweb/?p=pkg-perl/packages/libsql-reservedwords-perl.git +Vcs-Git: git://git.debian.org/pkg-perl/packages/libsql-reservedwords-perl.git Homepage: http://search.cpan.org/dist/SQL-ReservedWords/ -Vcs-Svn: svn://svn.debian.org/pkg-perl/trunk/libsql-reservedwords-perl/ -Vcs-Browser: http://svn.debian.org/wsvn/pkg-perl/trunk/libsql-reservedwords-perl/ Package: libsql-reservedwords-perl Architecture: all -Depends: ${perl:Depends}, ${misc:Depends}, libsub-exporter-perl -Description: Reserved SQL words by ANSI/ISO - Determine if words are reserved by ANSI/ISO SQL standard. +Depends: ${misc:Depends}, + ${perl:Depends}, + libsub-exporter-perl +Description: Perl extension that indicates if words are reserved by SQL + SQL::ReservedWords determine if words are reserved by ANSI/ISO SQL standard or + by specific database such as PostgreSQL or MySQL. It can also check which + version of ANSI or specific database uses the word checked. + diff -Nru libsql-reservedwords-perl-0.7/debian/copyright libsql-reservedwords-perl-0.8/debian/copyright --- libsql-reservedwords-perl-0.7/debian/copyright 2012-12-23 23:48:22.000000000 +0000 +++ libsql-reservedwords-perl-0.8/debian/copyright 2012-12-23 16:03:37.000000000 +0000 @@ -1,23 +1,34 @@ -This is the debian package for the SQL-ReservedWords module. -It was created by Krzysztof Krzyzaniak (eloy) using dh-make-perl. - -It was downloaded from http://search.cpan.org/dist/SQL-ReservedWords/ - -The upstream author is: Christian Hansen C. - -Copyright 2006, Christian Hansen chansen@cpan.org - -This program is free software, you can redistribute it and/or modify it under -the same terms as Perl itself. - -Perl is distributed under licenses: - - a) the GNU General Public License as published by the Free Software - Foundation; either version 1, or (at your option) any later - version, or - - b) the "Artistic License" which comes with Perl. - - On Debian GNU/Linux systems, the complete text of the GNU General - Public License can be found in /usr/share/common-licenses/GPL' and - the Artistic Licence in /usr/share/common-licenses/Artistic'. +Format: http://www.debian.org/doc/packaging-manuals/copyright-format/1.0/ +Upstream-Name: SQL-ReservedWords +Source: http://search.cpan.org/dist/SQL-ReservedWords/ +Upstream-Contact: Christian Hansen C + +Files: * +Copyright: Christian Hansen C +License: Artistic or GPL-1+ +Comment: The upstream distribution does not contain an explicit statement of + copyright ownership. Pursuant to the Berne Convention for the Protection of + Literary and Artistic Works, it is assumed that all content is copyright by + its respective authors unless otherwise stated. + +Files: debian/* +Copyright: 2007, Krzysztof Krzyżaniak (eloy) + 2008-2012, gregor herrmann + 2012, Xavier Guimard +License: Artistic or GPL-1+ + +License: Artistic + This program is free software; you can redistribute it and/or modify + it under the terms of the Artistic License, which comes with Perl. + . + On Debian systems, the complete text of the Artistic License can be + found in `/usr/share/common-licenses/Artistic'. + +License: GPL-1+ + This program is free software; you can redistribute it and/or modify + it under the terms of the GNU General Public License as published by + the Free Software Foundation; either version 1, or (at your option) + any later version. + . + On Debian systems, the complete text of version 1 of the GNU General + Public License can be found in `/usr/share/common-licenses/GPL-1'. diff -Nru libsql-reservedwords-perl-0.7/debian/rules libsql-reservedwords-perl-0.8/debian/rules --- libsql-reservedwords-perl-0.7/debian/rules 2012-12-23 23:48:22.000000000 +0000 +++ libsql-reservedwords-perl-0.8/debian/rules 2012-12-23 16:03:37.000000000 +0000 @@ -1,61 +1,4 @@ #!/usr/bin/make -f -# This debian/rules file is provided as a template for normal perl -# packages. It was created by Marc Brockschmidt for -# the Debian Perl Group (http://pkg-perl.alioth.debian.org/) but may -# be used freely wherever it is useful. -# -# It was later modified by Jason Kohles -# http://www.jasonkohles.com/ to support Module::Build installed modules -export PERL_MM_USE_DEFAULT=1 -PACKAGE=$(shell dh_listpackages) - -ifndef PERL -PERL = /usr/bin/perl -endif - -TMP =$(CURDIR)/debian/$(PACKAGE) - -build: build-stamp -build-stamp: - dh_testdir - $(PERL) Build.PL installdirs=vendor - OPTIMIZE="-Wall -O2 -g" $(PERL) Build - touch build-stamp - -clean: - dh_testdir - dh_testroot - [ ! -f Build ] || $(PERL) Build distclean - dh_clean build-stamp install-stamp - -install: build install-stamp -install-stamp: - dh_testdir - dh_testroot - dh_clean -k - $(PERL) Build test - $(PERL) Build install destdir=$(TMP) - [ ! -d $(TMP)/usr/lib ] || rm -rf $(TMP)/usr/lib - touch install-stamp - -binary-arch: -# We have nothing to do by default. - -binary-indep: build install - dh_testdir - dh_testroot - dh_installdocs README - dh_installchangelogs Changes - dh_perl - dh_link - dh_strip - dh_compress - dh_fixperms - dh_installdeb - dh_gencontrol - dh_md5sums - dh_builddeb - -binary: binary-indep binary-arch -.PHONY: build clean binary-indep binary-arch binary +%: + dh $@ diff -Nru libsql-reservedwords-perl-0.7/debian/source/format libsql-reservedwords-perl-0.8/debian/source/format --- libsql-reservedwords-perl-0.7/debian/source/format 1970-01-01 00:00:00.000000000 +0000 +++ libsql-reservedwords-perl-0.8/debian/source/format 2012-12-23 23:48:22.886524166 +0000 @@ -0,0 +1 @@ +3.0 (quilt) diff -Nru libsql-reservedwords-perl-0.7/lib/SQL/ReservedWords/DB2.pm libsql-reservedwords-perl-0.8/lib/SQL/ReservedWords/DB2.pm --- libsql-reservedwords-perl-0.7/lib/SQL/ReservedWords/DB2.pm 2006-03-24 19:49:06.000000000 +0000 +++ libsql-reservedwords-perl-0.8/lib/SQL/ReservedWords/DB2.pm 2012-08-30 12:37:19.000000000 +0000 @@ -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 -Nru libsql-reservedwords-perl-0.7/lib/SQL/ReservedWords/MySQL.pm libsql-reservedwords-perl-0.8/lib/SQL/ReservedWords/MySQL.pm --- libsql-reservedwords-perl-0.7/lib/SQL/ReservedWords/MySQL.pm 2006-03-24 19:49:06.000000000 +0000 +++ libsql-reservedwords-perl-0.8/lib/SQL/ReservedWords/MySQL.pm 2012-08-30 12:37:19.000000000 +0000 @@ -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 -Nru libsql-reservedwords-perl-0.7/lib/SQL/ReservedWords/ODBC.pm libsql-reservedwords-perl-0.8/lib/SQL/ReservedWords/ODBC.pm --- libsql-reservedwords-perl-0.7/lib/SQL/ReservedWords/ODBC.pm 2006-03-24 19:49:06.000000000 +0000 +++ libsql-reservedwords-perl-0.8/lib/SQL/ReservedWords/ODBC.pm 2012-08-30 12:37:19.000000000 +0000 @@ -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 -Nru libsql-reservedwords-perl-0.7/lib/SQL/ReservedWords/Oracle.pm libsql-reservedwords-perl-0.8/lib/SQL/ReservedWords/Oracle.pm --- libsql-reservedwords-perl-0.7/lib/SQL/ReservedWords/Oracle.pm 2006-03-24 19:49:06.000000000 +0000 +++ libsql-reservedwords-perl-0.8/lib/SQL/ReservedWords/Oracle.pm 2012-08-30 12:37:19.000000000 +0000 @@ -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 -Nru libsql-reservedwords-perl-0.7/lib/SQL/ReservedWords/PostgreSQL.pm libsql-reservedwords-perl-0.8/lib/SQL/ReservedWords/PostgreSQL.pm --- libsql-reservedwords-perl-0.7/lib/SQL/ReservedWords/PostgreSQL.pm 2006-03-24 19:49:06.000000000 +0000 +++ libsql-reservedwords-perl-0.8/lib/SQL/ReservedWords/PostgreSQL.pm 2012-08-30 12:37:19.000000000 +0000 @@ -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 -Nru libsql-reservedwords-perl-0.7/lib/SQL/ReservedWords/SQLServer.pm libsql-reservedwords-perl-0.8/lib/SQL/ReservedWords/SQLServer.pm --- libsql-reservedwords-perl-0.7/lib/SQL/ReservedWords/SQLServer.pm 2006-03-24 19:49:06.000000000 +0000 +++ libsql-reservedwords-perl-0.8/lib/SQL/ReservedWords/SQLServer.pm 2012-08-30 12:37:19.000000000 +0000 @@ -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 -Nru libsql-reservedwords-perl-0.7/lib/SQL/ReservedWords/SQLite.pm libsql-reservedwords-perl-0.8/lib/SQL/ReservedWords/SQLite.pm --- libsql-reservedwords-perl-0.7/lib/SQL/ReservedWords/SQLite.pm 2006-03-24 19:49:06.000000000 +0000 +++ libsql-reservedwords-perl-0.8/lib/SQL/ReservedWords/SQLite.pm 2012-08-30 12:37:19.000000000 +0000 @@ -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 -Nru libsql-reservedwords-perl-0.7/lib/SQL/ReservedWords/Sybase.pm libsql-reservedwords-perl-0.8/lib/SQL/ReservedWords/Sybase.pm --- libsql-reservedwords-perl-0.7/lib/SQL/ReservedWords/Sybase.pm 2006-03-24 19:49:06.000000000 +0000 +++ libsql-reservedwords-perl-0.8/lib/SQL/ReservedWords/Sybase.pm 2012-08-30 12:37:19.000000000 +0000 @@ -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 -Nru libsql-reservedwords-perl-0.7/lib/SQL/ReservedWords.pm libsql-reservedwords-perl-0.8/lib/SQL/ReservedWords.pm --- libsql-reservedwords-perl-0.7/lib/SQL/ReservedWords.pm 2006-03-24 19:49:06.000000000 +0000 +++ libsql-reservedwords-perl-0.8/lib/SQL/ReservedWords.pm 2012-08-30 12:37:19.000000000 +0000 @@ -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 -Nru libsql-reservedwords-perl-0.7/scripts/sqlrw libsql-reservedwords-perl-0.8/scripts/sqlrw --- libsql-reservedwords-perl-0.7/scripts/sqlrw 2006-03-24 19:49:06.000000000 +0000 +++ libsql-reservedwords-perl-0.8/scripts/sqlrw 2012-08-30 12:37:19.000000000 +0000 @@ -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 -Nru libsql-reservedwords-perl-0.7/t/05-db2.t libsql-reservedwords-perl-0.8/t/05-db2.t --- libsql-reservedwords-perl-0.7/t/05-db2.t 2006-03-24 19:49:06.000000000 +0000 +++ libsql-reservedwords-perl-0.8/t/05-db2.t 2012-08-30 12:37:19.000000000 +0000 @@ -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';