package net.sourceforge.phpdt.sql.adapters;

public class DB2Adapter extends DatabaseAdapter {
    public String getShowTableQuery(DatabaseInfo info) {
        return "SELECT TABNAME FROM syscat.tables WHERE tabschema = '" + info.getSchema().toUpperCase() + "' AND TYPE='T'"; //$NON-NLS-1$ //$NON-NLS-2$
    }
    public String getShowViewQuery(DatabaseInfo info) {
        return "SELECT TABNAME FROM syscat.tables WHERE tabschema = '" + info.getSchema().toUpperCase() + "' AND TYPE='V'"; //$NON-NLS-1$ //$NON-NLS-2$
    }
    public String getShowSequenceQuery(DatabaseInfo info) {
        return "SELECT SEQNAME FROM sysibm.syssequences WHERE seqschema = '" + info.getSchema().toUpperCase() + "'"; //$NON-NLS-1$ //$NON-NLS-2$
    }
    public String getNextValue(String sequence) {
        return "VALUES NEXTVAL FOR " + sequence; //$NON-NLS-1$
    }
}