protected void sql() {
LoadSatMeta metaH = new LoadSatMeta();
getInfo(metaH);
try {
SQLStatement sql = metaH.getSQLStatements(transMeta, stepMeta, null, repository, metaStore);
if (!sql.hasError()) {
if (sql.hasSQL()) {
SQLEditor sqledit =
new SQLEditor(
transMeta,
shell,
SWT.NONE,
metaH.getDatabaseMeta(),
transMeta.getDbCache(),
sql.getSQL());
sqledit.open();
} else {
MessageBox mb = new MessageBox(shell, SWT.OK | SWT.ICON_INFORMATION);
mb.setMessage(BaseMessages.getString(PKG, "LoadMeta.NoSQL.DialogMessage"));
mb.setText(BaseMessages.getString(PKG, "LoadMeta.NoSQL.DialogTitle"));
mb.open();
}
} else {
MessageBox mb = new MessageBox(shell, SWT.OK | SWT.ICON_ERROR);
mb.setMessage(sql.getError());
mb.setText(BaseMessages.getString(PKG, "System.Dialog.Error.Title"));
mb.open();
}
} catch (KettleException ke) {
new ErrorDialog(
shell,
BaseMessages.getString(PKG, "LoadDialog.BuildSQLError.DialogTitle"),
BaseMessages.getString(PKG, "LoadDialog.BuildSQLError.DialogMessage"),
ke);
}
}
