The statement and results section

The SQLQuery action window has two main sections: a statement section and a result section.

The statement section occupies the upper area of the window and includes the following fields: Database URL, Driver Identifier, Driver Class, User ID, Password, and Statement. You can modify the information in this section in two ways:
  • By creating an SQL statement in the SQL Wizard.
  • By typing the information into the fields.
You can also edit any of the fields at any time by typing into the field.

The result section occupies the lower area of the window and includes the remaining field: Output Result To (the $HMLSQLUtil$ macro variable).