Using the SQL Wizard

You can use the SQL Wizard to create an SQL statement and test it. The graphical user interface of the SQL Wizard makes it much easier to create an SQL statement, compared to typing in the entire text of the SQL statement into the Statement field of the AME. Also, in the SQL Wizard you can run an SQL statement that you are working on and view the results.

1. Click SQL Wizard to start the wizard.
   • If there is any information already in the fields of the statement section, then HCL ZIETrans uses this information to initialize the corresponding fields in the SQL Wizard.
2. Use the SQL Wizard to create an SQL statement and test it.
3. To close the SQL Wizard without changing your macro, click Cancel.
4. To save the SQL statement to your macro, do one of the following actions:
   • On the Review tab of the SQL Wizard, click Save.
   • On the Results tab of the SQL Wizard, click Save SQL.
   The AME writes the information that you created in the SQL Wizard into the appropriate fields of the statement section. Any already existing information in the fields of the statement section is overwritten. If the information that the AME writes into a field is a string (for example, the information written into the Database URL field), then the AME also automatically correctly formats the string depending on the underlying macro type. The following fields are updated
   • Fields in the statement section:
     • Database URL
     • Driver Identifier
     • Driver Class
     • User ID
     • Password
     • Statement
5. Click Cancel to close the SQL Wizard.