package com.quantum.adapters;


public class DB2AS400Adapter extends DatabaseAdapter {
	protected DB2AS400Adapter() {
		super(AdapterFactory.DB2AS400);
	}
	public String getShowTableQuery(String qualifier) {
        return "SELECT 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$
    }
    public String getShowViewQuery(String qualifier) {
        return "SELECT 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$
    }
}