Highlighting the sql syntax, Managing the layout of panes – HP Integrity NonStop J-Series User Manual

Page 107

Table 34 File menu options

Function

Menu item

Loads the text of an SQL statement from an ASCII file to the Statement field.

Load SQL Statement

Saves the current SQL statement text from the Statement field to an ASCII file. This
command saves only the statement text, but not the statement results. To save the results,
use the Data to Clipboard, Data To Spreadsheet, or the Data to File options.

Save SQL Statement

Related Topic

“Copying data” (page 45)

Highlighting the SQL syntax

To highlight the SQL syntax in the Statement pane, select Format

→Highlight Syntax. The SQL

keywords in the SQL text are highlighted.

Managing the layout of panes

The SQL Whiteboard enables you to move and resize individual panes. After setting the layout,
select File

→Lock Layout to lock the layout. Subsequently, you cannot move or resize the Statement,

Statement List, and Statement Detail panes. To unlock the layout, select File

→Unlock Layout.

To reset the layout to the default configuration, select File

→Reset Layout.

To ensure that the layout persists across SQL Whiteboard or MXDM invocations, select File

→Save

Persistence. Subsequently, when you launch the SQL Whiteboard either in the current instance of
MXDM or in a restarted MXDM instance, the layout is restored.

NOTE:

The Export Persistence option in the File menu, in the SQL Whiteboard and the Export

Persistence option in the main window have the same effect.