X-Git-Url: http://git.phpeclipse.com diff --git a/archive/net.sourceforge.phpeclipse.sql/src/net/sourceforge/phpdt/sql/adapters/DB2Adapter.java b/archive/net.sourceforge.phpeclipse.sql/src/net/sourceforge/phpdt/sql/adapters/DB2Adapter.java new file mode 100644 index 0000000..b92fbac --- /dev/null +++ b/archive/net.sourceforge.phpeclipse.sql/src/net/sourceforge/phpdt/sql/adapters/DB2Adapter.java @@ -0,0 +1,19 @@ +package net.sourceforge.phpdt.sql.adapters; + +public class DB2Adapter extends DatabaseAdapter { + public String getShowTableQuery(DatabaseInfo info) { + return "SELECT TABNAME FROM syscat.tables WHERE tabschema = '" + info.getSchema().toUpperCase() + "' AND TYPE='T'"; + } + public String getShowViewQuery(DatabaseInfo info) { + return "SELECT TABNAME FROM syscat.tables WHERE tabschema = '" + info.getSchema().toUpperCase() + "' AND TYPE='V'"; + } + public String getShowSequenceQuery(DatabaseInfo info) { + return "SELECT SEQNAME FROM sysibm.syssequences WHERE seqschema = '" + info.getSchema().toUpperCase() + "'"; + } + public String getNextValue(String sequence) { + return "VALUES NEXTVAL FOR " + sequence; + } + public DatabaseAdapter getInstance() { + return new DB2Adapter(); + } +}