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$
+ "' AND TABLE_TYPE IN ('T', 'P')"; //$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$
+ "' AND TABLE_TYPE IN ('V', 'L')"; //$NON-NLS-1$ //$NON-NLS-2$
}
}