archive/net.sourceforge.phpeclipse.quantum.sql/src/com/quantum/adapters/DB2AS400Adapter.java

   1 package com.quantum.adapters;
   2
   3
   4 public class DB2AS400Adapter extends DatabaseAdapter {
   5         protected DB2AS400Adapter() {
   6                 super(AdapterFactory.DB2AS400);
   7         }
   8         public String getShowTableQuery(String qualifier) {
   9         return "SELECT table_schema, TABLE_NAME FROM QSYS2.SYSTABLES " +
  10                         "WHERE table_schema  = '" +
  11                         qualifier.toUpperCase() +
  12                                 "' AND TABLE_TYPE IN ('T', 'P')";
  13     }
  14     public String getShowViewQuery(String qualifier) {
  15         return "SELECT table_schema, TABLE_NAME FROM QSYS2.SYSTABLES " +
  16                         "WHERE table_schema  = '" +
  17                         qualifier.toUpperCase() +
  18                          "' AND TABLE_TYPE IN ('V', 'L')";
  19     }
  20 }