X-Git-Url: http://git.phpeclipse.com

diff --git a/archive/net.sourceforge.phpeclipse.quantum.sql/src/com/quantum/adapters/DB2AS400Adapter.java b/archive/net.sourceforge.phpeclipse.quantum.sql/src/com/quantum/adapters/DB2AS400Adapter.java
index d31c905..755b768 100644
--- a/archive/net.sourceforge.phpeclipse.quantum.sql/src/com/quantum/adapters/DB2AS400Adapter.java
+++ b/archive/net.sourceforge.phpeclipse.quantum.sql/src/com/quantum/adapters/DB2AS400Adapter.java
@@ -6,13 +6,15 @@ public class DB2AS400Adapter extends DatabaseAdapter {
 		super(AdapterFactory.DB2AS400);
 	}
 	public String getShowTableQuery(String qualifier) {
-        return "SELECT TABLE_NAME FROM QSYS2.SYSTABLES WHERE table_schema  = '" + 
+        return "SELECT table_schema, TABLE_NAME FROM QSYS2.SYSTABLES " +
+        		"WHERE table_schema  = '" + 
         		qualifier.toUpperCase() + 
-				"' AND TABLE_TYPE IN ('T', 'P') AND SYSTEM_TABLE= 'N'"; //$NON-NLS-1$ //$NON-NLS-2$
+				"' AND TABLE_TYPE IN ('T', 'P')"; 
     }
     public String getShowViewQuery(String qualifier) {
-        return "SELECT TABLE_NAME FROM QSYS2.SYSTABLES WHERE table_schema  = '" +
+        return "SELECT table_schema, TABLE_NAME FROM QSYS2.SYSTABLES " +
+        		"WHERE table_schema  = '" +
         		qualifier.toUpperCase() +
-        		 "' AND TABLE_TYPE IN ('V', 'L') AND SYSTEM_TABLE= 'N'"; //$NON-NLS-1$ //$NON-NLS-2$
+        		 "' AND TABLE_TYPE IN ('V', 'L')";
     }
 }