initial quantum version

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

diff --git a/archive/net.sourceforge.phpeclipse.quantum.sql/src/com/quantum/adapters/DB2Adapter.java b/archive/net.sourceforge.phpeclipse.quantum.sql/src/com/quantum/adapters/DB2Adapter.java
new file mode 100644 (file)
index 0000000..ca5dd76
--- /dev/null
+++ b/archive/net.sourceforge.phpeclipse.quantum.sql/src/com/quantum/adapters/DB2Adapter.java
@@ -0,0 +1,21 @@
+package com.quantum.adapters;
+
+import com.quantum.sql.SQLHelper;
+
+public class DB2Adapter extends DatabaseAdapter {
+    public String getShowTableQuery(String qualifier, boolean isDefault) {
+        return "SELECT TABNAME FROM syscat.tables WHERE tabschema = '" + qualifier.toUpperCase() + "' AND TYPE='T'"; //$NON-NLS-1$ //$NON-NLS-2$
+    }
+    public String getShowViewQuery(String qualifier, boolean isDefault) {
+        return "SELECT TABNAME FROM syscat.tables WHERE tabschema = '" + qualifier.toUpperCase() + "' AND TYPE='V'"; //$NON-NLS-1$ //$NON-NLS-2$
+    }
+    public String getShowSequenceQuery(String qualifier, boolean isDefault) {
+        return "SELECT SEQNAME FROM sysibm.syssequences WHERE seqschema = '" + qualifier.toUpperCase() + "'"; //$NON-NLS-1$ //$NON-NLS-2$
+    }
+    public String getNextValue(String sequence, String owner) {
+               return "VALUES NEXTVAL FOR " + SQLHelper.getQualifiedName(owner, sequence); //$NON-NLS-1$
+    }
+       public String getPrevValue(String sequence, String owner) {
+               return "VALUES PREVVAL FOR " + SQLHelper.getQualifiedName(owner, sequence); //$NON-NLS-1$
+       }
+}