SQL Plugin copied from Quantum plugin and refactored for PHPEclipse

[phpeclipse.git] / archive / net.sourceforge.phpeclipse.sql / src / net / sourceforge / phpdt / sql / adapters / DB2Adapter.java

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 (file)
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();
+       }
+}