@Override
protected void sqlDrop(final String tableName, final IDfSession session) {
try {
final String query = "select * from dm_dbo." + tableName + " enable(return_top 1) ";
DeployUtil.execDqlVoid(query, session);
LOGGER.info("Drop: " + tableName);
final String qr =
"execute exec_sql with query=" + DeployUtil.prepareForExecSQL("drop view " + tableName);
DeployUtil.execDqlVoid(qr, session);
} catch (final DfException e) {
LOGGER.warn("Problem dropping view. Skipped: " + e.getMessage());
}
}
@Override
protected String getCreateStatement(final String vwName) {
return "create view "
+ getTableName(vwName)
+ " as select s.code, s.term, s.obsolete, s.sort_key from ajwf_va_root_s s where s.va_type="
+ DeployUtil.singleQuote(vwName);
}
@Override
protected String getDropStatement(final String in) {
return "execute exec_sql with query="
+ DeployUtil.prepareForExecSQL("drop view ajwf_" + in.trim());
}