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();
	}
}