Configuring MySQL Adapter SQL Statement Properties

Enter the MySQL Adapter SQL statement parameters.

What You Can Do from the Run a SQL Statement Page

You can specify the following values on the Run a SQL Statement page. The Run a SQL Statement page is the wizard page that is displayed if you selected SQL statement as the operation type on the Basic Info page.

  • Enter a SQL query.
  • Click Validate SQL Query to ensure that your query has correct syntax and specifies tables, fields, and values that exist.
  • Ensure that after you click Validate SQL Query, the Status field displays Success!.

What You See on the Run a SQL Statement Page

The following table describes the key information on the Run a SQL Statement page.

Element Description

SQL Query

Enter a SQL query.

Status

After you click Validate SQL Query, ensure the Status field displays Success!.