Entering a New SQL Statement

To enter an SQL statement, perform one of the following actions:

• Select the New option on the SQL menu. The NEW screen appears and indicates that you are using the SQL editor, as Figure 9 shows.
  Figure 9. The NEW Screen for Entering New SQL Statements

  NEW:  ESC   = Done editing      CTRL-A = Typeover/Insert    CTRL-R = Redraw
        CTRL-X = Delete character CTRL-D = Delete rest of line
  
  -------------- mystores@dbserver1 ----------- Press CTRL-W for Help -----
     

• If you prefer to work with a different editor from the one that is installed on your system, select the Use-editor option. This option is described in Using a System Editor.

As Figure 9 shows, the NEW screen starts with the cursor positioned below the header, which indicates where you enter text on the screen. Use the editor to enter statements and edit them before you run them. To string several SQL statements together, separate them with a semicolon.

On Extended Parallel Server, the DB-Access menu appears slightly different. It includes the CTRL-B and CTRL-F options which are used to scroll through the command history.