3.9 Using Saved Commands

You can access the commands you save and commands saved by other users in the same workspace.

You can also access SQL commands you and other users of the same workspace saved from the Query Builder.

3.9.1 Accessing Saved Commands

From the SQL Commands page, click the Saved SQL tab, click the title of the command to load it into the command editor, and click Run.

To access saved SQL commands:

  1. On the Workspace home page, click SQL Workshop and then SQL Commands.

    The SQL Commands page appears.

  2. Click the Saved SQL tab.

    The Saved SQL list of commands appears in the display pane.

  3. Click the title of the command to load it into the command editor.

    The command appears in the editor.

  4. Click Run to execute the command.

3.9.2 About the Saved SQL Pane

The Saved SQL pane displays a list of all commands saved under the current workspace.

The list displays commands saved from SQL Commands and SQL commands saved from Query Builder. Saved SQL commands must have unique names in the current workspace. The same name cannot be used in the Query Builder and SQL Commands.

Each command entry shows the owner name, the command name, a description if it exists, the first characters of the SQL command, who last updated the command and when.

On the Saved SQL pane you can:

  • Show commands by owner - Make a selection from the Owner list to specify the user whose commands you want to display. To view all scripts select -All Users-.

  • Search for a command - Enter a command name or partial name, or enter a code snippet in the Find field and click Go. To view all scripts, leave the Find field blank and click Go. You control how many rows display by making a selection from the Rows list.

  • Set the Number of Output Rows - Make a selection from the Display list to specify the number of Saved SQL commands to display simultaneously.

  • Delete a command - Click the check box associated with a command and click Delete Checked.