Setting Connection Information for Multiple SQL Files

Set the connection information for multiple SQL files simultaneously from WorkSpace Navigator.

  1. In WorkSpace Navigator, expand the tree view for the projects containing the SQL files for which you want to change connection information.
  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 choose Set Connection Info.
  4. Select or unselect SQL files listed in the grid.

    Each SQL file is listed with its data server type, connection profile, and database name.

  5. (Optional) Rearrange the list of files.

    Highlight items in the grid, and use Up or Down to reposition the items.

  6. Specify a Database Server Type, Connection Profile Name, and Database Name for the selected SQL files.
  7. Click Create to create a new connection profile.
  8. (Optional) To remain disconnected from the database server, select Do Not Connect Now; otherwise, Sybase WorkSpace attempts to connect to the database.
  9. Click OK to set the new connection information.
Parent topic: Set Up
Related concepts
Connection Profiles
SQL Editor
Related tasks
Creating a SQL File

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