preparing new release
[phpeclipse.git] / 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 }