In Interactive SQL, you can store frequently-used SQL script files and connections in a favorites list. A favorites list is specific to a single user and cannot be seen by other users.
Open the SQL script file that you want to add to your favorites.
Click Favorites » Add To Favorites.
Click Add the open file 'filename'. In the Name field, type a name for the sql file.
Click OK.
Type the SQL statements that you want to add to your favorites in the SQL Statements pane. The contents in the SQL Statements pane cannot exceed 16384 characters.
Click Favorites » Add To Favorites.
Click Add SQL Statements. In the Name field, type a name for the favorite.
Click OK.
Connect to a database.
Click Favorites » Add To Favorites.
Click Save The Connection Password. In the Name field, type a name for the connection.
Click OK.
Click Favorites » Show Favorites.
The Favorites pane appears on the left side of the Interactive SQL window.
Click Favorites and choose the favorite you want to open.
Click Favorites » Show Favorites.
The Favorites pane appears on the left side of the Interactive SQL window.
Select a favorite, right-click, and then click Edit.
Follow the instructions in the window.
Click Save.
Sharing favorite SQL script files and connections
Discuss this page in DocCommentXchange.
|
Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1 |