Adding/Updating SQL statement schema

These tools assist you in creating and modifying specified schema from a SQL statement for an individual database thread.

  1. Select Add SQL Statement Schema to open the SQL Statement Schema Configurator dialog box.
  2. Select Simple SQL or Complex SQL to open the Inbound (Outbound) SQL Statement Configurator dialog box to aid in defining SQL statements.
  3. Make your selections and click OK.
    This updates the SQL Statement field in the SQL Statement Schema Configurator dialog box.
  4. Click OK on the SQL Statement Schema Configurator dialog box.
    This adds the schema of the SQL statement into the Table Schema List on the main dialog box.
  5. Select Update SQL Statement Schema to open the SQL Statement Schema Configurator dialog box.
    This is filled by the selected SQL statement schema entry from the Table Schema List. This is where you can update the SQL statement or entry name.
  6. Click OK to regenerate and update the SQL statement schema.