Added support for DB2 on AS/400 or ISeries

First push of the modified version of the DB2as400 package

NB: the metadata table must be uppercase or the Table.exists() method won't find it
(perhaps a bug in the JTOPEN JDBC driver ?)

So for instance:
flyway.table=MY_SCHEMA
Hi rotatomel,

I made some tests with this...

SELECT COUNT(*) FROM sysibm.schemata WHERE schema_name=?
select count(*) from systables where table_schema = ?
select count(*) from sysviews where table_schema = ?
select count(*) from qsys2.syssequences where sequence_schema = ?
select count(*) from sysindexes where table_schema = ?
select count(*) from sysibm.sqlprocedures where procedure_schem = ?
select count(*) from sysibm.sqlfunctions where function_schem = ?

On Thu, Oct 16, 2014 at 5:25 PM, rotatomel <notifications@github.com> wrote:

> In
> flyway-core/src/main/java/org/flywaydb/core/internal/dbsupport/db2as400/DB2as400Schema.java:
>
> > +import org.flywaydb.core.internal.dbsupport.db2.DB2Schema;
> > +import org.flywaydb.core.internal.dbsupport.db2.DB2Table;
> > +import org.flywaydb.core.internal.util.StringUtils;
> > +
> > +import java.sql.SQLException;
> > +import java.util.ArrayList;
> > +import java.util.List;
> > +import java.util.Map;
> > +
> > +/**
> > + * DB2/AS400 implementation of Schema.
> > + */
> > +public class DB2as400Schema extends DB2Schema {
> > +	
> > +	// System schema name
> > +	private String systemSchema = "SYSCAT";
>
> Well, after searching and testing the catalog is in QSYS2 not in SYSIBM.
> For example, sequences are not un SYSIBM.
>
> http://www-01.ibm.com/support/knowledgecenter/ssw_ibm_i_53/db2/rbafzmstcatalogtbls.htm
>
> —
> Reply to this email directly or view it on GitHub
> <https://github.com/flyway/flyway/pull/864/files#r18967447>.
>



-- 
--------------
Daniel Novo