WhereScape RED includes a script editor which allows the maintenance of any host scripts within the data warehouse. The editor is invoked by double-clicking on a script name in the left pane or by right-clicking the script name and then selecting Edit the Script from the context menu.
Similar to the procedure editor, the script editor includes the following features:

  • bash/DOS/PowerShell syntax highlighting
  • improved find feature (repeated find, up and down, etc.)
  • toggle the display of line numbering
  • a status bar that includes line number, line length, selected text length, etc.
  • a context sensitive toolbar
  • tab to space conversion and vice versa
  • uppercase, lowercase, titlecase text conversion command
  • increase/decrease test indent command
  • bookmark support

Indenting code
The tab character inserts four spaces into the text. A shift/tab removes four spaces.
Cut, Copy, Paste and Delete
The normal Windows cut, copy, paste and delete functions are available either through the toolbar or via the right mouse click context menu.
Indenting a block of text
A selected block of text can be indented by four spaces by depressing the tab character. Each tab will be indented by a further four spaces. A shift/tab will remove four spaces from the front of each line in the selected block.
Viewing other scripts
During the editing process it is possible to pop up a window containing other scripts. This window allows cut-and-paste operations. In such a way it can be used as a work area or as a source of code. Select the Tools > View Script or Template menu option to bring up the viewer window.  
Several drop-down list boxes can be chosen from. Once an item is selected the viewer loads the code and moves to the right side of the edit window. The various options are:

  • Version: A previously saved version of this script. The description and time are shown.
  • Script: Some other script is stored within the WhereScape RED metadata.
  • Template: A template script as defined in the WhereScape RED metadata.

Once an item is chosen, the viewer appears on the right side of the edit window. The viewer or the main edit window can receive the focus by clicking the mouse within the appropriate window. Code can be cut from one window and pasted into the other. Any changes made in the viewer window cannot be saved. 

Editing, deleting, or compiling Locked for Edit or opened procedures/scripts

  • Procedures or scripts cannot be deleted if they are Locked for Edit by any user, checked out by another user or if there is another object that has the same associated procedures or scripts.
  • Saving or Compiling in the procedure or script edit window cannot be performed if the procedures or scripts become Locked for Edit by other users after the edit window has been opened.
  • Procedures or scripts cannot be deleted or modified after the editor window has been opened unless the Edit Lock has been released. Edit Locks can be released by any user in the Script or Procedure Properties screen.
  • To prevent updates, deletes, and modifications to certain procedures or scripts, it is best to use the Check Out functionality instead. For more information about this functionality, refer to Object Check Outs and Check Ins for details.


  • No labels