Executing Multiple SQL Files

Execute multiple SQL files from WorkSpace Navigator.

  1. In WorkSpace Navigator, expand the tree view for the projects containing the SQL files you want to execute.
  2. Press and hold the Ctrl key, and select two or more SQL files.
  3. Release the Ctrl key, right-click a selected SQL file, and select Execute SQL Files.
  4. Select or deselect SQL files listed in the grid.

    Each SQL file is listed with its data server type, connection profile, and database name. To change the order of execution of the SQL files, rearrange the list of files by highlighting the items in the grid and using the Up or Down buttons to reposition the items.

  5. Specify a Database Server Type, Connection Profile Name, and Database Name for the selected SQL files, or click Create to define a new connection profile for the database server.
  6. (Optional) Select Persist the Target Connection Information to make the data server, connection profile, and database settings persist for the selected SQL files after execution.
  7. Click OK to execute the SQL files.

    The execution results display in the SQL Results view.

Parent topic: Run
Related concepts
SQL Scrapbook

Created June 25, 2009. Send feedback on this help topic to Sybase Technical Publications: pubs@sybase.com