Using Host Variables

Restriction: This topic applies to Windows environments only.

When you include host variables in batch SQL scripts, you are prompted for values. You can also specify values for host variables by using the Parameters command from the Query menu so that you will not be prompted at run time for values.

To run a batch SQL script that uses host variables:

  1. Select the Run Batch command from the File menu.

    SQLWizard displays the Run Batch dialog box.

  2. Choose the .SQL file you want to run; then click OK.

    The selected batch SQL script is loaded and it begins to execute.

  3. When prompted for host variables, type in the value.
  4. Click the Quotes checkbox if the value needs to be enclosed in quotes.

    Results of the batch SQL script are displayed in the Result window.

Parent topic: Use Batch SQL Scripts