SQL Plugin copied from Quantum plugin and refactored for PHPEclipse

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

diff --git a/archive/net.sourceforge.phpeclipse.sql/src/net/sourceforge/phpdt/sql/adapters/DB2AS400Adapter.java b/archive/net.sourceforge.phpeclipse.sql/src/net/sourceforge/phpdt/sql/adapters/DB2AS400Adapter.java
new file mode 100644 (file)
index 0000000..1e9db37
--- /dev/null
+++ b/archive/net.sourceforge.phpeclipse.sql/src/net/sourceforge/phpdt/sql/adapters/DB2AS400Adapter.java
@@ -0,0 +1,13 @@
+package net.sourceforge.phpdt.sql.adapters;
+
+public class DB2AS400Adapter extends DatabaseAdapter {
+    public String getShowTableQuery(DatabaseInfo info) {
+        return "SELECT TABLE_NAME FROM QSYS2.SYSTABLES WHERE table_schema  = '" + info.getSchema().toUpperCase() + "' AND TABLE_TYPE = 'P'";
+    }
+    public String getShowViewQuery(DatabaseInfo info) {
+        return "SELECT TABLE_NAME FROM QSYS2.SYSTABLES WHERE table_schema  = '" + info.getSchema().toUpperCase() + "' AND TABLE_TYPE = 'L'";
+    }
+       public DatabaseAdapter getInstance() {
+               return new DB2AS400Adapter();
+       }
+}